close connection database

Question

DataClassesDataContext dc = new DataClassesDataContext();

private string GetPropertyCompany()
{
  var res=from b in dc.Tbl1 select b;
  string a;
  foreach(var item in res)
      a+=item.name;
  //    dc.Connection.Close();

  return a;
}

This code requires a close connection;

me should always close the connection;

without dc.Connection.Close(); work fine!!!!

score 1 · Accepted Answer · edited May 23 '17 at 11:57

1

take a look at Do I have to close the SQL Connection manually if I use Linq? in particular

LINQ to SQL will open and close connections when it needs to

Although if that code is in its own class you may wish to add a destructor that disposes of the data context, though that is up to you

edited May 23 '17 at 11:57

Community

1
1

answered Aug 04 '11 at 12:08

Manatherin

4,169
5
36
52

score 0 · Answer 2 · answered Aug 04 '11 at 11:46

I doubt that this is the actual code, but nevertheless here's why you're having a problem.

var res = from b in dc.Tbl1 select b;

is not actually executed (that is, database isn't hit) until after you "access" res variable (i.e., 'foreach' over it), which apparently happens elsewhere. When you do access res the actual DataContext is already closed, hence the error.

close connection database

2 Answers2