Accessing Entity - Error (Entity Framework)

L A

9y2.9k.NET

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

L A8y ago
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.
Sandy8y ago
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