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