I have a doubt with Using(){}. I know that it uses Idisposable interface. So if I write in linq to entities:
Using(objectconext context=new objectcontext())
{
throw new Exception();
}
will the objectcontext still be disposed and the existing connection be closed or it will remain there alive. Thanks, Gaurav
The connection won't necessarily be closed, as this is managed elsewhere.
The using statement expands to a try finally block. So when the exception is thrown, the finally block in the using statement should execute.
From http://msdn.microsoft.com/en-us/library/yh598w02.aspx:
The using statement ensures that Dispose is called even if an exception occurs while you are calling methods on the object.
What happens next is another matter. As spender points out in his answer, the DataContext has no obligation to close the connection it is using, nor do you need to be concerned about it (since the DataContext should properly manage the connection for you).
Under certain conditions, your thrown exception can be swallowed silently by the try finally block. See here: http://www.digitallycreated.net/Blog/51/c%23-using-blocks-can-swallow-exceptions. This shouldn't affect you, though.
From try-finally on MSDN:
The finally block is useful for cleaning up any resources allocated in the try block as well as running any code that must execute even if there is an exception. Control is always passed to the finally block regardless of how the try block exits.
Since "using" is syntactic sugar for a try {} finally { /*calling IDisposable.Dispose() */ } block, using should guarantee that your object is properly disposed even in case of exception.
Because your are using USING keyword it will be disposed even if there is an exception.
It's discussed in this thread: C# "Using" Syntax
Yes it will be disposed. Using is similar like Try-Catch-Finally and disposal of objects in Finally block.
