/// <summary>Delete by object's PropertyName.<para>When done dispose connection.</para></summary> /// <param name="connection">Database connection.</param> /// <param name="tableName">Target database's table.</param> /// <param name="whereCondition">Where condition extracted from PropertyName.</param> /// <param name="parameterSymbol">Command parameter symbol. SqlServer = '@', MySql = '?', Oracle = ':'</param> /// <returns>Rows affected.</returns> public static int Delete(IDbConnection connection, string tableName, object whereCondition, char parameterSymbol = '@') { using (var exec = new DbExecutor(connection, parameterSymbol)) { return(exec.Delete(tableName, whereCondition)); } }
/// <summary>Delete by object's PropertyName.<para>When done dispose connection.</para></summary> /// <param name="connection">Database connection.</param> /// <param name="tableName">Target database's table.</param> /// <param name="whereCondition">Where condition extracted from PropertyName.</param> /// <param name="parameterSymbol">Command parameter symbol. SqlServer = '@', MySql = '?', Oracle = ':'</param> /// <returns>Rows affected.</returns> public static int Delete(IDbConnection connection, string tableName, object whereCondition, char parameterSymbol = '@') { Contract.Requires <ArgumentNullException>(connection != null); Contract.Requires <ArgumentException>(!String.IsNullOrEmpty(tableName)); Contract.Requires <ArgumentNullException>(whereCondition != null); using (var exec = new DbExecutor(connection, parameterSymbol)) { return(exec.Delete(tableName, whereCondition)); } }