Csharp/C Sharp/Database ADO.net/Connection String

Ole db connection string for SQL Server

<source lang="csharp"> using System; using System.Data.OleDb; public class ReadFromOleDb {

 [STAThread]
 static void Main(string[] args)
 {
   String sConn = "provider=sqloledb;server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
   
   String sSQL = "select id, firstname, lastname from Employee";
   OleDbConnection oConn = new OleDbConnection(sConn);
   oConn.Open();
   OleDbCommand oCmd = new OleDbCommand(sSQL, oConn);
   OleDbDataReader oReader = oCmd.ExecuteReader();
   int idxID = oReader.GetOrdinal("id");
   int idxFirstName = oReader.GetOrdinal("firstname");
   int idxLastName = oReader.GetOrdinal("lastname");
   while(oReader.Read()) {
     Console.WriteLine("{0} {1} {2}",
       oReader.GetValue(idxID),
       oReader.GetValue(idxFirstName),
       oReader.GetValue(idxLastName));
   }
 }

}

      </source>

SqlConnection connection string

<source lang="csharp">

   using System;
   using System.Data.SqlClient;
 
 class ConnectToSqlConnection {
   static void Main(string[] args)  {
     String sConn = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
       String sSQL = "select id, firstname, lastname from Employee";
     SqlConnection oConn = new SqlConnection(sConn);
     oConn.Open();
     SqlCommand oCmd = new SqlCommand(sSQL, oConn);
     SqlDataReader oReader = oCmd.ExecuteReader();
     int idxID = oReader.GetOrdinal("id");
     int idxFirstName = oReader.GetOrdinal("firstname");
     int idxLastName = oReader.GetOrdinal("lastname");
     while(oReader.Read()) {
       Console.WriteLine("{0} {1} {2}",
         oReader.GetValue(idxID),
         oReader.GetValue(idxFirstName),
         oReader.GetValue(idxLastName));
     }
   }
 }

      </source>