48 results found
-
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.
144 votes -
Filter Available Objects in EDM Wizard for Oracle
Let user filter objects, available in the EDM Wizard, by owner/grants/privileges/etc.
48 votes -
Support EF7
Add support for the new EF7.
We need to test it before the actual release date.43 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 database37 votes -
Oracle 8 and 9.1 Support
Add support for Oracle 8 and 9.1
34 votes -
Unite into Batch Inserts for entities with columns having the StoreGeneratedPattern attribute value set to Identity or Computed (Oracle)
Hello,
I see that batch for "Statements with the RETURNING clause, for example, statements that update or insert entities with columns having the StoreGeneratedPattern attribute value set to Identity or Computed." is not supported.
The code generated for such an insert is for this sample table is:
DECLARE
updatedRowid ROWID;
BEGIN
INSERT INTO ACTIONAR(CNP, NUME, PRENUME, TIP, REZIDENTA)
VALUES (:p0, :p1, :p2, :p3, :p4)
RETURNING ROWID INTO updatedRowid;
OPEN :outParameter FOR SELECT ID FROM ACTIONAR WHERE ROWID = updatedRowid;
END;The SQL for batched inserts could look like this:
DECLARE
updatedRowid1 ROWID;--First in batch
updatedRowid2 ROWID;--Second in batch
BEGIN
INSERT…30 votes -
EF Code First: Create Database and Code-First Migrations functionality for TimesTen
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 TimesTen22 votes -
ID generators
Capability to assign an ID generator (for example, Sequence, Guid, Increment, or Hi-Lo) to a Primary Key column.
21 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?18 votes -
Full PostGIS support
PostGIS is getting more popular these days, and you guys need to support it fully ;)
15 votes -
PostgreSql - Option to insert empty string values as NULL
With PostgreSql, there is a difference between an empty string value (represented as '') and a NULL value.
With Oracle and SQL-Server, an empty string is always inserted as NULL.
So, if there is a unique constraint on a column and the application insert a empty string, the constraint will be violated for the second insertion.
It would be nice to have an option to insert empty string values as NULL for dotConnect for PostgreSQL, to have the same behavior than Oracle or SQL-Server, and not specifically avoid empty strings in the application to work with PostgreSQL...
12 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) > 111 votes -
Spatial support for EFCore, compatible with other providers.
With EFCore 2.2 there will be Spatial support via NTS for SQLite, SqlServer in-memory and postgress via a standardized interface. Devart should implement something similar for their drivers.
9 votes -
7 votes
-
LDAP connectivity support in dotconnect for Oracle
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 -
Support XAMARIN - MySql !!
It will be much appreciable when DotNetConnect works with XAMARIN/Mono.
So we can Mobile devices via http-Tunnel with MySql-Databases.6 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.
6 votes -
6 votes
-
Insert Delayed for MySQL
Add a support for delayed insert for MySQL
6 votes -
Provider Configurability
Add possibility to configure provider behaviour in a more flexible way.
6 votes
- Don't see your idea?