protected void BaseFixtureSetup()
        {
            var db = new TempDbSqlDatabase();

            SQLConnection = db.CreateConnection();
            SQLConnection.Open();
        }
 private static DataTable ExecuteSql(string sqlStatements, SqlConnection connection)
 {
     using (var comm = new SqlCommand(sqlStatements, connection))
     {
         comm.CommandType    = CommandType.Text;
         comm.CommandTimeout = CommandTimeoutInSeconds;
         var sqlResult = TempDbSqlDatabase.ExecuteSqlCommand(comm);
         if (sqlResult.Tables.Count > 0)
         {
             return(sqlResult.Tables[0]);
         }
         return(null);
     }
 }