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, SQLite, DB2, and Salesforce 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…)

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

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

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

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

  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.

    147 votes
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      3 comments  ·  Flag idea as inappropriate…  ·  Admin →
    • Filter Available Objects in EDM Wizard for Oracle

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

      48 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        1 comment  ·  Flag idea as inappropriate…  ·  Admin →
      • Support EF7

        Add support for the new EF7.
        We need to test it before the actual release date.

        40 votes
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
        • 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

          37 votes
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Oracle 8 and 9.1 Support

            Add support for Oracle 8 and 9.1

            34 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
            • Unite into Batch Inserts for entities with columns having the StoreGeneratedPattern attribute value set to Identity or Computed (Oracle)

              Hello,

              I see that batch for "Statements with the RETURNING clause, for example, statements that update or insert entities with columns having the StoreGeneratedPattern attribute value set to Identity or Computed." is not supported.

              The code generated for such an insert is for this sample table is:
              DECLARE
              updatedRowid ROWID;
              BEGIN
              INSERT INTO ACTIONAR(CNP, NUME, PRENUME, TIP, REZIDENTA)
              VALUES (:p0, :p1, :p2, :p3, :p4)
              RETURNING ROWID INTO updatedRowid;
              OPEN :outParameter FOR SELECT ID FROM ACTIONAR WHERE ROWID = updatedRowid;
              END;

              The SQL for batched inserts could look like this:
              DECLARE
              updatedRowid1 ROWID;--First in batch
              updatedRowid2 ROWID;--Second in batch
              BEGIN
              INSERT…

              27 votes
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
              • EF Code First: Create Database and Code-First Migrations functionality for TimesTen

                We'd like to use TimesTen as standalone database without Oracle DBMS and use EF. The ODP.NET provider does not support EF for TimesTen as documented: http://docs.oracle.com/cd/E11882_01/win.112/e21641/toc.htm#BHAHDIEC
                We'd like to have EF Code First: Create Database and Code-First Migrations functionality for TimesTen

                22 votes
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                • ID generators

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

                  20 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                  • 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?

                    18 votes
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                    • Full PostGIS support

                      PostGIS is getting more popular these days, and you guys need to support it fully ;)

                      14 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                      • 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

                        11 votes
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                        • PostgreSql - Option to insert empty string values as NULL

                          With PostgreSql, there is a difference between an empty string value (represented as '') and a NULL value.

                          With Oracle and SQL-Server, an empty string is always inserted as NULL.

                          So, if there is a unique constraint on a column and the application insert a empty string, the constraint will be violated for the second insertion.

                          It would be nice to have an option to insert empty string values as NULL for dotConnect for PostgreSQL, to have the same behavior than Oracle or SQL-Server, and not specifically avoid empty strings in the application to work with PostgreSQL...

                          9 votes
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                          • 7 votes
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                            • Support XAMARIN - MySql !!

                              It will be much appreciable when DotNetConnect works with XAMARIN/Mono.
                              So we can Mobile devices via http-Tunnel with MySql-Databases.

                              6 votes
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                              • 6 votes
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                • LDAP connectivity support in dotconnect for Oracle

                                  Our corporate DB server names change frequently. Because of that, we'd like to use LDAP url to connect to the oracle server. There were several requests for this feature in the forums. I hope you can make this a high priority.

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

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

                                    6 votes
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      1 comment  ·  Flag idea as inappropriate…  ·  Admin →
                                    • 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.

                                      6 votes
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Insert Delayed for MySQL

                                        Add a support for delayed insert for MySQL

                                        6 votes
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                        • Handle server functions in multi-database support

                                          Each RDBMS supports additional functions which are exposed in EF. Problem is that the same functions are exposed with different names. For example:

                                          if (isSqlServer)
                                          query = query.Where(p => SqlFunctions.StringConvert(p.BankId));
                                          else // is Oracle
                                          query = query.Where(p => OracleFunctions.ToChar(p.BankId));

                                          However this makes code less readable and a bit harder to maintain, due to it being redundant, not to say that it doesn't attend database-ignorance.

                                          This would be better:

                                          query = query.Where(p => EntityFunctions.ToString(p.BankId));

                                          As I think this is the most common scenario, it could be just p.BankId.ToString().

                                          5 votes
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1
                                          • Don't see your idea?

                                          ADO.NET Entity Framework Support

                                          Feedback and Knowledge Base