Saving changes very slow via Datacontext

问题:

I am working on MVC3 .NET Project with Entity framework and SQL Azure Database.

When i try to save multiple records at once in a table it takes several minutes to finish the operation!

I use the same Datacontext for adding Object and saving changes also i've tried to use multiple Datacontexts but the results are the same.

回答1:

In addition, please check out the following documents:

Entity Framework performance considerations: http://msdn.microsoft.com/en-us/library/cc853327.aspx

SQL Azure performance guide: http://social.technet.microsoft.com/wiki/contents/articles/sql-azure-performance-and-elasticity-guide.aspx

Best Regards,

Ming Xu.