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