Occassional "The underlying provider failed on Open. Connection must be opened." error
Posted: Thu 18 Oct 2012 12:58
Hi - we're using dotConnect 6.60.283.0 with Entity Framework Code First and .NET MVC3. It works fine practically all the time except in one scenario, which is where we have a View that displays multiple images. Sometimes all images are loaded fine, other times some of the images fail to load and I get one of 2 error messages - "The connection was not closed" or "Connection must be opened".
I use an EditorTemplate to render the collection of images in the View, which makes a call to my Controller for each image. Here's the Razor code that calls the Controller method :
And here's the Controller method:
My repository and context are set up in a standard way;
I think what's happening is that the Controller action is being called very fast several times in a row, especially when there are 4 or more images, and the db connection isn't fully closed before the next request comes in. So is there anything I can do? Is it possible to open and dispose the connection manually maybe, or some other pattern I can use to call a method multiple times in succession?
Cheers,
Ciaran
I use an EditorTemplate to render the collection of images in the View, which makes a call to my Controller for each image. Here's the Razor code that calls the Controller method :
Code: Select all
<div>
<img style="border: solid; border-color: lightgrey; border-width: thin" src="@Url.Action("GetImages", "Product", new {docId = Model.DocumentID, width = 250, height = 250})" alt=""/>
</div>Code: Select all
public void GetImages(int docId, int width, int height)
{
// Load image from database
var document = prodRepository.Documents.SingleOrDefault(f => f.DocumentID == docId);
var image = document.FileContent;
new WebImage(image)
.Resize(width, height, true, true)
.Crop(1, 1)
.Write();
}Code: Select all
public IQueryable<Document> Documents
{
get { return prodContext.Documents; }
}
public IDbSet<Document> Documents { get; set; }Cheers,
Ciaran