I am creating dynamic select statement in a LINQ Query using the System.Linq.Dynamic reference.
However, I am having syntax issues with defining the field names I want selected from the query.
Code:
The highlighted portion of the code is where I am having syntax issues. This is the error it is giving me " No property or field 'Account' exists in type 'DataRow' "Code:Dim both = (From row1 In AddressListDatatable.AsEnumerable() Join row2 In MatrixDatatable.AsEnumerable() On row1.Field(Of String)("Offercode") Equals row2.Field(Of String)("Code") Select row1, row2) Dim data = both.Select("new (row1.Account, row1.First, row1.OFFERCODE, row2.OFFER, row2.Expiration)")




Reply With Quote
