LINQ to DataTable

[user1980]

hi,

I am trying to join two datatables using LINQ. I am unable to use .CopyToDataTable in my code. I have added System.Data.DataSetExtensions.dll. It gives me the error, 'CopyToDataTable' is not a member of 'System.Collections.Generic.IEnumerable(Of <anonymous type>)'.

I have searched online a lot about this. The solution was to add the dll which I did but still I get the error.

Also there are few suggestions for LINQ to datatable which are very huge. I would like to keep it simple. I am not sure, why the CopyToDataTable would not work for me.

here is my code, thank you for your time.

  Dim dt2 As New DataTable
            dt2.Load(dr2)
            Dim dt3 As New DataTable
            dt3.Load(dr3)
          Dim ds As New DataSet
 
 
 
         Dim joinquery = From t1 In dt2.AsEnumerable() Join t2 In dt3.AsEnumerable() _
                    On t1.Field(Of Decimal)("CLASS_NUMBER") Equals t2.Field(Of Decimal)("CLASS_NUMBER") _
                    Select New With _
                      {Key .CLASS_NUMBER = t1.Field(Of Decimal)("CLASS_NUMBER"), _
                       Key .FACULTY_START_DT = t2.Field(Of DateTime)("FACULTY_START_DT"), _
                       Key .FACULTY_END_DT = t2.Field(Of DateTime)("FACULTY_END_DT"), _
                       }
 
     ds = joinquery
 
 
            NewDg.DataSource = ds
            NewDg.DataBind()