public async Task <bool> UpdateAsync <T>(IDbConnection connection, T entity, IDbTransaction transaction, int?commandTimeout, string keyName, Snapshotter.Snapshot snapshot, IEnumerable <string> properties) where T : class
{
IClassMapper classMap = SqlGenerator.Configuration.GetMap <T>();
keyName = keyName ?? classMap.DefaultUpdateKeyName;
DynamicParameters diff = null;
if (snapshot != null && !classMap.IsPartialUpdateDisabled)
{
diff = snapshot.Diff();
var upl = diff.ParameterNames.ToList <string>();
if (upl.Count == 0)
{
return(true);
}
properties = upl;
}
bool updated = classMap.OnUpdate(entity);
if (updated && snapshot != null && !classMap.IsPartialUpdateDisabled)
{
diff = snapshot.Diff();
var upl = diff.ParameterNames.ToList <string>();
if (upl.Count == 0)
{
return(true);
}
properties = upl;
}
IPredicate predicate = GetKeyPredicate <T>(classMap, entity, keyName);
Dictionary <string, object> parameters = new Dictionary <string, object>();
string sql = SqlGenerator.Update(classMap, predicate, parameters, keyName, properties);
DynamicParameters dynamicParameters = new DynamicParameters();
var columns = classMap.Properties.Where(p => !(p.Ignored || p.IsReadOnly || p.IsInsertOnly || p.IsAnyKeyType(KeyType.Identity)) && (properties == null || properties.Contains(p.Name)));
if (diff != null)
{
foreach (var property in diff.ParameterNames.Where(property => columns.Any(c => c.Name == property)))
{
var val = ((SqlMapper.IParameterLookup)diff)[property];
dynamicParameters.Add(property, val);
}
}
else
{
foreach (var property in ReflectionHelper.GetObjectValues(entity).Where(property => columns.Any(c => c.Name == property.Key)))
{
dynamicParameters.Add(property.Key, property.Value);
}
}
foreach (var parameter in parameters)
{
dynamicParameters.Add(parameter.Key, parameter.Value);
}
return(await connection.ExecuteAsync(sql, dynamicParameters, transaction, commandTimeout, CommandType.Text) > 0);
}
/// <summary>
/// Executes an update query for the specified entity.
/// </summary>
public static bool Update <T>(this IDbConnection connection, T entity, IDbTransaction transaction = null, int?commandTimeout = null, string keyName = null, Snapshotter.Snapshot snapshot = null) where T : class
{
return(Instance.Update <T>(connection, entity, transaction, commandTimeout, keyName, snapshot, null));
}
