//-----------------------------------------------------------------------
//  This file is part of the Microsoft .NET Framework SDK Code Samples.
// 
//  Copyright (C) Microsoft Corporation.  All rights reserved.
// 
//This source code is intended only as a supplement to Microsoft
//Development Tools and/or on-line documentation.  See these other
//materials for detailed information regarding Microsoft code samples.
// 
//THIS CODE AND INFORMATION ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY
//KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE
//IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A
//PARTICULAR PURPOSE.
//-----------------------------------------------------------------------

#using <mscorlib.dll>
#using <System.dll>
#using <System.Data.dll>

using namespace System;
using namespace System::Data;
using namespace System::Data::SqlClient;
using namespace System::Data::Common;

ref class executingacommand
{
public:
  void Run()
  {
    SqlConnection ^ myConnection = gcnew SqlConnection("server=(local)\\SQLExpress;Integrated Security=SSPI;database=northwind");
    SqlCommand ^ myCommand;
    SqlTransaction ^ myTrans;

    // Restore database to near it's original condifition so sample will work correctly.
    myConnection->Open();
    myCommand = gcnew SqlCommand("DELETE FROM Region WHERE (RegionID = 100) OR (RegionID = 101)", myConnection);
    myCommand->ExecuteNonQuery();

    myTrans = myConnection->BeginTransaction();
    // Assign transaction object for a pending local transaction
    myCommand->Transaction = myTrans;

    try
    {
      myCommand->CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
      myCommand->ExecuteNonQuery();
      myCommand->CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
      myCommand->ExecuteNonQuery();
      myTrans->Commit();
      Console::WriteLine("Both Records written to database");
    }
    catch(Exception ^ e)
    {
      myTrans->Rollback();
      Console::WriteLine(e->ToString());
      Console::WriteLine("Neither record written to database");
    }
    __finally
    {
      myConnection->Close();
    }
  }
};

void main()
{
	executingacommand ^ myexecutingacommand = gcnew executingacommand();
	myexecutingacommand->Run();
}