public async Task Update(TData entity)
{
var entityType = entity.GetType();
await dbQuery.ExecuteCommandAsync(
$@"UPDATE [dbo].[{DbEntityHelper.GetDbTableName(entityType)}] SET
{DbEntityHelper.GetUpdatePropertiesString(entity)}
WHERE Id = @Id
", DbEntityHelper.GetSqlParameters(entity, excludeId : false).ToArray());
}
public Task <long> Add(TData entity)
{
var entityType = entity.GetType();
return(dbQuery.ExecuteInsertCommandAsync(
$@"INSERT INTO [dbo].[{DbEntityHelper.GetDbTableName(entityType)}]
(
{DbEntityHelper.GetPropertiesString(entityType)}
)
VALUES
(
{DbEntityHelper.GetSqlParametersString(entity)}
)", DbEntityHelper.GetSqlParameters(entity).ToArray()));
}
