// GET api/Client/0?username=foo public IEnumerable <Client> GetClient(byte id, string username) { var userClients = db.spTICK_Users_Get(username).Select(c => c.ClientID).ToArray(); var clients = db.Clients.Where(p => userClients.Contains(p.ID)); return(clients.OrderBy(d => d.Description)); }