private async Task UpdateFields(IDbConnection connection, TModel model, List <PropertyInfo> propertiesToUpdate)
{
var sql = propertiesToUpdate == _properties ? _updateSql : GetUpdateSql(propertiesToUpdate);
SqlBuilderExtensions.LogQuery(sql, model);
await connection.ExecuteAsync(sql, model);
}
private async Task <TModel> Insert(IDbConnection connection, TModel model)
{
SqlBuilderExtensions.LogQuery(_insertSql, model);
var id = await connection.ExecuteScalarAsync <int>(_insertSql, model);
_keyProperty.SetValue(model, id);
return(model);
}
private async Task UpdateFields(IDbConnection connection, IList <TModel> models, List <PropertyInfo> propertiesToUpdate)
{
var sql = propertiesToUpdate == _properties ? _updateSql : GetUpdateSql(propertiesToUpdate);
foreach (var model in models)
{
SqlBuilderExtensions.LogQuery(sql, model);
}
await connection.ExecuteAsync(sql, models);
}