It will be much appreciable when DotNetConnect works with XAMARIN/Mono.
So we can Mobile devices via http-Tunnel with MySql-Databases.6 votes
As many of these posts that there are, it really CLUTTERS the forum. Please move these to an ANOUNCEMENT forum.1 vote
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
Each RDBMS supports additional functions which are exposed in EF. Problem is that the same functions are exposed with different names. For example:
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
when drag and drop a stored procdure or package into diagram, display them as you display entities3 votes
PostGIS is getting more popular these days, and you guys need to support it fully ;)15 votes
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
something like right-click on class name and choose "Update from database".4 votes
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
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
Add a support for delayed insert for MySQL6 votes
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
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))
would result in something like the following
"Extent1".MyThing > 10
AND MyFunction(:MyID, :MyThing) > 111 votes
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
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
Capability to save only the selected part of inserted/modified/deleted entities.4 votes
Implement the support for DML in LINQ for Entity Framework1 vote
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
- Don't see your idea?