Entity Framework Feature Suggestions
Welcome! You can use this site to tell the Entity Framework team what features you want to see in future versions.
Remember that this site is only for feature suggestions and ideas!
If you have technical questions or need help with EF try StackOverflow or visit our forums.
If you want to report a bug you found in EF use the Entity Framework project page on CodePlex.
If you want to find more information about the Entity Framework go to our MSDN site.
-
Ability to intercept when an association is being changed
There should be an AssociationChanging in System.Data.Objects.DataClasses.RelatedEnd class, so I can validate before items get attached to a relation.
14 votes -
Entity Framework data access maps automatically to a store procedure
I like all Entity Framework data access to automatically create and map to store procedure instead of calling sp_executesql with parameterized query.
Advantages are:
• All database code in one place!!!!!
• Enables check by ”SQL Upgrade advisor”
• System view for dependency checks
• Using visual studio for static code analysis
• Enables DBAs to see which questions are run
• Enables DBAs to customize T-SQL, inde
• Only need to grant excite stored procedure rights indeed of base table access
• The use of stored procedure cache
• May be even version control of the sps with database…14 votes -
Converting UpperCase to PascalCase
It would be great if you could add feature for designer to convert uppercase table names to pascal case
14 votes -
Make LINQ to Entities recognize GetValueOrDefault()
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?
14 votes -
WAQS
Adopt the WAQS framework into EF source code
WAQS framework is a layer of abstraction over the Entity Framework
WAQS is addressing many of the painful scenarios under EF, with a great design and productivity.
http://www.dailymotion.com/video/xuc1jb_waqs-application-scaffolding_tech
14 votes -
Support for timestamp in model-first
You cannot use optimistic concurrency in model-first mode. This is because the entity designer does not support a timestamp type. Even if you add a timestamp column and update your model, it turns into binary(8) in the generated SQL. Manual changes to set the type to "timestamp" in the EDMX file are overwritten and the property reverts to Binary(8).
As far as I can tell, this makes it impossible to use this feature in model-first mode.
14 votes -
Bulk Insert
ADO.Net supports bulk insert for big amount of data. With the help of this library
http://archive.msdn.microsoft.com/LinqEntityDataReader
It is possible to do Bulk inserts with entities. But it would be nice if there would be a integrated approach.13 votes -
Support for Data Annotations in EF Designer
Entity framework designer should support the attributes from the System.ComponentModel.DataAnnotations namespace. For instance, if I specified a range for a numeric type, EDMX designer would put a RangeAttribute on the generated property. I'm not sure whether or not EF should interpret this information, but at least my own controls could take advantage of it.
13 votes -
13 votes
-
Filtering support in databinding
Add Filter and Sort support to Windows Forms BindingSource when bound to EF as in example below.
Dim context As New MyEntities
context.Employees.Load()
EmployeeBindingSource.DataSource = context.Employees.Local.ToBindingList()'Would like the following to then work
EmployeeBindingSource.Filter = "FirstName = 'SANTA'"
EmployeeBindingSource.Sort = "FirstName"I use data-driven filters stored outside of the application, so new filters and sorts may be added without new code.
13 votes -
Support for DateTime built-in operations in LINQ to Entities
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.
13 votes -
Super-flexible partial-selection EF-4.1
I've read the post http://blogs.msdn.com/b/adonet/archive/2011/01/30/using-dbcontext-in-ef-feature-ctp5-part-5-working-with-property-values.aspx, it's beautiful, and I have some additional requests:
1) I should be able to decorate some properties in my DTOs so it can have a different name (or decorate them at runtime with type-description).
2) Should be able to select partial queries:
- Via property selectors (both typed and strings) via DTO initializers
- Via constructor of another class (in EF4 this is not allowed) I mean .Select(u=> new FatUnicorn(u.Id, u.CornLength));
- As per the previous example, should also be: context.Unicorns.Select<UnicornSummary> using the method of assigning matching property names or decorated with attributes as…13 votes -
13 votes
-
13 votes
-
RecreateDatabaseIfModelChanges shouldn't drop database
RecreateDatabaseIfModelChanges shouldn't drop database (we often dont have permissions on server), but should drop tables and recreate them.
13 votes -
Enable primary key to be updated
There are many database tables that have tables with a primary key of type int and are not autoincremented
it should be nice to have Ef generate code to allow updating the primary key.12 votes -
Write EntitySet as XML like DataTable.WriteXML()
Ability to save contents of a loaded entity set into an xml file to persist into hard disk then load again like is possible in data tables
12 votes -
Stop development on Entity Framework because my DBA friend is having troubling finding a job
Have some empathy guys! This guy is a good bloke and tries hard, and you're not making it any easier. He's just moved into a new place and is looking at buying himself a new projector for Christmas, but it might just not happen as this rate.
12 votes -
Improve Model First: allow user choosing inheritance strategy on a case by c
In my models, there are hierarchies that are persisted using TPT while others are persisted using TPH. It would be great if we could choose the strategy and then have Generate Database From Model create the tables depending on our choice.
12 votes -
Support IEnumerable<T>
Sometimes we wish to expose a collection as read only, normally using IEnumerable<T> instead of ICollection<T>. This is not recognized in the current version, but it should.
12 votes
- Don't see your idea?