LINQ query does not support copytodatatable

Today, a customer said that when the copytodatatable method is used in the result set of the LINQ query, the resulting datatable is faulty. It was strange at the beginning. I searched the internet and found that this was indeed a problem.

Currently, the copytodatatable <t> method can only be used when T is a datarow (this function should be enhanced in later versions ). It cannot be used in our normal LINQ query. If you want to convert the result set after the LINQ Query into a datatable, you can write an iqueryable <t> or ienumerable <t> Extension Method by yourself. Here is a good example:

Http://blogs.msdn.com/aconrad/archive/2007/09/07/science-project.aspx

Have a nice day!