CODEWITHSUNDEEP
entity-framework-4
kubal5003
kubal5003

Reputation: 7254

Entity Framework - how to come with failure when saving data

let's suppose the situation looks like this: I have one object context in my app and I download 15k records from the db (like 15k invoices). User picks one and makes some changes to it. I call SaveChanges() and it fails for some reason (doesn't matter what reason).

Now the context that was used can't perform any save because it wasn't able to save those changes. What should I do to make it work?

Another scenario is that I use a separate context for making changes. If saving fails then nothing happens - I discard the context and that's it. The problem that arises is: how to merge changes back to the main context? (without downloading 15k records once again)

Upvotes: 1

Views: 102

Answers (1)

Ladislav Mrnka
Ladislav Mrnka

Reputation: 364279

Idea of downloading 15k records smells pretty bad but lets assume you must do it. The scenario you must follow to make this work should look like:

  1. Create first context for data retrieval.
  2. Execute query to get your 15k records. Execute query as NoTracking (MergeOption of ObjectQuery)! It will improve performance because these records will never be used in context again.
  3. Close first context
  4. User picks and invoice = create deep clone of the invoice and attach it to a new context (in case of WPF or WinForm application)
  5. User saves changes and exception is fired. If you want to deal with exception somehow you still have only context with single invoice. You can dispose context and return to your original set of unaffected records.
  6. If the entity is saved you should merge changes back to list because your entity in 15k records will not be updated automatically.

Upvotes: 3

Related Questions