public void DeleteUserQueryGeneratesCorrectQuery()
{
var generatedQuery = _queryFactory.GetDeleteQuery <DeleteUserQuery>();
const string expected = "DELETE FROM \"dbo\".\"IdentityUser\" WHERE \"Id\" = @Id";
Assert.Equal(expected, generatedQuery);
}
public void DeleteUserQueryGeneratesCorrectQuery()
{
var generatedQuery = _queryFactory.GetDeleteQuery <DeleteUserQuery>();
const string expected = "DELETE FROM `identity`.`identityuser` WHERE `Id` = @Id";
Assert.Equal(expected, generatedQuery);
}
public void DeleteUserQueryGeneratesCorrectQuery()
{
var generatedQuery = _queryFactory.GetDeleteQuery <DeleteUserQuery>();
const string expected = "DELETE FROM [dbo].[IdentityUser] WHERE [Id] = @Id";
Assert.Equal(expected, generatedQuery);
}
public async Task <bool> RemoveAsync(string id, CancellationToken cancellationToken)
{
try
{
var removeFunction = new Func <DbConnection, Task <bool> >(async x =>
{
try
{
var dynamicParameters = new DynamicParameters();
dynamicParameters.Add("Id", id);
var query = _queryFactory.GetDeleteQuery <DeleteUserQuery>();
var result = await x.ExecuteAsync(query, dynamicParameters, _unitOfWork.Transaction);
return(result > 0);
}
catch (Exception ex)
{
Logging.LogException(ex);
throw;
}
});
DbConnection conn = null;
if (_unitOfWork?.Connection == null)
{
using (conn = _connectionProvider.Create())
{
await conn.OpenAsync(cancellationToken);
return(await removeFunction(conn));
}
}
else
{
conn = _unitOfWork.CreateOrGetConnection();
return(await removeFunction(conn));
}
}
catch (Exception ex)
{
Logging.LogException(ex);
throw;
}
}
public void DeleteRoleQueryGeneratesCorrectQuery()
{
var generatedQuery = _queryFactory.GetDeleteQuery <DeleteRoleQuery>();
var expected = "DELETE FROM `identity`.`identityrole` WHERE `Id` = @Id";
Assert.Equal(expected, generatedQuery);
}
public void DeleteRoleQueryGeneratesCorrectQuery()
{
var generatedQuery = _queryFactory.GetDeleteQuery <DeleteRoleQuery>();
var expected = "DELETE FROM [dbo].[IdentityRole] WHERE [Id] = @Id";
Assert.Equal(expected, generatedQuery);
}
public virtual async Task <bool> DeleteAsync(T entity, CancellationToken cancellationToken)
{
if (entity != null)
{
try
{
var removeFunction = new Func <DbConnection, Task <bool> >(async x =>
{
var dynamicParameters = new DynamicParameters();
dynamicParameters.Add("Id", ((IEntity)entity).IdValue);
var query = _queryFactory.GetDeleteQuery <DeleteQuery, T>(entity);
var result = await x.ExecuteAsync(query, dynamicParameters, _unitOfWork.Transaction);
return(result > 0);
});
DbConnection conn = null;
if (_unitOfWork?.Connection == null)
{
using (conn = _connectionProvider.Create())
{
await conn.OpenAsync(cancellationToken);
return(await removeFunction(conn));
}
}
else
{
conn = _unitOfWork.CreateOrGetConnection();
return(await removeFunction(conn));
}
}
catch (Exception ex)
{
Logging.LogException(ex);
throw;
}
}
return(false);
}