When exposing an IQueryable when deleting a DataContext?

Question

It seems popular at the moment if you implement the repository as simple

IQueryable<T> FetchAll<T>();

using LINQ to SQL, then the repository should set the DataContext, which remains available outside the repository.

So my question is: how does a DataContext get Disposed? What if an exception is thrown by code outside the repository? Will it be a database connection leak?

thanks

Answer 1

Why you do not need to call dispose in the DataContext

Summary DataContext opens a connection when a request is invoked (when accessing data) and closes it when the request is completed.

Answer 2

IDisposable ( DataContext, Disposed). API - -

using (var repository=new MyRepository) //or use a ServiceLocator or Factory
{
    var myObjects = repository.FetchAll().Where(obj=>obj.Foo == "bar");
    //do something with myObjects
}

DataContext, .