EdmGen.exe should support generating an edmx file from a connection string.

In .net 3.5, EdmGen2.exe (http://archive.msdn.microsoft.com/EdmGen2) was able to generate an edmx file from a connection string.

But for (EF) .net 4.0, we have lost this ability.

Thank you.

When using option 'Update model from databes' VS should update complex types returned by SP - now every SP have to be updated manually

I've read http://blogs.msdn.com/b/adonet/archive/2008/11/25/working-with-large-models-in-entity-framework-part-2.aspx

but, it's a total mission and I haven't had enough time to get it working. I'd like to add an association which bridges two models using the designer. Both models contain tables from the same database.

Extensible first and second level cache.

It'd be great if entity framework had an integrated tool such as the Profiler from Hibernating Rhinos (http://hibernatingrhinos.com/products/efprof).

I am aware that you can view the SQL generated for simple select statements by hovering over the DbSet member during debug but it would be nice to have a tool like this built into Visual Studio or that simply outputs the generated SQL to the debug console.

This should be configurable / able to be disabled.

scalar function is used usually some custom function to retrieve some only one value.
eg.custom ID not Guid

using the include() with a 1 to many relationship, the data are loaded in the list without any specific order, forcing often to reload directly specifying the sort order

Give developers the power to customize and extend the Entity Framework!!!!

Please include caching in EF. I have used Jarek Kowalski’s provider but it didn't cope with Stored Procedures or

Like datatable.Select(Filter) , we need to query what's already loaded in the datacontext using LINQ , something like a disconnected mode , this would be really gret feature , its so difficult to do right now

Allow specifying an interceptor (Castle, LinFu, Sprint.NET, etc) for modifying materialized entities. This allows injecting interfaces such as INotifyPropertyChanged, IEditableObject, etc.

Can we have the ability to add user defined meta data to entities and properties so that we can pick up on these using T4 Templates. One such example is in the DataMemberAttribute, this takes a priority in the constructor it would be nice to be able to add this as a metadata value on a property, we need this so that we can use entities both in WCF and RIA Services, at the moment we have hijacked the summary field for this purpose.

I would like to see EF upgraded to allow a user-selectable Dependency Injection container to manage materialization of entities. This would allow finer grained control over how objects are materialized, as well as support interface based definitions for entities.

Stored procedures can be included in an EDM. It would be most useful if a proc's result set were available for drag and drop from the Data Sources list such as tables currently are.

The defining query element in the edmx XML needs adding by hand, but when reusing the update model from database it is overwritten.

It was be very useful if the defining queries are not overwritten, as we primarily work in a database first way... so the team isn't familiar with the edmx xml... however we have specific features requiring DefiningQuery which could be overwritten often... it means that DefiningQuery couldn't be a long term solution for us as it'll cause to much pain to producitvity & gotcha bugs.

Currently if you have something like

select new { Year = c.DateEntered.Year }

the generated sql uses C1 for the column name. I would find it very useful if the used Year.