MonkeyWrench.DB.ExecuteNonQuery C# (CSharp) Method

ExecuteNonQuery() public method

public ExecuteNonQuery ( string sql ) : int
sql string
return int
		public int ExecuteNonQuery (string sql)
		{
			using (IDbCommand cmd = CreateCommand ()) {
				cmd.CommandText = sql;
				return cmd.ExecuteNonQuery ();
			}
		}

Usage Example

示例#1
0
		static void CleanupLogins ()
		{
			int r;
			try {
				Stopwatch watch = new Stopwatch ();
				watch.Start ();
				using (DB db = new DB ()) {
					r = db.ExecuteNonQuery ("DELETE FROM login WHERE expires < now();");
				}
				watch.Stop ();
				Logger.Log ("Maintenance: successfully cleaned up logins ({0} affected records) in {1} seconds", r, watch.Elapsed.TotalSeconds);
			} catch (Exception ex) {
				Logger.Log ("Maintenance: failed to cleanup logins: {0}", ex);
			}
		}
All Usage Examples Of MonkeyWrench.DB::ExecuteNonQuery