Can I track the progress of ObjectContext.SaveChanges?

Question

I am working on a small console utility to upload data packets to our hosted SQL server. The total data size can reach several megabytes. I need a way to show the progress of the SaveChanges operation. Is there a way to do this using the Entity Framework? If not, any recommendations would be appreciated.

Answer 1

Firstly, I assume that when you say “data lots”, you mean several records, not one record with a very large blob. Probably, in the latter case, you can not do anything. But in the first case ...

If you need enough time to even bother you, I would seriously think about going beyond the Entity Framework and using one of the (many) SQL Server components for bulk insertion, since it will speed up the insertion significantly, which is likely to do its users are happier than a progress bar.