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: 231

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

Related posts about sql-server

Related posts about entity-framework