Skip to content
← Customer Feedback for Devart

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

(thinking…)

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.

19 results found

  1. Keep "Store Generated Pattern" saved when updating model.

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. Batch Updates

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. Support case-insensitive and accent-insensitive text operations, for ex. Contains

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. Support for Oracle regex commands

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. SDO_GEOMETRY data type support

    35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. Oracle Hints Support in LINQ to Entities

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. EDM Wizard for Oracle - NUMBER mapping customization with NumberMappings

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. <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 .

    21 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  9. Oracle materialized view support

    16 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. Configurable like implementation of Postgres

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. 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.

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  12. 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?…

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  13. "Like" SQL clause support in LINQ to Entities for Oracle

    "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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  14. EF Code First: Database/Schema Creating and Deleting for MySQL and PostgreSQL

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  15. Code First Database Evolution / Database (Schema) Migration

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  16. 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(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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  17. Don't Insert NULL Values on INSERT

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  18. Shorter SQL

    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)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  19. EF Code First: Deleting Oracle Schema Objects

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  1 comment  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
  • Don't see your idea?