public override string[] GetRolesForUser(string userEmail) { using (SupermarketEntitiesDB _Context = new SupermarketEntitiesDB()) { var userRoles = (from user in _Context.Users join roleMapping in _Context.Permissions on user.usertype equals roleMapping.TypeID where user.emailAddress == userEmail select roleMapping.TypeName).ToArray(); return(userRoles); } }