Need to copy LINQ query to datatable (CopyToDataTable not working)
I need to copy a LINQ query to a datatable, and was hoping to do this simply using CopyToDataTable. FYI this is running on ASP.NET 4.0 framework.
From what I've gathered, the LINQ query needs to be "Enumerable." I've tried a couple of variations on code samples I've found, but nothing works. Here are the 2 different code samples:
Running this causes the error:
Unable to cast object of type 'System.Data.Linq.DataQuer
... and ...
Running this causes the error: Compiler Error Message: BC30456: 'CopyToDataTable' is not a member of 'System.Collections.Generi
Any suggestions? I was excited to see that LINQ was providing an easy way to export its results into a datatable, but it doesn't seem to be straightforward after all.
From what I've gathered, the LINQ query needs to be "Enumerable." I've tried a couple of variations on code samples I've found, but nothing works. Here are the 2 different code samples:
Dim dc As New UserDataContext
Dim q As IEnumerable(Of DataRow) = From iterVar In dc.UserDetails _
Select iterVar.ID, iterVar.FirstN, iterVar.LastN
Dim dtTest As DataTable = q.CopyToDataTable()Running this causes the error:
Unable to cast object of type 'System.Data.Linq.DataQuer
... and ...
Dim dc As New UserDataContext
Dim q = From iterVar In dc.UserDetails.AsEnumerable _
Select iterVar.ID, iterVar.FirstN, iterVar.LastN
Dim dtTest As DataTable = q.CopyToDataTable()Running this causes the error: Compiler Error Message: BC30456: 'CopyToDataTable' is not a member of 'System.Collections.Generi
Any suggestions? I was excited to see that LINQ was providing an easy way to export its results into a datatable, but it doesn't seem to be straightforward after all.
i dont think there is anything built in .net to convert a linq query to DataTable
ooops sorry my bad... scratch my previous post..
try this
Dim dc As New UserDataContext
Dim q As IEnumerable(Of DataRow) = From iterVar In dc.UserDetails _
Select iterVar
Dim dtTest As DataTable = q.CopyToDataTable();
try this
Dim dc As New UserDataContext
Dim q As IEnumerable(Of DataRow) = From iterVar In dc.UserDetails _
Select iterVar
Dim dtTest As DataTable = q.CopyToDataTable();
ASKER
That causes the same error as my first code example. The only difference between it and your example seems to be the Select cause.
Is there something else that should be different, to fix the "Unable to cast object of type 'System.Data.Linq.DataQuer
Is there something else that should be different, to fix the "Unable to cast object of type 'System.Data.Linq.DataQuer
what is the type of dc.UserDetails ?? is dc a data set ? the method we are playing around with(CopyToDataTable) will only work if 'dc' is a dataset/datatable
other wise we need to create a method which will do the conversion.
other wise we need to create a method which will do the conversion.
ASKER
dc.UserDetails is just a regular datacontext for use by LINQ. What I'm trying to do is take LINQ query and convert it into a datatable. This can be done according to http://msdn.microsoft.com/en-us/library/bb386921.aspx.
However, I can't get the code to work.
However, I can't get the code to work.
yep, in the article u have posted order is a data table extracted from ds.Tables("SalesOrderHeade
ASKER
Oh, yeah, I totally missed that. I was Googling on "fill datatable with linq query" and most of the pages I saw *did* deal LINQ queries that did NOT use datatables, and so I overlooked this on http://msdn.microsoft.com/en-us/library/bb3869
So, back to the original question. How to export a datatable from a LINQ (to SQL) query? Any simple methods?
So, back to the original question. How to export a datatable from a LINQ (to SQL) query? Any simple methods?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! The iterative code you provided is what I need to get my project done.
Not a problem, glad I was able to help. ;=)