public Task <List <Session> > GetAccountSessionsAsync(Access.Account account)
{
return(Connection.QueryAsync <Session>(
@"
Select * From Sessions Where TeamID In (Select ID From Teams Where AccountID = ?)
", account.ID));
}
public Task <Team> GetTeamAsync(Access.Account account, string name)
{
return(Connection.Table <Team>().Where(t => t.AccountID == account.ID && t.Name == name).FirstOrDefaultAsync());
}
public Task <List <Team> > GetAccountTeamsAsync(Access.Account account)
{
return(Connection.Table <Team>().Where(t => t.AccountID == account.ID).ToListAsync());
}