Wednesday, August 27, 2014

How to use Sqldatareader in Threading in C#

It's one datreader per connection.


You can open two connections to the one database.


It's not a great plan or I'd have suggested it.


If you're not already using it you should look up WITH (NOLOCK)


http://ift.tt/1AV0CZn


Especially if you're going to push your luck with the same full table read twice.




Hope that helps

Please don't forget to up vote answers you like or which help you and mark one(s) which answer your question.


No comments:

Post a Comment