LinqToSQL and the exception " ExecuteReader requires an open and available Connection."

Question

I have a collection called dbUsers of type IQueryable

These are pulled from a linqtosql database context i.e.

IQueryable<Data.LinqToSQL.User> dbUsers = DBContext.Users

Calling ToList on this object:

IList<Data.LinqToSQL.User> users = dbUsers.ToList();

Results in an exception:

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

What am I doing wrong here?

Cheers

Yes. The error doesnt seem to always occur. I do have other other code talking to DBContext.Users which may be contributing to the problem — iasksillyquestions, Jan 14 '09 at 13:40

score 2 · Answer 1 · answered Jan 13 '09 at 23:44

2

see if this works for you:

IList<Data.LinqToSQL.User> users = (from u in DBContext.Users select u).ToList();

if not you might need to do something like:

DBContext context = new DBContext();
IList<Data.LinqToSQL.User> users = (from u in context.Users select u).ToList();

answered Jan 13 '09 at 23:44

John Boker

2

Whats the difference between these two examples? Is this causing the DB connection to be closed differently? – iasksillyquestions Jan 14 '09 at 13:23

score 1 · Answer 2 · edited May 23 '17 at 12:01

1

I think this is a threading problem with the DataContext. I am getting similar problems. Check this question for more details.

Additionally read this and this.

edited May 23 '17 at 12:01

Community

answered May 19 '09 at 11:58

Matt Kocaj

2 Answers2