示例#1
0
        protected void BaseFixtureSetup()
        {
            var db = new ProjectFirmaSqlDatabase();

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