entity framework and dirty reads
Posted
by
bryanjonker
on Stack Overflow
See other posts from Stack Overflow
or by bryanjonker
Published on 2011-01-11T13:56:29Z
Indexed on
2011/01/11
21:53 UTC
Read the original article
Hit count: 233
I have Entity Framework (.NET 4.0) going against SQL Server 2008. The database is (theoretically) getting updated during business hours -- delete, then insert, all through a transaction. Practically, it's not going to happen that often. But, I need to make sure I can always read data in the database. The application I'm writing will never do any types of writes to the data -- read-only.
If I do a dirty read, I can always access the data; the worst that happens is I get old data (which is acceptable). However, can I tell Entity Framework to always use dirty reads? Are there performance or data integrity issues I need to worry about if I set up EF this way? Or should I take a step back and see about rewriting the process that's doing the delete/insert process?
© Stack Overflow or respective owner