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.

48 results found

  1. Preserve Oracle view Entity Keys

    Preserve manually modified values of Entity Key for entities, based on views and generated with dotConnect for Oracle, in Visual Studio Update From Database Wizard.

    5 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…)
    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

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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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

  3. SaveChanges only for selected changes

    Capability to save only the selected part of inserted/modified/deleted entities.

    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…)
    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

  4. provide a way to update one class only from database

    something like right-click on class name and choose "Update from database".

    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…)
    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

  5. Enable with Code First Comments from Code to DB

    Auto-insert code xml-documenten (c#) to Database comments (Oracle).
    Example:

    /// <summary>
    /// Id for XYZ
    /// </summary>
    public int Id {get;set}

    should auto create the follwoing sql:

    comment on column mytabel.id is 'Id for XYZ';

    3 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…)
    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

  6. OracleJsonFunctions.Value should generate returning clause

    Oracle's JSONVALUE function supports a stynax like JSONVALUE(Column,"$.path.to.property" RETURNING data_type [number,date,timestamp])

    OracleJsonFunctions.Value function should cover this functionality and allow developers can write queieries like below
    context.Entities.Where(t=> OracleJsonFunctions.Value(t.Json,"$.SomeScalarValue")> 1);

    Adding "Error on Erro"r or "null on error" syntax generation would also be nice.
    JSON_VALUE function details :
    https://docs.oracle.com/database/121/SQLRF/functions093.htm#SQLRF56668

    3 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…)
    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

  7. Support for the upcoming version of EF6 cross platform and .net Core 3.0

    Support for the upcoming version of EF6 cross platform and .net Core 3.0
    According to the roadmap, EF6 will be released as compatible with .net Core 3.0 with the ability to run on linux (source: https://blogs.msdn.microsoft.com/dotnet/2018/05/07/net-core-3-and-support -for-windows-desktop-applications /)

    EF6 work on .NET Core is currently tracked on the following GitHub issues:
    – https://github.com/aspnet/EntityFramework6/issues/189 – Support PackageReference
    – https://github.com/aspnet/EntityFramework6/issues/231 – Support for new csproj format
    – https://github.com/aspnet/EntityFramework6/issues/271 – Support for .NET Core

    3 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…)
    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

  8. Index instead of foreign key constraints.

    A global option to insert indexes rather than foreign keys should be an option. There are many of us that do not use foreign keys for reasons of updating databases and performance while indexes used instead actually improve performance with the model able to maintain the association.

    This is a low hanging fruit guys and will improve everyone's performance of the models. Please consider.

    This is should be a universal option for all frameworks.

    3 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…)
    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. Support Dependency class in Entity Framework by default

    It would be nice feature, if you would implement the Dependency Classes (MySQLDependency, SQLDependency, OracleDependency…)
    directly into your Entity Framework with the T4 Code Template Generation.

    3 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…)
    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

  10. show oracle stored procedures in datacontext diagram

    when drag and drop a stored procdure or package into diagram, display them as you display entities

    3 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…)
    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

  11. Entity Framework support in SQL Server

    Entity Framework translates binary code to SQL query text then SQL Server has to parse this text, compile and execute.
    Why Entity Framework and SQL Server can't comunicate directly using a binary protocol?

    3 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…)
    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

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

    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

  13. Devart creates database for us, why doesn't it create indexes too?

    It's great when devart creates my database from the models I have created. But I believe it could at least create index for relations created between objects, or it could ask me which indexes I would create. It would really help.

    2 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…)
    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

  14. EF Core support for MySQL Json data type

    Add support for MySQL Json data type fields in the EF Core (LINQ, manipulate data)

    2 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…)
    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

  15. x64

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

    2 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…)
    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. Move "New features in the Entity Framework support!" messages to another forum

    As many of these posts that there are, it really CLUTTERS the forum. Please move these to an ANOUNCEMENT forum.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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

  17. Different platform database communication

    Different platform database like,MS SQL. MY SQL and Oracle communicate with ASP.net application. Here my requirement is that do not want to use store procedure because all 3 database platform syntax different, so using entity framework create single *.edmx file and communicate.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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

  18. RejectChanges without read data from database

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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

  19. Support of DML in LINQ

    Implement the support for DML in LINQ for Entity Framework

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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

  20. Short Parameter Names in SELECT Queries

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    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
2
  • Don't see your idea?