How to handle DBContext when using Ninject

asp.net-mvc, ninject, telerik-open-access

Solution

Here's how I would do your Ninject bindings,

kernel.Bind<DBContext>().ToSelf().InRequestScope();
kernel.Bind<ContentService>().ToSelf().InRequestScope();
kernel.Bind<IContentRepository>().To<ContentRepository>().InRequestScope();

This pattern should work fine in the example above with EF and Ninject.

Problem

I am trying to use Ninject and OpenAccess for the first time. Please help me with the following. Here is what my project looks like... ``` public class ContentController : Controller { private ContentService contentSvc; public ContentController(ContentService contentSvc) { this.contentSvc = contentSvc; } } ``` The following class is under a folder in my web app. ``` public class ContentService { private IContentRepository contentRepository; public ContentService(IContentRepository contentRepository) { this.contentRepository = contentRepository; } public void InsertContent(Content content) { contentRepository.InsertContent(content); } } ``` The following repository belongs to a separate assembly. ``` public class ContentRepository : IContentRepository { DBContext db; public ContentRepository(DBContext _db) { db = _db; } public void InsertContent(Content content) { db.Add(content); } } ``` Here is what Ninject binding look like.. ``` kernel.Bind<ContentService>().To<ContentService>().InRequestScope(); kernel.Bind<IContentRepository>().To<ContentRepository>().InRequestScope().WithConstructorArgument("_db", new DBContext()); ``` Everything works fine if I fetch one page at a time. I am using a simple tool 'XENU' to fetch multiple pages simultaneously. This is when I get errors with DBContext by fetching multiple pages at a time. I am not sure if Ninject is dosposing the DBContext in each REQUEST?? I get different errors, e.g. 'Object reference not set to an instance of an object.', OR 'ExecuteReader requires an open and available Connection. The connection's current state is open.' P.S. I have ContentService under a folder in my MVC web app. ContentRepository is a separate assembly. I will be adding business logic in ContentService and use 'ContentRepository' only for CRUD operations. Also, please let me know if this architecture is okay or is there a better way to create services and repositories.

Original source