public async Task <IEnumerable <Manufacturers> > GetByID(int id) { return(new List <Manufacturers>() { IspContext.Find <Manufacturers>(id) }); return(await(from manuf in IspContext.Manufacturers where id == manuf.Id select manuf).ToListAsync()); /*return await (from item in IspContext.Items * join manuf in IspContext.Manufacturers on item.ManufacturerId equals manuf.Id * join cat in IspContext.ItemCategories on item.CategoryId equals cat.Id * where item.Id == id * select new Items() * { * Category = cat, CategoryId = cat.Id, Description = item.Description, Height = item.Height, * Id = item.Id, Manufacturer = manuf, ManufacturerId = manuf.Id, Name = item.Name, Price = item.Price, * Width = item.Width * }).ToListAsync();*/ }