i don t want to encapsulate every call in a try catch block
is there an event i can subscribe to, for when a connection is lost or timesout so that i can reconnect..
or some way to not check every linq query.
and if not why not!
Edit: Does Linq to Entity s have this?
Edit: I m using Microsoft SQL Azure, and it drops connections alot.
Edit: I open a new connection on every call to the db. so its not that I m leaving the connection open.
Even if there were such event (not sure) you still could not rely on it. A network connection can suddenly get broken, database engine be busy doing some other query a timeout is always a possibility. Better watch directly a query if it s succeeded or failed, regardless of the reason.
You could consider writing your own LINQ provider (using much of the existing one s functionality) that adds exactly this feature. It might turn out to be less work than handling the exception each and every time.
Why are you getting so many drops? Are you hanging on to a data context object for a long time? It s cheap to construct one, so just construct a new one when you start a new unit of work.
From this msdn blog
It is better to err on the side of shorter lifetime - a unit of work or even a single request for stateless servers are good patterns to start with.
What is the use of default keyword in C#? Is it introduced in C# 3.0 ?
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...
I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...
Since I cannot order my dictionary, what is the best way of going about taking key value pairs and also maintaing an index?
Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...
