48 results found
-
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 -
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 -
SaveChanges only for selected changes
Capability to save only the selected part of inserted/modified/deleted entities.
4 votes -
provide a way to update one class only from database
something like right-click on class name and choose "Update from database".
4 votes -
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 -
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#SQLRF566683 votes -
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 Core3 votes -
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 -
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 -
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 -
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 -
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 -
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 -
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 -
x64
dotConnect for MySQL fails using Contains ('') LINQ function.
2 votes -
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 -
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 -
1 vote
-
Support of DML in LINQ
Implement the support for DML in LINQ for Entity Framework
1 vote -
1 vote
- Don't see your idea?