public static async Task <IEnumerable <Person> > Execute(
IDbConnection dbConnection,
IDbConfigSchemaTargets dbConfigConfig,
Guid[] ids)
{
var sql = dbConfigConfig.BuildSql(ids, out var @params);
var res = await dbConnection.QueryAsync <Person>(sql, @params);
return(res);
}
public static Task Execute(
IDbConnection dbConnection,
IDbConfigSchemaTargets dbConfigConfig,
Guid id)
{
var sql = dbConfigConfig.BuildSql();
var @params = new DynamicParameters();
@params.Add(nameof(Person.PersonId), dbConfigConfig.CreateDatabaseParameterResolver().WithGuidParameterValue(id));
return(dbConnection.ExecuteAsync(sql, @params));
}
public static async Task Execute(
IDbConnection dbConnection,
IDbConfigSchemaTargets dbConfigConfig,
Person person)
{
var sql = dbConfigConfig.BuildSql();
var @params = new DynamicParameters();
@params.Add(nameof(Person.PersonId), dbConfigConfig.CreateDatabaseParameterResolver().WithGuidParameterValue(person.PersonId));
@params.Add(nameof(Person.Alive), dbConfigConfig.CreateDatabaseParameterResolver().WithBooleanParameterValue(person.Alive));
@params.Add(nameof(Person.Username), person.Username);
@params.Add(nameof(Person.Password), person.Password);
await dbConnection.ExecuteAsync(sql, @params);
}
