Need help on a relatively simple LINQ

Question

I have the following. Amount = d. intellisense does not have CompanyCode while it is in the GroupBy?

var detailGroups = headerGroup

.GroupBy(d => d.CompanyCode)

.Select(d => new

{

CompanCode = d.

});

Thanks.

Vulpes · Answer

CompanyCode won't show up in intellisense because the 'd' in your GroupBy method is different from the 'd' in your Select method. The 'd' in the latter is an IGrouping and so you need to use d.Key instead as you're grouping by CompanyCode.

DanYeung · Answer

Since the CompanyCode is group by I tried d.Key. but CompanyCode still not in the intellisense and neighter than any other columns. Thanks.

Jignesh Trivedi · Answer

hi In your query select work only on headerGroup so when use group by the you get collection of headerGroup depend on companycode. i.e. .Select(d => d); this query automatically convert your group by query. kindly provide more detail on same means table structure and more.. hope this help.

DanYeung · Answer

Thanks. But what is wrong in my LINQ. It seems simple and should work.

Jignesh Trivedi · Answer

hi try var detailGroups = (from t in headerGroup group t by new { t.CompanyCode } into groupFiles select new { groupFilesCompanyCode }); hope this help.