ADO.NET Entity Framework Support

Welcome to UserVoice forum for suggestions on improvement of Entity Framework support in ADO.NET providers for Oracle, MySQL, PostgreSQL, and SQLite from Devart http://www.devart.com/dotconnect/ .

We would be glad to see your suggestions and comments.

Please post here the suggestions about Entity Framework run-time features, Code First support, integration to Visual Studio Entity Data Model Wizard/Update From Database Wizard/Generate Database Wizard.

How can we improve Entity Framework support in our dotConnect data providers?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the “My feedback” filter and select “My open ideas”.
(thinking…)
Reset

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can vote and comment on it.

If it doesn't exist, you can post your idea so others can vote on it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
    1. Unique Constraints in the Entity Framework

      The Microsoft EF team is currently designing unique constraint support in EF. See http://blogs.msdn.com/b/efdesign/archive/2011/03/09/unique-constraints-in-the-entity-framework.aspx. Vote for this to make sure this is also supported by DevArt's provider.

      90 votes
      Vote 0 votes Vote Vote
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service

        You'll receive a confirmation email with a link to create a password (optional).

        Signed in as (Sign out)
        You have left! (?) (thinking…)
      • 31 votes
        Vote 0 votes Vote Vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service

          You'll receive a confirmation email with a link to create a password (optional).

          Signed in as (Sign out)
          You have left! (?) (thinking…)
        • Filter Available Objects in EDM Wizard for Oracle

          Let user filter objects, available in the EDM Wizard, by owner/grants/privileges/etc.

          31 votes
          Vote 0 votes Vote Vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service

            You'll receive a confirmation email with a link to create a password (optional).

            Signed in as (Sign out)
            You have left! (?) (thinking…)
          • Oracle 8 and 9.1 Support

            Add support for Oracle 8 and 9.1

            23 votes
            Vote 0 votes Vote Vote
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service

              You'll receive a confirmation email with a link to create a password (optional).

              Signed in as (Sign out)
              You have left! (?) (thinking…)
            • EF Code First: Dynamic Database Creation configurability

              Additional options for dynamic database creation:
              - whether to create named constraints
              - naming rules for primary keys, foreign keys, sequences, triggers
              - identity column processing for Oracle database
              - specifying tablespace for Oracle database

              20 votes
              Vote 0 votes Vote Vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service

                You'll receive a confirmation email with a link to create a password (optional).

                Signed in as (Sign out)
                You have left! (?) (thinking…)
                under review  ·  0 comments  ·  Admin →
              • <ProviderName>EntityProviderConfig via app.config

                Implement functionality <ProviderName>EntityProviderConfig in Oracle, MySQL, PostgreSQL, and SQLite via *.config file of your application. Currently it can be done only in code: http://www.devart.com/blogs/dotconnect/index.php/new-features-of-entity-framework-support-in-dotconnect-providers.html .

                15 votes
                Vote 0 votes Vote Vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service

                  You'll receive a confirmation email with a link to create a password (optional).

                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                • Correct Generation of SQL for SELECT Statement with NULL Parameter

                  Implement a workaround for Entity Framework bug
                  ( http://stackoverflow.com/questions/682429/how-can-i-query-for-null-values-in-entity-framework )
                  so that users don't need to write a more complex LINQ to Entities query to avoid this bug.

                  14 votes
                  Vote 0 votes Vote Vote
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service

                    You'll receive a confirmation email with a link to create a password (optional).

                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                  • Automate creating an Oracle ssdl from a SQL ssdl

                    I would like to have an Oracle ssdl gererated for my sql model.edmx. This would make using dotconnect with EF much more realistic for lots of customers.
                    A t4 template that uses the sql ssdl from the edmx file and generates a matching oracle ssdl would be a good solution. Is it as easy as just updating the types?

                    9 votes
                    Vote 0 votes Vote Vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service

                      You'll receive a confirmation email with a link to create a password (optional).

                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                    • Support for Oracle Database Links with StoreGeneratedPattern

                      If you use Entity Framework and the StoreGeneratedPattern for ROWID, ORA_ROWSCN or any other fields (no primary key fields), there is a problem if you have tables available over a database link. This can be done by creating a synonym that points to a table on another oracle database (@dblink).

                      Devart creates a returning clause for getting values back, but this is not a supported feature with database links and leads into an ora-22816.

                      Is it possible to implement an option in Devart so that such columns are always read back over a select statement instead of a returning clause?… more

                      8 votes
                      Vote 0 votes Vote Vote
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service

                        You'll receive a confirmation email with a link to create a password (optional).

                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        under review  ·  2 comments  ·  Admin →
                      • 6 votes
                        Vote 0 votes Vote Vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service

                          You'll receive a confirmation email with a link to create a password (optional).

                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                        • Text Indexing Support - CONTAINS, CTXCAT

                          I would like to see the CONTAINS and CTXCAT
                          funtions in the OracleFunctions class. For example:

                          var result = from x in ents.MyTable
                          where OracleFunctions.Contains(ctx_text_col, 'test WITHIN TITLE OR test WITHIN NAME') > 0
                          select x;

                          This would pretty much remove any requirements I have for writing plain old SQL.

                          6 votes
                          Vote 0 votes Vote Vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service

                            You'll receive a confirmation email with a link to create a password (optional).

                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                          • 3 votes
                            Vote 0 votes Vote Vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service

                              You'll receive a confirmation email with a link to create a password (optional).

                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                            • Forced Parameter Creation

                              Add a possibility to force creating parameters for a query, no matter a constant or a variable is passed in the Where clause.

                              3 votes
                              Vote 0 votes Vote Vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service

                                You'll receive a confirmation email with a link to create a password (optional).

                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                              • Provider Configurability

                                Add possibility to configure provider behaviour in a more flexible way.

                                3 votes
                                Vote 0 votes Vote Vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service

                                  You'll receive a confirmation email with a link to create a password (optional).

                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                • ID generators

                                  Capability to assign an ID generator (for example, Sequence, Guid, Increment, or Hi-Lo) to a Primary Key column.

                                  3 votes
                                  Vote 0 votes Vote Vote
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service

                                    You'll receive a confirmation email with a link to create a password (optional).

                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                  • Custom SQL From OracleFunctions

                                    Add a method to the OracleFunctions class to allow me to inject my old SQL snippets into the executed query. i.e.

                                    var result = from x in ents.MyTable
                                    where x.MyThing > 10
                                    && OracleFunctions.CustomSQL("MyFunction(:MyID, :MyThing) > 1", new OracleParameter("MyID", x.ID), new OracleParameter("MyThing", x.MyThing))
                                    select x;

                                    would result in something like the following

                                    SELECT
                                    "Extent1".ID, "Extent1".MyThing
                                    FROM
                                    MyTable "Extent1"
                                    WHERE
                                    "Extent1".MyThing > 10
                                    AND MyFunction(:MyID, :MyThing) > 1

                                    3 votes
                                    Vote 0 votes Vote Vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service

                                      You'll receive a confirmation email with a link to create a password (optional).

                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                    • Provide means to clear database for testing code first models

                                      One of the complexities of testing your data layer is to ensure that the database exists with the expected data. With EF code first, its becoming increasingly difficult to know how to clear the data in the database before seeding it with test data and running the tests.

                                      Using the configuration in the DbContext, provide the means to clear all data from the database, or a table taking the various constraints and relationships into account.

                                      3 votes
                                      Vote 0 votes Vote Vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service

                                        You'll receive a confirmation email with a link to create a password (optional).

                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                      • Insert Delayed for MySQL

                                        Add a support for delayed insert for MySQL

                                        3 votes
                                        Vote 0 votes Vote Vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service

                                          You'll receive a confirmation email with a link to create a password (optional).

                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                        • x64

                                          dotConnect for MySQL fails using Contains ('') LINQ function.

                                          2 votes
                                          Vote 0 votes Vote Vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service

                                            You'll receive a confirmation email with a link to create a password (optional).

                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                          • 1 vote
                                            Vote 0 votes Vote Vote
                                            Vote
                                            Sign in
                                            Check!
                                            (thinking…)
                                            Reset
                                            or sign in with
                                            • facebook
                                            • google
                                              Password icon
                                              I agree to the terms of service

                                              You'll receive a confirmation email with a link to create a password (optional).

                                              Signed in as (Sign out)
                                              You have left! (?) (thinking…)
                                            ← Previous 1
                                          • Don’t see your idea?
                                          • Post a new idea…
                                          • ADO.NET Entity Framework Support

                                            Knowledge Base and Helpdesk