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