dc

dc

  • NA
  • 663
  • 0

C# linq to sql connections

Feb 10 2013 11:00 PM
In  a C# 2008 windows application that use call a web service, there is a large volume of statements that look like the following:
In a C# 2008 application, I am using linq to sql statements that look like the following: 
 
  TDataContext TData = new TDataContext();
  var TNumber = (from dw in cms_TData.people
  where dw.Organization_Name.ToUpper().Trim() == strOrgnizationName.Trim().

  Right before every call that is made to the database, a new data context object is created.

Would this cause some kind of connection pooling problem to the database? If so, can you tell me how to resolve the connection pooling problem?



Answers (2)