Saving changes very slowly through the datacontext

Question

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

When I try to save several records at a time in a table, it takes several minutes to complete the operation!

I use the same Datacontext to add the object and save the changes, I also tried to use several Datacontexts, but the results are the same.

Answer 1

Also, check out the following documents:

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

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

Best wishes,

Ming Xu.