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.

  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.

    144 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  3. Support EF7

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

    40 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    under review  ·  0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  5. Oracle 8 and 9.1 Support

    Add support for Oracle 8 and 9.1

    34 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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…

    30 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  8. ID generators

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

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. Full PostGIS support

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

    15 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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...

    12 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  12. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  13. Spatial support for EFCore, compatible with other providers.

    With EFCore 2.2 there will be Spatial support via NTS for SQLite, SqlServer in-memory and postgress via a standardized interface. Devart should implement something similar for their drivers.

    9 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  14. 7 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  16. 6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  17. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  18. Provider Configurability

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

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. Insert Delayed for MySQL

    Add a support for delayed insert for MySQL

    6 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
← Previous 1 3
  • Don't see your idea?

ADO.NET Entity Framework Support

Feedback and Knowledge Base