// https://www.learnentityframeworkcore.com/dbset/querying-data
public override async Task <User> GetSingleAsync(Expression <Func <User, bool> > predicate, bool disableTracking = true, CancellationToken cancellationToken = default(CancellationToken))
{
User user = null;
try
{
user = await DatabaseSet
.Include(cmp => cmp.Employee).ThenInclude(emp => emp.EmployeeAddress)
.Include(cmp => cmp.Employee).ThenInclude(emp => emp.Department)
.AsNoTracking()
.SingleOrDefaultAsync(predicate, cancellationToken);
return(user);
}
catch (Exception)
{
return(user);
}
}
// https://www.learnentityframeworkcore.com/dbset/querying-data
public override async Task <Company> GetSingleAsync(Expression <Func <Company, bool> > predicate, bool disableTracking = true, CancellationToken cancellationToken = default(CancellationToken))
{
Company company = null;
try
{
company = await DatabaseSet
.Include(cmp => cmp.Employees).ThenInclude(emp => emp.EmployeeAddress)
.Include(cmp => cmp.Employees).ThenInclude(emp => emp.Department)
.Include(cmp => cmp.Employees).ThenInclude(emp => emp.User)
.AsNoTracking()
.SingleOrDefaultAsync(predicate, cancellationToken).ConfigureAwait(false);
return(company);
}
catch (Exception)
{
return(company);
}
}
public override async Task <Employee> GetSingleAsync(Expression <Func <Employee, bool> > predicate, bool disableTracking = true, CancellationToken cancellationToken = default(CancellationToken))
{
Employee employee = null;
try
{
// https://www.learnentityframeworkcore.com/dbset/querying-data
employee = await DatabaseSet
.Include(emp => emp.Company)
.Include(emp => emp.Department)
.Include(emp => emp.EmployeeAddress)
.Include(emp => emp.User)
.AsNoTracking()
.SingleOrDefaultAsync(predicate, cancellationToken).ConfigureAwait(false);
return(employee);
}
catch (Exception)
{
return(employee);
}
}
