1 /// <summary>  
 2         /// 对SQLite数据库执行增删改操作，返回受影响的行数。  
 3         /// </summary>  
 4         /// <param name="sql">要执行的增删改的SQL语句</param>  
 5         /// <param name="parameters">执行增删改语句所需要的参数，参数必须以它们在SQL语句中的顺序为准</param>  
 6         /// <returns></returns>  
 7         public int ExecuteNonQuery(string sql, SQLiteParameter[] parameters)  
 8         {  
 9             int affectedRows = 0;  
10             using (SQLiteConnection connection = new SQLiteConnection(connectionString))  
11             {  
12                 connection.Open();  
13                 using (DbTransaction transaction = connection.BeginTransaction())  
14                 {  
15                     using (SQLiteCommand command = new SQLiteCommand(connection))  
16                     {  
17                         command.CommandText = sql;  
18                         if (parameters != null)  
19                         {  
20                             command.Parameters.AddRange(parameters);  
21                         }  
22                         affectedRows = command.ExecuteNonQuery();  
23                     }  
24                     transaction.Commit();  
25                 }  
26             }  
27             return affectedRows;  
28         }