public async Task Update <T>(T obj) { using SqlConnection connection = new SqlConnection(connectionString); var queryString = MapTable.BuilderUpdate(obj); SqlCommand command = new SqlCommand(queryString, connection); var parameters = MapTable.BuilderParameters(obj, true); foreach (var parameter in parameters) { command.Parameters.Add(parameter); } command.Connection.Open(); await command.ExecuteNonQueryAsync(); await connection.CloseAsync(); }
public async Task Save <T>(T obj) { using SqlConnection connection = new SqlConnection(connectionString); var queryString = MapTable.BuilderInsert(obj); SqlCommand command = new SqlCommand(queryString, connection); var parameters = MapTable.BuilderParameters(obj); foreach (var parameter in parameters) { command.Parameters.Add(parameter); } command.Connection.Open(); MapTable.SetIdOfEntity(obj, await command.ExecuteScalarAsync()); await connection.CloseAsync(); }