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, and SQLite 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.
-
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.
90 votes -
31 votes
-
Filter Available Objects in EDM Wizard for Oracle
Let user filter objects, available in the EDM Wizard, by owner/grants/privileges/etc.
31 votes -
Oracle 8 and 9.1 Support
Add support for Oracle 8 and 9.1
23 votes -
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 database20 votes -
<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 .
15 votes -
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.14 votes -
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?9 votes -
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?… more
8 votes -
6 votes
-
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(ctx_text_col, 'test WITHIN TITLE OR test WITHIN NAME') > 0
select x;This would pretty much remove any requirements I have for writing plain old SQL.
6 votes -
3 votes
-
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 -
Provider Configurability
Add possibility to configure provider behaviour in a more flexible way.
3 votes -
ID generators
Capability to assign an ID generator (for example, Sequence, Guid, Increment, or Hi-Lo) to a Primary Key column.
3 votes -
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) > 13 votes -
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.
3 votes -
Insert Delayed for MySQL
Add a support for delayed insert for MySQL
3 votes -
x64
dotConnect for MySQL fails using Contains ('') LINQ function.
2 votes -
1 vote