Filling a DataSet or a DataTable from a LINQ query result set

by

As mentioned in the question, IEnumerable has a CopyToDataTable method:

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>();

Why won’t that work for you?

More Related Contents:

  1. LINQ’s Distinct() on a particular property
  2. LINQ query on a DataTable
  3. ‘Contains()’ workaround using Linq to Entities?
  4. Use LINQ to get items in one List, that are not in another List
  5. Concat all strings inside a List using LINQ
  6. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  7. Operation could destabilize the runtime?
  8. LINQ: Using INNER JOIN, Group and SUM
  9. LINQ to SQL in and not in
  10. Get All instead of FirstOrDefault
  11. How to write this nested foreach loop query in LINQ?
  12. Group by in LINQ
  13. Linq: GroupBy, Sum and Count
  14. Find an item in a list by LINQ
  15. How to detect installed version of MS-Office?
  16. Reading a file line by line in C#
  17. ToList()– does it create a new list?
  18. Combination of List
  19. LINQ Select Distinct with Anonymous Types
  20. Check if two lists are equal
  21. How to get the closest number from a List with LINQ?
  22. How to bring up the built-in File Copy dialog?
  23. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  24. How set value a property selector Expression
  25. linq distinct or group by multiple properties
  26. Filtering include items in LINQ and Entity Framework [duplicate]
  27. Remove item from list based on condition
  28. Consume a SOAP web service without relying on the app.config
  29. Changing App.config at Runtime
  30. Convert DataTable to Generic List in C#

Leave a Comment