Skip to content

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.

ADO.NET Entity Framework Support

Categories

JUMP TO ANOTHER FORUM

19 results found

  1. When "Create from database" option is used - the Store Generated Pattern values i.e. "Identity" are lost. Those values should be remembered for tables that didn't change. Now user has to set each value manually after update.

    57 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →
  2. Performing INSERT/UPDATE/DELETE operations in batches will increase performance of data updating.

    39 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Admin →
  3. Currently case-insensitive text operations for ex. with Contains is not supported.

    This is useful in the scenario of a search feature, when we have to find a person by name. The name can contain upper-lower case and accentuated characters that must be handled as a simple character.

    At the moment, only a workaround is possible, by executing Oracle-specific commands.

    37 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Admin →
  4. Add support for Oracle functions like REGEXPLIKE, REGEXPSUBSTR. That way, we can send regex expressions directly to the database.

    37 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  5. 35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  6. 34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  7. Make EDM Wizard process NUMBER columns according to NumberMappings in the connection string.

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  8. 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 .

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
  9. 16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
  10. We are using dotConnect for PostgreSQL and are using dynamic linq to entities queries. We want to do case insensitive searching on fields (without having to lowercase the field and the value to compare with).

    Since we are using dynamic linq it is not possible to use the scalar-valued ILike functionality added in the last version of dotConnect for PostgreSQL.

    To resolve our problem we would like the option to select which 'Like' statement is used by dotConnect for PostgreSQL in converting contains statements. Currently it uses (the case sensitive) Like function, we would like to be able to set…

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  11. 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.

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  12. 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?…

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →
  13. "Like" implementation as an OracleFunctions class method.

    14 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  14. Database/Schema Creating and Deleting for MySQL and PostgreSQL

    13 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  15. Capability to synchronize the database (schema) structure with the model structure by altering the existing database (schema) without deleting and re-creating it if possible. The changes will either be applied immediately, or the synchronization script will be generated.

    10 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
  16. 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(ctxtextcol, 'test WITHIN TITLE OR test WITHIN NAME') > 0
    select x;

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

    9 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Admin →
  17. Make NULL insertion generation in INSERT statements optional.

    7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  18. Possibility to generate shorter SQL statements - without line breaks, indents, and formatting. Query formatting is useful only when monitoring SQL statements, and it increases SQL size.

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  19. 4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
  • Don't see your idea?