Best Practice: Convert LINQ Query result to a DataTable without looping

by

Use Linq to Dataset. From the MSDN : Creating a DataTable From a Query (LINQ to DataSet)

// Query the SalesOrderHeader table for orders placed 
// after August 8, 2001.
IEnumerable<DataRow> query =
    from order in orders.AsEnumerable()
    where order.Field<DateTime>("OrderDate") > new DateTime(2001, 8, 1)
    select order;

// Create a table from the query.
DataTable boundTable = query.CopyToDataTable<DataRow>();

If you have anonymous types :

From the Coder Blog : Using Linq anonymous types and CopyDataTable

It explains how to use MSDN’s How to: Implement CopyToDataTable Where the Generic Type T Is Not a DataRow

More Related Contents:

  1. Affect the datatable column value in C#
  2. LINQ query on a DataTable
  3. Sorting rows in a data table
  4. Read SQL Table into C# DataTable
  5. How can I conditionally apply a Linq operator?
  6. Combining n DataTables into a Single DataTable
  7. LINQ to SQL – Left Outer Join with multiple join conditions
  8. How to convert datatable to json string using json.net?
  9. Efficient DataTable Group By
  10. TransactionScope vs Transaction in LINQ to SQL
  11. Get SQL query from LINQ to SQL?
  12. How to write Asynchronous LINQ query?
  13. Metadata were not loaded using MetadataType
  14. How to insert a data table into SQL Server database table?
  15. How do you perform a CROSS JOIN with LINQ to SQL?
  16. .NET – Convert Generic Collection to DataTable
  17. A dependent property in a ReferentialConstraint is mapped to a store-generated column
  18. Exception using CopyToDataTable with “new {..}” LINQ query
  19. Get all associate/composite objects inside an object (in Abstract way)
  20. Datatable vs Dataset
  21. Accessing properties through Generic type parameter
  22. ‘CompanyName.Foo’ is a ‘namespace’ but is used like a ‘type’
  23. How do I do a left outer join with Dynamic Linq?
  24. SqlBulkCopy – The given value of type String from the data source cannot be converted to type money of the specified target column
  25. How to Read text file to DataTable [closed]
  26. How to convert DataTable to class Object?
  27. How can I convert a DataTable to an XML file in C#?
  28. Accessing System Databases/Tables using LINQ to SQL?
  29. If Else in LINQ
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment