Accessing Entity - Error (Entity Framework)

Question

Hello all Im working on ASP.Net MVC app wtih Entity Framework added in a class library. I added refrence of class library project (i.e ADO.Net Entity data model) into my ASP.Net MVC project. And in when i try to access Entity in controller's action as shown below public ActionResult getProductDetails() { using (SampleTrialEntities entity = new SampleTrialEntities()) { // call entity operation } return View(); } Here line #3 'using' shows the following error - Error 1 'DataAccessLibrary.SampleTrialEntities': type used in a using statement must be implicitly convertible to 'System.IDisposable' Error 2 The type 'System.Data.Entity.DbContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'EntityFramework Version=6.0.0.0 Culture=neutral PublicKeyToken=b77a5c561934e089'. But when I add ADO.Net Entity data model in ASP.Net MVC project it works as expected. So Should I add ADO.Net Entity data model only in the project in which it is used.? can't I have a separate DAL for this EF and use it in other projects? Can anyone help me your response is appreciated.

Learn Avid · Answer

Thanks Sandy for your response. I tried to instantiate the entity object & dispose it. But it didn't allow me to write entity.Dispose(); also can't convert DbSet (Productdetails) to List(). And i also selected Entity framework 6.0 when creating the EDM.

Sandy · Answer

Hi Avid Your first error below to IDispoable Interface so try to use class like below without using SampleTrialEntities entity = new SampleTrialEntities(); try { // call entity operation } Catch { } finally { entity.dispose(); } Your second issue belong to Entity framework dll. You have to add reference of Entityframework.dll in both project. This you can add either by nuget or direct dll although nuget is better option Install-Package EntityFramework -Version 6.0.0 Thanks Sandy