示例#1
0
 public void SaveChanges()
 {
     try
     {
         DbSqlConnection.Open();
         for (int i = 0; i < ListSqlSentence.Count; i++)
         {
             ListSqlSentence[i].ExecuteNonQuery();
             ListFnActions[i]();
         }
     }
     catch (SqlException ex)
     {
         throw ex;
     }
     finally
     {
         if (DbSqlConnection.State == ConnectionState.Open)
         {
             DbSqlConnection.Close();
         }
         if (ListFnActions != null)
         {
             ListFnActions.Clear();
         }
         if (ListSqlSentence != null)
         {
             ListSqlSentence.Clear();
         }
     }
 }
示例#2
0
        public void Dispose()
        {
            if (DbSqlConnection.State == ConnectionState.Open)
            {
                DbSqlConnection.Close();
            }

            DbSqlCommand.Dispose();
            DbSqlConnection.Dispose();
        }