Use of SqlConnection Class

[Khan Baba]

Hi friends,

I need you help to know about the 'SqlConnection' class. What is the use of "SqlConnection class"?. According to my knowledge it mey be related to the SQL database connection, But I am not confirmed on this. I wonder if you are able to give me some details about "SqlConnection class". It will be great if you provide any proper example of this class. Your any help would be appreciated.

[kelfro]

A SqlConnection class represents a unique session to a SQL data source. This class supports cross-form data binding with the Inter Form Technology. When you make an instance to the SqlConnection, entire properties are set to initial values. If the SqlConnection is out of it's scope, then it won't be closed. Therefore, you must explicitly close the connection by calling Close or Dispose. SqlConnection Class represents an open connection to an SQL Server database. This class cannot be inherited.

[Zecho]

SqlConnection class is normally used with SqlDataAdapter and SqlCommand to optimize performance when connecting to a database Microsoft SQL Server. In case of generation SqlException by executing the method SqlCommand, SqlConnection remains open when the severity level is less than or equal to 19. In other words, you can not execute a SQL statement while an asynchronous operation is in progress. When the severity level is greater than or equal to 20, the server closes normally SqlConnection. The User may reopen the connection and continue. For a list of these values, consult the manufacturer SqlConnection.

[Reegan]

Following is the example of SqlConnection Class:

using System;
using System.Data.SqlClient;

class ProgramDem
{
static void Main()
{

using (SqlConnection con1 = new SqlConnection(connectionString))
{


con1.Open();

using (SqlCommand command1 = new SqlCommand("SELECT TOP 2 * FROM Dogs1", con))

using (SqlDataReader reader1 = command1.ExecuteReader())

{
while (reader1.Read())
{
Console.WriteLine("{0} {1} {2}",
reader.GetInt32(0), reader1.GetString(1), reader1.GetString(2));
}
}
}
}
}

[opaper]

With a database client / server, it is equivalent to a network connection to the server. SqlConnection class creates security demands by using the object SqlClientPermission. When you create an instance of SqlConnection class , all properties are set to their initial values.Users can verify that their code has sufficient permissions using the object SqlClientPermissionAttribute. Users can also use the Tool Code Access Security Policy Tool to modify security policy at the computer, user and enterprise. For more information, see Security in the. NET Framework. For an example describing how to use security demands, see Access Security and ADO.NET code.

[MindSpace]

This class represents an open connection to the SQL Server database. There are various methods of SqlConnetion class. InitializeLifetimeService() method is used to tets a service object lifetime strategy for controlling lifetime in this forum. While the GetLifetimeService() methos is used for to gets the service object of life during which the control strategy of life in this forum. If the connection pooling value Pooling is set to true or yes, the underlying connection is returned back to the connection pool.