Read SQL connection string from XML

sqlFactory.cs

/* This is an example of a connectionString node. 
<connectionStrings>
  <add name="YourConnectionStringKey" 
             providerName="System.Data.SqlClient"
             connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=YourDB;Trusted_Connection=Yes" />
</connectionStrings>

*/

// Global Var outside of CRUD methods
string _connectionString = 
                ConfigurationManager.ConnectionStrings["YourConnectionStringKey"].ConnectionString;
 
// Global vars
SqlConnection _connection;
SqlTransaction _transaction;

int GetData() {

int retVal = 0;

        _connection.Open();

        // Start a local transaction.
        _transaction = _connection.BeginTransaction("SampleTransaction");

        // Must assign both transaction object and connection 
        // to Command object for a pending local transaction
        command.Connection = connection;
        command.Transaction = transaction;

        try
        {
          DAOClass daoClass = new DAOClass(_connection, _transaction);
          retVal = daoClass.GetData();
          transaction.Commit();
          return retVal;
        }
        catch (Exception ex)
        {
            transaction.RollBack();
            Log(ex.ToString());
        }
    }