using System; using System.Data.SqlClient; class MainClass { public static void Main(string[] args) { string conString = @"Data Source=.sqlexpress;" + "Database=Northwind;Integrated Security=SSPI;" + "Min Pool Size=5;Max Pool Size=15;Connection Reset=True;" + "Connection Lifetime=600;"; SqlConnectionStringBuilder sb1 = new SqlConnectionStringBuilder(conString); Console.WriteLine(" Database Source = " + sb1.DataSource); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.DataSource = @".sqlexpress"; Console.WriteLine(" " + sb2.ConnectionString); } }
Database ADO.net
Connection String
using System; using System.Data.SqlClient; class MainClass { public static void Main() { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = @"Data Source = .sqlexpress;" +// local SQL Server instance "Database = Northwind;" + // the sample Northwind DB "Integrated Security = SSPI;" + // integrated Windows security "Min Pool Size = 5;" + // configure minimum pool size "Max Pool Size = 15;" + // configure maximum pool size "Connection Reset = True;" + // reset connections each use "Connection Lifetime = 600"; // set max connection lifetime con.Open(); } using (SqlConnection con = new SqlConnection()) { con.ConnectionString = @"Data Source = .sqlexpress;" +//local SQL Server instance "Database = Northwind;" + //the sample Northwind DB "Integrated Security = SSPI;" + //integrated Windows security "Pooling = False"; //specify nonpooled connection con.Open(); } } }
PacketSize
using System; using System.Data; using System.Data.SqlClient; using System.Data.OleDb; class MainClass { public static void Main() { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = @"Data Source=.sqlexpress;Database=Northwind;Integrated Security=SSPI"; con.Open(); if (con.State == ConnectionState.Open) { Console.WriteLine(" Packet Size = " + con.PacketSize); } else { Console.WriteLine("SqlConnection failed to open."); Console.WriteLine(" Connection State = " + con.State); } } } }
ConnectionTimeout
using System; using System.Data; using System.Data.SqlClient; using System.Data.OleDb; class MainClass { public static void Main() { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = @"Data Source=.sqlexpress;Database=Northwind;Integrated Security=SSPI"; con.Open(); if (con.State == ConnectionState.Open) { Console.WriteLine(" Timeout = " + con.ConnectionTimeout); } else { Console.WriteLine("SqlConnection failed to open."); Console.WriteLine(" Connection State = " + con.State); } } } }
WorkstationId
using System; using System.Data; using System.Data.SqlClient; using System.Data.OleDb; class MainClass { public static void Main() { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = @"Data Source=.sqlexpress;Database=Northwind;Integrated Security=SSPI"; con.Open(); if (con.State == ConnectionState.Open) { Console.WriteLine(" Workstation Id = " + con.WorkstationId); } else { Console.WriteLine("SqlConnection failed to open."); Console.WriteLine(" Connection State = " + con.State); } } } }
SqlConnection properties
using System; using System.Data; using System.Data.SqlClient; class MySqlConnection { public static void Main() { string connectionString = "server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI"; SqlConnection mySqlConnection = new SqlConnection(connectionString); mySqlConnection.Open(); Console.WriteLine("mySqlConnection.ConnectionString = "+mySqlConnection.ConnectionString); Console.WriteLine("mySqlConnection.ConnectionTimeout = "+mySqlConnection.ConnectionTimeout); Console.WriteLine("mySqlConnection.Database = "+mySqlConnection.Database); Console.WriteLine("mySqlConnection.DataSource = "+mySqlConnection.DataSource); Console.WriteLine("mySqlConnection.PacketSize = "+mySqlConnection.PacketSize); Console.WriteLine("mySqlConnection.ServerVersion = "+mySqlConnection.ServerVersion); Console.WriteLine("mySqlConnection.State = "+mySqlConnection.State); Console.WriteLine("mySqlConnection.WorkstationId = "+mySqlConnection.WorkstationId); mySqlConnection.Close(); } }
Generate SQL command automatically from SqlCommandBuilder and SqlDataAdapter
using System; using System.Data; using System.Data.SqlClient; class Class1{ static void Main(string[] args){ SqlConnection thisConnection = new SqlConnection("server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI"); thisConnection.Open(); SqlDataAdapter thisAdapter = new SqlDataAdapter("SELECT ID from Employee", thisConnection); SqlCommandBuilder thisBuilder = new SqlCommandBuilder(thisAdapter); Console.WriteLine("SQL SELECT Command is: {0} ", thisAdapter.SelectCommand.CommandText); SqlCommand updateCommand = thisBuilder.GetUpdateCommand(); Console.WriteLine("SQL UPDATE Command is: {0} ", updateCommand.CommandText); SqlCommand insertCommand = thisBuilder.GetInsertCommand(); Console.WriteLine("SQL INSERT Command is: {0} ", insertCommand.CommandText); SqlCommand deleteCommand = thisBuilder.GetDeleteCommand(); Console.WriteLine("SQL DELETE Command is: {0}", deleteCommand.CommandText); thisConnection.Close(); } }