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

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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  3. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  4. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. PostGIS is getting more popular these days, and you guys need to support it fully ;)

    15 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 7 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. Add a support for delayed insert for MySQL

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. 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

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. 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)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

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

    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?