SqlConnection sqlConnection1 = new SqlConnection("Your Connection String");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;

cmd.CommandText = "SELECT * FROM Customers"; // violation
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;

sqlConnection1.Open();

reader = cmd.ExecuteReader();
// Data is accessible through the DataReader object here.

sqlConnection1.Close();

SqlConnection sqlConnection1 = new SqlConnection ("Data Source=server;integrated " +  "Security=sspi;initial catalog=pubs;");

SqlCommand testCmd = new SqlCommand  ("TestProcedure", sqlConnection1 );

testCmd.CommandType = CommandType.StoredProcedure;

SqlParameter RetVal = testCmd.Parameters.Add 
   ("RetVal", SqlDbType.Int);
PubsConn.Open();

SqlDataReader myReader = testCmd.ExecuteReader();
Console.WriteLine ("List of Customers:");
while (myReader.Read()) 
   {
     Console.WriteLine ("{0}", myReader.GetString (2));
   };
myReader.Close();