trying to conver the following VB.net Linq to C# Linq
Dim query =
From row In dt.AsEnumerable
Group row By G = New With {.Price = row.Field(Of Double?)("price")}.Price,
New With {.Cat = row.Field(Of Integer?)("category")}.Cat
Into ProductGroups = Group
i've tried some websites but none worked as expected.
The online converters are not handling this, so this must be frustrating for you. Try this:
var query = from row in dt.AsEnumerable
group row by new {Price = row.Field<double?>("price")}.Price, new {Cat = row.Field<int?>("category")}.Cat into g
select new {G = g.Key, g};
new { Price = row.Field<double?>("price), Cat = row.Field<int?>("category") }, yours is a conversion of what is already there.In order to answer your problem instead of converting it for you. Make sure you use proper syntax in the converters.
Here is what you are looking for to convert:
Dim query = _
From row In dt.AsEnumerable _
Group row By G = New With {.Price = row.Field(Of Double?)("price")}.Price, _
New With {.Cat = row.Field(Of Integer?)("category")}.Cat _
Into ProductGroups = Group
Even though it is not needed in VB2012, it seems like in the converters still use the _ character to specify that the statement is not complete on that line.
You can use the link listed in the comments to the question to convert it now.
_ is not needed in VB2012. It appears that the convertors have not been updated to take that into consideration.
line 1 col 2: EOF expected