C#

lock (MyList)
{
   MyList.Find(delegate (MyListObject mlo) {return mlo.MyString == "hello";});
}

Dewald wrote:

If you put your SqlTransaction in a using block, when is it committed?

Dewald wrote:

What happens if an exception occurs?

Dewald wrote:

Will it automatically roll back?

I are Troll

using (SqlConnection cn = new SqlConnection()) 
using (SqlTransaction tr = cn.BeginTransaction())      
{ 
      //some code 
      tr.Commit(); 
} 

  using (SqlTransaction mySqlTransaction = mySqlConnection.BeginTransaction())
{
    // First SQL command that is part of an atomic transaction
    using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
    {
        mySqlCommand.ExecuteScalar(); // or whatever
    }   // Second SQL command that is part of an atomic transaction
    using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
    {
        mySqlCommand.ExecuteScalar(); // or whatever
    }
    mySqlTransaction.Commit();
}

SqlTransaction mySqlTransaction = new;
try
{
   mySqlTransaction = mySqlConnection.BeginTransaction();
   // First SQL command that is part of an atomic transaction
   using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
   {
      mySqlCommand.ExecuteScalar(); // or whatever
   }

   // Second SQL command that is part of an atomic transaction
   using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
   {
      mySqlCommand.ExecuteScalar(); // or whatever
   }

   mySqlTransaction.Commit();

   // Now we do stuff during which we don't want to have the DB locked

   mySqlTransaction = mySqlConnection.BeginTransaction();
   // First SQL command that is part of another atomic transaction
   using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
   {
      mySqlCommand.ExecuteScalar(); // or whatever
   }

   // Second SQL command that is part of another atomic transaction
   using (SqlCommand sqlCommand = new SqlCommand("...", mySqlConnection, mySqlTransaction))
   {
      mySqlCommand.ExecuteScalar(); // or whatever
   }
}
catch
{
   mySqlTransaction.Rollback();
}

Dewald wrote:

can I start the transaction again or do I have to close the using block and open a new using block to start a new transaction?

Dewald wrote:

but not a SqlTransaction

Dewald wrote:

nothing else inside

Dewald wrote:

what is this "using" keyword called?

Rags1512 wrote:

we know everything in .Net is derived from System.Object, even value and reference types.

Rags1512 wrote:

Question is where does the employeeCount will get stored(Stack or Heap) and Where does the cmpny gets stored?

Rags1512 wrote:

So, how does CLR differentiate between the two and stores the value type on Stack and reference types on Heap?

Rags1512 wrote:

we know everything in .Net is derived from System.Object, even value and reference types.

Rags1512 wrote:

will get stored(Stack or Heap)

Rags1512 wrote:

how does CLR differentiate between the two

Rags1512 wrote:

stores the value type on Stack and reference types on Heap

Rags1512 wrote:

Question is where does the employeeCount will get stored(Stack or Heap) and Where does the cmpny gets stored?

con = new SqlConnection("server=xxx;database=xxx;uid=xxx;pwd=xxx");
cmd.Parameters.Add("@StartDate", SqlDbType.DateTime).Value = StartDate.Text;
cmd.Parameters.Add("@EndDate", SqlDbType.DateTime).Value = EndDate.Text;
cmd = new SqlCommand("insert_with_sproc", con);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
con.Close();