max date in a group by LINQ and VB.Net -

i have table settlement_date, settlement_period , publishing_date, zone_indicator , demand_outturn.

the data added table new demand_outturn estimate several times per date same settlement_date, settlement_period , zone_indicator new publishing_date

i have managed produce code below in vb.net lists max publishing_date data each period , outputs linqpad. however, i'm struggling put graph in asp.net using

for each mwt in query5

next

where can't find data elements

 dim query5 = q in sys_inddems q.settlement_date = "2016-03-20" _ , q.zone_indicator = "n" group q q.settlement_period g = group _ select perioddata = g, _ mw = p2 in g p2.publishing_date = g.max(function(p3)         p3.publishing_date)