{"id":4383,"date":"2008-05-14T19:52:00","date_gmt":"2008-05-14T19:52:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/vbteam\/2008\/05\/14\/how-linq-to-dataset-works-in-vb-jonathan-aneja\/"},"modified":"2024-07-05T14:25:17","modified_gmt":"2024-07-05T21:25:17","slug":"how-linq-to-dataset-works-in-vb-jonathan-aneja","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/vbteam\/how-linq-to-dataset-works-in-vb-jonathan-aneja\/","title":{"rendered":"How LINQ to Dataset works in VB (Jonathan Aneja)"},"content":{"rendered":"

LINQ at its core requires any data source to be queryable<\/i>, which basically means it must implement IEnumerable.  (It’s actually a bit more complicated than that, for a full explanation see section 11.21.2 of the<\/span> Visual Basic 9.0 Language Specification<\/a>).  <\/span>Now when working with LINQ to Dataset we have a problem: DataTable does not<\/i> implement IEnumerable, so how can we query over it?<\/span><\/p>\n

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

<\/p>\n

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

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

As we saw <\/font>yesterday<\/font><\/a>, Visual Studio 2008 includes an assembly called System.Data.DataSetExtensions.dll, which defines an <\/font>extension method<\/font><\/a> called AsEnumerable().  Here’s what this method looks like:<\/p>\n

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

    <Extension()> _<\/p>\n

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

    Public<\/span> Function<\/span> AsEnumerable(source As<\/span> DataTable) As<\/span> EnumerableRowCollection(Of<\/span> DataRow)<\/p>\n

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

<\/p>\n

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

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

Basically this takes in a DataTable and sends back something that implements IEnumerable(Of T), which LINQ can then consume using the standard query operators.  So all you have to do is import System.Data (which is done by default in the project templates) and then you can use LINQ against a Dataset by calling AsEnumerable().  <\/p>\n

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

<\/p>\n

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

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

    Dim<\/span> customers = TestDS.Tables(“Customers”<\/span>)<\/p>\n

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

<\/p>\n

 <\/p>\n

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

    Dim<\/span> franceCustomers = From<\/span> cust In<\/span> customers.AsEnumerable() _<\/p>\n

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

                          Where<\/span> cust!Country = “France”<\/span> _<\/p>\n

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

                          Select<\/span> cust<\/span><\/p>\n

<\/p>\n

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

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

Now one of the interesting things about the way LINQ works in VB is you don’t actually have to call AsEnumerable() explicitly for the code above to compile.  Even though DataTable does not implement IEnumerable, the compiler helps out here by looking for methods that can turn it into something queryable.  When the VB compiler encounters a LINQ query over a type that does not implement IEnumerable, IEnumerable(Of T), IQueryable, or IQueryable(Of T) it then does the following, in order:<\/p>\n

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

1.<\/font>       <\/span><\/span><\/span>See if there is a conforming Select method available on the type.<\/p>\n

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

2.<\/font>       <\/span><\/span><\/span>See if the type has an instance method named AsQueryable which returns a type that is queryable.  <\/p>\n

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

3.<\/font>       <\/span><\/span><\/span>See if the type has an extension method in scope named AsQueryable which returns a type that is queryable.  <\/p>\n

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

4.<\/font>       <\/span><\/span><\/span>See if the type has an instance method named AsEnumerable which returns a type that is queryable.  <\/p>\n

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

5.<\/font>       <\/span><\/span><\/span>See if the type has an extension method in scope named AsEnumerable which returns a type that is queryable.<\/p>\n

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

<\/p>\n

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

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

If at any point the compiler finds a method that matches, it inserts a call to it.  When the System.Data namespace i<\/span>s imported, the compiler finds a match for DataTable on step 5,<\/span> and inserts the call to AsEnumerable for you.  As a result you can write LINQ to Dataset code like this example from the <\/font><\/font>101 LINQ Samples<\/font><\/a>:<\/p>\n

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

\n

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

        Dim<\/span> customers = TestDS.Tables(“Customers”<\/span>)<\/p>\n

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

<\/p>\n

 <\/p>\n

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

        Dim<\/span> franceCustomers = From<\/span> cust In<\/span> customers _<\/p>\n

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

                              Where<\/span> cust!Country = “France”<\/span> _<\/p>\n

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

                              Select<\/span> cust<\/p>\n

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

<\/p>\n

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

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

What this means is that you can LINQ-enable your types by providing an AsEnumerable extension method that returns something that is queryable.<\/p>\n

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

<\/p>\n

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

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

Note that for strongly-typed Datasets you don’t need to call AsEnumerable, as they inherit from TypedTableBase(Of T) which implements IEnumerable.  <\/span>This is a new type in VS2008; in VS2005 the Dataset Designer would generate code that inherited from DataTable and then explicitly implemented IEnumerable itself.<\/p>\n

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

LINQ at its core requires any data source to be queryable, which basically means it must implement IEnumerable.  (It’s actually a bit more complicated than that, for a full explanation see section 11.21.2 of the Visual Basic 9.0 Language Specification).  Now when working with LINQ to Dataset we have a problem: DataTable does not implement […]<\/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":[53,67,83,94,117,165,166],"class_list":["post-4383","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured","category-visual-basic","tag-data_design","tag-extension_methods","tag-jonathan-aneja","tag-linqvb9","tag-orcas","tag-vb2005","tag-vb2008"],"acf":[],"blog_post_summary":"

LINQ at its core requires any data source to be queryable, which basically means it must implement IEnumerable.  (It’s actually a bit more complicated than that, for a full explanation see section 11.21.2 of the Visual Basic 9.0 Language Specification).  Now when working with LINQ to Dataset we have a problem: DataTable does not implement […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/4383","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=4383"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/4383\/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=4383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/categories?post=4383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/tags?post=4383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}