public static int Update(this IDbConnection connection, dynamic data, dynamic condition, string table, IDbTransaction transaction = null, int?commandTimeout = null) { var obj = data as object; var properties = GetProperties(obj); var updateFields = string.Join(",", properties.Select(p => p + " = @" + p)); var conditionObj = condition as object; var whereProperties = GetProperties(conditionObj); var where = string.Join(" and ", whereProperties.Select(p => p + " = @" + p)); var sql = string.Format("update [{0}] set {1} where {2}", table, updateFields, where); var parameters = new DynamicParameters(data); parameters.AddDynamicParams(condition); return(SqlMapper.Execute(connection, sql, parameters, transaction, commandTimeout)); }
public int Execute(string sql, dynamic param = null, int?commandTimeout = null, CommandType?commandType = null) #endif { CreateOrReuseConnection(); //Dapper expects a connection to be open when calling Execute, so we'll have to open it. bool wasClosed = _connection.State == ConnectionState.Closed; if (wasClosed) { _connection.Open(); } try { return(SqlMapper.Execute(_connection, sql, param, GetCurrentTransaction(), commandTimeout, commandType)); } finally { if (wasClosed) { _connection.Close(); } } }
public int Execute(string sql, dynamic param = null) { return(SqlMapper.Execute(connection, sql, param as object, transaction, commandTimeout: this.commandTimeout)); }
public static void Update(this IDbConnection cnn, string tableName, dynamic param) { SqlMapper.Execute(cnn, DynamicQuery.GetUpdateQuery(tableName, param), param); }
public static int Execute(this IDbConnection cnn, string sql, object param = null, IDbTransaction transaction = null, int?commandTimeout = null, CommandType?commandType = null) { TRACE(sql); return(SqlMapper.Execute(cnn, sql, param, transaction, commandTimeout, commandType)); }