Reply to comment

Open your connection

Submitted by Anonymous on Thu, 01/28/2010 - 09:57.

I find it funny when I hear people saying "that's the way it works so it's normal".

For your connection reset, open your DataContext connection before working with it and close it at the end. That gives a good extra performance boost.

db.Connection.Open()
db.Connection.Close()

I ran the profiler and -- no more connection reset!!

Reply