I would like some API for checking if database schema is correct for edmx storage model.
It could be something like
List<string> errors = new List<string>();
bool isCorrect = context.ValidateDbSchema(errors);69 votes
When generating from database, the EDMX designer should generate XML Documentation (Summary field) from the SQL Description field of each table/column etc.68 votes
EF CTP4 comes with a set of built-in conventions for model discovery and schema generation. We should be able to alter these conventions as opposed to re-mapping the entire class from scratch.
1) I'd like to replace DataAnnotations with EntLib Validation Block and I should be able to tell EF to use my attributes.
2) I want to apply a common convention like prefixing all tables with some string or even a more complicated scenario like all entities that derive from Inventory should generate tables with name: Inventory.<EntityName>.67 votes
Reopening since this was originally completed for EF6 but the feature is not available to Entity Framework Core.
EF6 alpha 1 contains a first cut of custom Code First conventions support. See the blog post for the announcement: http://blogs.msdn.com/b/adonet/archive/2012/10/30/ef6-alpha-1-available-on-nuget.aspx.
For example a database table could have a [Settings] column of type xml. And a mapped entity type could have a property [Settings] of some serializable type. Then you will be able to read and write data into and from this [Settings] column with EF. Like this:
var user = db.Users.First(x => x.ID == 1);
if (user.Settings == null)
user = new Settings();
user.Settings.ProductsPerPage = 20;
I'd like to see a well designed EF project template that made use of the Repository pattern for abstracting the data access technology. This should showcase best practices for using Code-First and POCO entities, UnitOfWork abstractions, solutions for querying entities that span multiple repositories, etc. This information is pretty hard to come by for EF but available in abundance for other ORMs.65 votes
We have seen that there are lots of discussion surrounding the generated SQL not being optimized. Entity Framework should have a provision wherein User should be able to change the Generated SQL and use it for further processing through some mechanism61 votes
EF6 added initial support for interception, which exposes events for query interception. Currently only access to store DbExpression trees and DbCommand are available, but interception at different levels should become possible in the future.
Say there is one database shared by several applications, objects are separated by schema. So it would be nice to be able to store and apply migrations for one schema independently from another one.60 votes
When we originally marked this issue as completed we did not take into consideration the ability to ignore certain tables in migrations for overlapping models.
This is still not supported in EF Core (or in EF6)
System.Data.dll -- which is fundamental to EF -- is not available inside Windows Store Apps. Thus development of Windows Store apps is two steps back of where WPF and Silverlight development have been.59 votes
EF7 has initial support for Windows Universal Apps.
So far a stored procedure can return only a plain entity. It would be great if we could create a stored procedure that returns orders and details information in a single roundtrip.54 votes
It is not currently possible to write a LINQ query that compares a value to data stored in a varbinary column. By comparison, I mean SQL-supported <, <=, >, >= comparisons that lexicographically compare the bytes in the column.
As far as I know there is no way to write these queries without stepping down into Entity SQL.52 votes
We are working on big BI projects for different customers and it would be great, if we could use only one technology to get the data (both multidimensional and relational) handling. It would be great to send mdx queries to a SSAS cube, retrieve the data and have a possibility to map the retrieved data for example over annotations to POCOs.49 votes
I have a LINQ query that involves a nullable integer. When I try to run the query, I get the following error:
"LINQ to Entities does not recognize the method 'Int32 GetValueOrDefault(Int32)' method, and this method cannot be translated into a store expression."
I am not a L2E or EF guru in the least, but it seems like that should translate to the SQL ISNULL function shouldn't it?
Regardless, can you please make this functionality work?45 votes
EF should have some better data change tracking/auditing plumbing...on par with the extensive trace listener class support in ASP.NET. In order to create an audit history of the CRUD actions taking place within my entity model in EF 4.0, I had to write a lot of custom code and override the SavingChanges event and the OnContextCreated method to make it happen. Even now it doesn't properly catch all actions due to certain limitations (such as having DB-set identity fields). Think about how to make auditing data changes simpler and richer for devs!38 votes
I would like to see the T-SQL MERGE statement supported. For multi threading situations it really would be useful.38 votes
Currently if an empty set is expected it is necessary to cast either the result or the input elements of Sum to Nullable<T> to compensate for the type mismatch between the SQL database and the signature of the methods in LINQ.38 votes
Some customers want to write queries that include such expressions as "date1 - date2" or "datetime3 + timespan1 > datetime4". LINQ to Entities currently support some of date/time operations through the EntityFunctions.AddX and DiffX functions, but it doesn't support built-in operators with data/time types.37 votes
The ability to create an entity for a synonym in the database.35 votes
Create a client side profiler that will log running queries and statistics for the various data contexts. Also provide helpful tips to improve performance if applicable. Similar to what NHProf already does for NHibernate.35 votes
ADO.Net supports bulk insert for big amount of data. With the help of this library
It is possible to do Bulk inserts with entities. But it would be nice if there would be a integrated approach.31 votes
- Don't see your idea?