EntityFramework 6 Connection Closed

Question

I did upgrade to the EF 6 and when I do this query is showing this error:

ExecuteReader requires an open and available Connection. The connection's current state is closed.

Code:

var db = new Entity2Entities(); db.Configuration.LazyLoadingEnabled = true; var ids = db.PersonBase.SqlQuery(Utils.Query(param, "PersonBase")) .Select(x => x.Id); var result = db.Employee.Where(x => ids.Contains(x.Id));

db.Configuration.LazyLoadingEnabled = true; var ids = db.PersonBase.SqlQuery(Utils.Query(param,"PersonBase")).Select(x => x.Id); db.Database.Connection.Open(); var result = db.Employee.Where(x => ids.Contains(x.Id)); — Fernando Magno
– Fernando Magno, Commented Apr 20, 2013 at 17:07

Jurica Smircic · Accepted Answer · 2013-04-20 10:48:09Z

1

EF 6 is in alpha state, things can change in the future. I didnt try this but maybe you have to do

db.Database.Connection.Open();

before executing SqlQuery method.

answered Apr 20, 2013 at 10:48

Jurica Smircic

6,5152 gold badges25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fernando Magno Over a year ago

db.Configuration.LazyLoadingEnabled = true; var ids = db.PersonBase.SqlQuery(Utils.Query(param, "PersonBase")).Select(x => x.Id); db.Database.Connection.Open(); var result = db.Employee.Where(x => ids.Contains(x.Id));

Collectives™ on Stack Overflow

EntityFramework 6 Connection Closed

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related