LINQ to DataTable- Get query value in Datatable issue(CopyToDataTable)

Question

My goal is that join operation are being done and that query value have to store in Datatable.

var query = from db_data1 in DBData1.AsEnumerable()
            join cust_data1 in DBData2.AsEnumerable()
            on db_data1.Field<string>("FULLNAME").Trim() equals
            cust_data1.Field<string>("Name").Trim()
            where 
            cust_data1.Field<string>("Apartment").Trim() == db_data1.Field<string>("SERVICE_APARTMENT").Trim()
            &&   cust_data1.Field<string>("Name").Trim() == db_data1.Field<string>("FULLNAME").Trim()
            select new
              {
                  Name = db_data1.Field<string>("FULLNAME"),
                  ACCOUNT_NUMBER = db_data1.Field<string>("ACCOUNT_NUMBER")
              };

           DataTable merged;
           if (query.Any())
               merged = query.**CopyToDataTable**();
           else
               merged = DBData1.Clone();

But here i am getting error in CopyToDataTable() fuction that

The type 'AnonymousType#1' cannot be used as type parameter 'T' in the generic type or method 'System.Data.DataTableExtensions.CopyToDataTable(System.Collections.Generic.IEnumerable)'. There is no implicit reference conversion from 'AnonymousType#1' to 'System.Data.DataRow'.

How to resolve this issue?

Answer 1

The query is returning an IEnumerable of anonymous type because you're creating a type-less sequence with select new { }

If you select using a definitive destination type - ie, select CustDataRow - you'll be able to use CopyToDataTable(), though for your purposes this might require you to create a helper object.