C#

SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlTransaction trans = conn.BeginTransaction();

try
{
string query = "query goes here";
SqlCommand command = new SqlCommand(query, conn, trans);
// add parameters
command.ExecuteNonQuery();
trans.Commit();
}
catch 
{ 
trans.Rollback();
}
finally
{
if(conn != null)
{
conn.Close();
conn.Dispose();
}
}

class AccessSpecifier
   {
      // private field:
      private int wheels = 3;

      // protected internal property:
       protected internal int Wheels
       {
           get { return wheels; }
           set { wheels = value;  }
       }

   }
   class Derieved : AccessSpecifier
   {
       public void fun()
       {
           Wheels = 90; //accessing private mem of base class
       }
   }
   class main
   {
       public static void Main()
       {
           AccessSpecifier a = new AccessSpecifier();
           a.Wheels = 4;
           Console.WriteLine(a.Wheels); // gives 4 as output
           Derieved d = new Derieved();
           d.fun();
           Console.WriteLine(d.Wheels); //gives 90 as output
           d.Wheels = 99; //accessing private mem of a class in same assembly   :omg:
           Console.WriteLine(d.Wheels);
           Console.ReadKey();

       }
   }