Filtering a List using LINQ -


hello have class called empowercalendarcode:

it has following fields calendarcode, calendarname, effectivestartdate, empowertaxtype, longagencycode, taxdepositfrequencybasetypeid.

i want filter list based on longagenycode , empowertaxtype. lets say:

public ilist<empowercalendarcode> getempowercalendarcodes(string longagencycode, string empowertaxtype) {       //todo:  } 

if more 1 empowercalendarcode same longagencycode, empowertaxtype has same taxdepositfrequencybasetypeid , should pick 1 has recent effectivestartdate. how ould able write linq query. okay if have 2 3 queries result.

any ideas , suggestions appreciated!

try this:

ctx.empowercalendarcodes .where(a=>a.longagencycode == longagencycode && a.empowertaxtype == empowertaxtype) .orderbydescending(a=>a.effectivestartdate) .firstordefault(); 

Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -