{"id":4393,"date":"2008-05-13T21:35:00","date_gmt":"2008-05-13T21:35:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/vbteam\/2008\/05\/13\/using-linq-to-dataset-in-an-aspx-page-jonathan-aneja\/"},"modified":"2024-07-05T14:25:23","modified_gmt":"2024-07-05T21:25:23","slug":"using-linq-to-dataset-in-an-aspx-page-jonathan-aneja","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/vbteam\/using-linq-to-dataset-in-an-aspx-page-jonathan-aneja\/","title":{"rendered":"Using LINQ to Dataset in an .aspx page (Jonathan Aneja)"},"content":{"rendered":"

Recently I got a customer question about how to use LINQ to Dataset<\/a> in an .aspx file.  <\/span>The compiler was complaining that it couldn’t find the AsEnumerable method that allows LINQ to work over a DataTable (“AsEnumerable is not a member of ‘DataTable'”).  <\/span>The code he sent looks correct, so why is the compiler not picking up the extension method (defined in System.Data.DataSetExtensions.dll)?<\/p>\n

<\/font><\/font><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n

<%<\/span>@<\/span> Page<\/span> Language<\/span>=”vb”<\/span> AutoEventWireup<\/span>=”false”<\/span> CodeBehind<\/span>=”Default.aspx.vb”<\/span> Inherits<\/span>=”WebApplication6._Default”<\/span> %><\/p>\n

<\/span><\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

<%<\/span>@<\/span> Import<\/span> Namespace<\/span>=”System.Linq”<\/span> %><\/p>\n

<\/span><\/span><\/p>\n

<%<\/span>@<\/span> Import<\/span> Namespace<\/span>=”System.Data.DataSetExtensions”<\/span> %><\/p>\n

<\/span><\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

<<\/span>script<\/span> runat<\/span>=”server”><\/p>\n

<\/span><\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

    <\/span>Sub<\/span> Page_Load(sender As<\/span> Object<\/span>, e As<\/span> EventArgs) Handles<\/span> Me<\/span>.Load<\/p>\n

<\/span><\/p>\n

<\/span><\/span> <\/p>\n

        <\/span>Dim<\/span> ds As<\/span> New<\/span> System.Data.DataSet<\/p>\n

<\/span><\/p>\n

        <\/span>ds.ReadXml(Server.MapPath(“.\/downloads\/somedatafile.xml”<\/span>))<\/p>\n

<\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

<\/p>\n

        <\/font><\/span><\/span>‘error here<\/p>\n

<\/span><\/p>\n

<\/span><\/p>\n

        <\/span>Dim<\/span> query = From<\/span> row In<\/span> ds.Tables(0).AsEnumerable() Select<\/span> row <\/span><\/p>\n

<\/span><\/span> <\/p>\n

    <\/span>End<\/span> Sub<\/p>\n

<\/span><\/span><\/p>\n

<\/p>\n

 <\/p>\n

<\/span><\/p>\n

<\/<\/span>script<\/span>><\/p>\n

<\/span><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n

After staring at that for a while and thinking it was a bug in the compiler, I forwarded it on to some of the ADO guys.  <\/span>It turns out the fix is simple, change the import to say “System.Data” instead of “System.Data.DataSetExt\nensions”.  <\/span>If you open up Reflector the reason’s obvious: the AsEnumerable extension method is defined in the System.Data namespace<\/i> of the System.Data.DatasetExtensions assembly<\/i>.  <\/span>There is a System.Data.DatasetExtensions namespace as well, but it’s not the one that contains the extension methods.<\/font><\/font><\/p>\n

<\/font><\/font> <\/p>\n

I can see why they designed it this way, by putting it in System.Data you can use LINQ right out of the box on your existing Datasets, since typically System.Data is already imported.  Unfortunately that wasn’t the case here.<\/font><\/font><\/p>\n

\n

 <\/p>\n<\/p>\n

Here’s the right line of code to use:<\/p>\n

<\/font><\/font><\/p>\n

<%<\/span>@<\/span> Import<\/span> Namespace<\/span>=”System.Data”<\/span> %><\/p>\n

<\/span><\/span><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n

As an aside, you don’t actually have to insert the explicit call to AsEnumerable when working with LINQ to Dataset (in VB), I’ll explain why in a blog post tomorrow.<\/p>\n

<\/font><\/font><\/p>\n

\n

 <\/font><\/p>\n<\/p>\n

Jonathan<\/p>\n

<\/font><\/font><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

Recently I got a customer question about how to use LINQ to Dataset in an .aspx file.  The compiler was complaining that it couldn’t find the AsEnumerable method that allows LINQ to work over a DataTable (“AsEnumerable is not a member of ‘DataTable’”).  The code he sent looks correct, so why is the compiler not […]<\/p>\n","protected":false},"author":260,"featured_media":8818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[192,195],"tags":[67,83,94,117,166,178],"class_list":["post-4393","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured","category-visual-basic","tag-extension_methods","tag-jonathan-aneja","tag-linqvb9","tag-orcas","tag-vb2008","tag-web"],"acf":[],"blog_post_summary":"

Recently I got a customer question about how to use LINQ to Dataset in an .aspx file.  The compiler was complaining that it couldn’t find the AsEnumerable method that allows LINQ to work over a DataTable (“AsEnumerable is not a member of ‘DataTable’”).  The code he sent looks correct, so why is the compiler not […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/4393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/users\/260"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/comments?post=4393"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/4393\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media\/8818"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media?parent=4393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/categories?post=4393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/tags?post=4393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}