Where should I keep connection to database

[stolikp]

Where should I keep connection object to database like ISession or SQLConnection?
What's the best solution and why ? Is it Application, Session or Items ?

[kumar169]

for creating the session "global.asax" file is right,
when you creating the session u must wright the code "Session["sec"] = 0" inside the Session_Start () function.
and for connection the web.config is right for connection string code is

<connectionStrings>
      <remove name="conn"/>
      <add name="conn" connectionString="Data Source=.;Initial Catalog=addbook;Integrated Security=True" providerName="System.Data.SqlClient"/>
    
  </connectionStrings>

[stolikp]

Okay, thanks. But If I could only choose one of three objects (Application, Session or Items) then which one would be the best solution ?

[amitdotchauhan]

Its not good practice to store connection in Memory for ASP.NET.
Make data layer which will connect to DB.
best practice keep Connection Pool so connection are not reopened all time(if frequent visit of database/multiple user)
Check http://www.15seconds.com/issue/040830.htm

[stolikp]

ok, thanks

[glennt]

I have never seen the "remove" code in the connection strings area. What is this needed for?

for creating the session "global.asax" file is right,
when you creating the session u must wright the code "Session["sec"] = 0" inside the Session_Start () function.
and for connection the web.config is right for connection string code is

<connectionStrings>
      <remove name="conn"/>
      <add name="conn" connectionString="Data Source=.;Initial Catalog=addbook;Integrated Security=True" providerName="System.Data.SqlClient"/>
    
  </connectionStrings>

http://infynet.wordpress.com

[catherine sea]

You may check this article about remove element:
http://msdn.microsoft.com/en-us/library/wkataz2t.aspx

[glennt]

You may check this article about remove element:
http://msdn.microsoft.com/en-us/library/wkataz2t.aspx

My question was not how to use the "remove" element, but why it is used. The link you left does not explain why to use it.