Skip to content

Instantly share code, notes, and snippets.

@erdtsieck
Last active August 29, 2015 14:13
Show Gist options
  • Save erdtsieck/b3cb4ff1104db0e1b3e6 to your computer and use it in GitHub Desktop.
Save erdtsieck/b3cb4ff1104db0e1b3e6 to your computer and use it in GitHub Desktop.
fetch cats and products
var cat = RebaContext.CategoryLanguages
.SingleOrDefault(cl => cl.Slug == categoryName && cl.Language.Iso == culture);
var categoryAndProducts = new ShowProductsModel
{
Category = cat.Title,
Products = cat.Category.Products
.Select(p => new ShowProductsProductModel
{
Id = p.Id,
ShortDescription = p.Languages.FirstOrDefault(l => l.Language.Iso == culture).ShortDescription,
Title = p.Languages.FirstOrDefault(l => l.Language.Iso == culture).Title
})
};
@Vannevelj
Copy link

var cat = RebaContext.CategoryLanguages
.SingleOrDefault(cl => cl => cl.Slug == categoryName && cl.Language.Iso == culture)
.Select(new ShowProductsModel
{
Category = cat.Title,
Products = cat.Category.Products
.Select(p => new ShowProductsProductModel
{
Id = p.Id,
ShortDescription = p.Languages.FirstOrDefault(l => l.Language.Iso == culture).ShortDescription,
Title = p.Languages.FirstOrDefault(l => l.Language.Iso == culture).Title
})
};

@erdtsieck
Copy link
Author

You cannot Select() on a SingleOrDefault() Result.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment