"How do you expose a LINQ query as an ASMX web service?
Usually, from the business tier, I can return a typed DataSet or a DataTable which can be serialized for transport over ASMX.
How can I do the same for a LINQ query?
Is there a way to populate a typed DataSet or a DataTable via a LINQ query?
public static MyDataTable CallMySproc()
string conn = ""..."";
MyDatabaseDataContext db = new MyDatabaseDataContext(conn);
MyDataTable dt = new MyDataTable();
// execute a sproc via LINQ
var query = from dr
// copy LINQ query resultset into a DataTable -this does not work !
dt = query.CopyToDataTable();
How could I put the result set of a LINQ query into a DataSet or a DataTable?
Alternatively, can the LINQ query be serializable so that I can expose it as an ASMX web service?
c# linq web-services .net-3.5
ShareShare a link to this question Copy linkCC BY-SA 4.0
Improve this question
Follow this question to receive notifications
edited Jan 7 at 14:09
111 silver badge
asked Aug 1 '08 at 4:59
Geoff DalgasGeoff Dalgas
5,90866 gold badges4040 silver badges5858 bronze badges"