set transaction isolation level read only uncommitted in LINQAug 13, 10
apparently you can use a transaction scope for this and just wrap everything that way. but to me that seems more complicated than just enabling it with execute command.
some LINQ code like (note that ‘this’ is a data context):
this.ExecuteCommand("set transaction isolation level read uncommitted"); MyTable.Take(5).Dump();
Produces this sql code:
set transaction isolation level read uncommitted GO SELECT TOP 5 <fieldnames…> FROM [MyTable] AS [t0] GO
That’s what I want to see, so yay. 😀
some links: http://madprops.org/blog/linq-to-sql-and-nolock-hints/ http://www.hanselman.com/blog/GettingLINQToSQLAndLINQToEntitiesToUseNOLOCK.aspx
ps. trying to use livewriter today. so far, not excited about it and still like word more 😛 hopefully i’ll get elightened.