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); } } } }
Author: coder
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(); } }
ConnectionReset
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(" Connection Reset = " + sb1.ConnectionReset); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.ConnectionReset = true; Console.WriteLine(" " + sb2.ConnectionString); } }
LoadBalanceTimeout
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(" Lifetime = " + sb1.LoadBalanceTimeout); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.LoadBalanceTimeout = 600; Console.WriteLine(" " + sb2.ConnectionString); } }
MaxPoolSize
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(" Max Pool Size = " + sb1.MaxPoolSize); SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString); sb2.MaxPoolSize = 15; Console.WriteLine(" " + sb2.ConnectionString); } }