vb.net - Casting Anonymous Type LINQ Using TryCast Returns Nothing -
i want query return list (of service) want use new list further filter.
when run query exectutes correctly
dim duplicateservice = svggrpcontainer.groupby(function(x) x.servicegroup).where(function(x) x.count > 1).select(function(x) x)
i attempting cast in oder use , create query
dim duplicatepak = duplicateservicegroups.groupby(function(x) x.name).where(function(x) x.count > 1).select(function(x) x)
when cast first query returns nothing
dim duplicateservice list(of servicegroup) = trycast(svggrpcontainer.groupby(function(x) x.servicegroup).where(function(x) x.count > 1).select(function(x) x), list(of servicegroup))
tolist throws grouping exception tried that.
how cast query can further filter data in subsequent queries? or use 1 query , group both group , name?
here's .net fiddle working solution (forgive c#).
c#: https://dotnetfiddle.net/puqnss vb.net: https://dotnetfiddle.net/aixeib
you need use anonymous object group multiple fields , selectmany flatten list.
the main idea is
dim duplicates list(of thing) = things. groupby(function(thing) new {key .name = thing.name, key .servicegroup = thing.servicegroup }). where(function(group) group.count() > 1). selectmany(function(group) group.tolist). tolist()
Comments
Post a Comment