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); }