</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <div id="ProjectTitle">DataSource for Entity Framework in WPF</div> <div id="PageTitle"><div id="PageTitleText">Using ADO.NET Data Collections (LiveLinq to DataSet) </div></div> </div> <div id="AfterHeaderContent"> <!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel">Collapse All</label> <label id="ExpandAllLabel" style="display: none;">Expand All</label> </span> </div> <div class="BreadcrumbsContainer"><table><tr><td> <a href="ComponentOneLiveLinq.html">LiveLinq </a> > How to use LiveLinq > <a href="Howtoquerycollections.html">How to Query Collections with LiveLinq</a> > Using ADO.NET Data Collections (LiveLinq to DataSet) </td></tr></table></div> <div id="BodyContent"> <p style="MARGIN: 0.15in 0in 0.7pt; mso-style-name: 'Heading 4 Reference'">ADO.NET <b>DataTable</b> can also be used in LiveLinq, for example:</p> <p class="MsoBodyText"> </p> <div class="FilteredContent" data-title="" data-itemid=""> <table class="SyntaxTable"> <tbody> <tr> <th>C#</th> <th> <div class="CopyCodeWrapper"> <span class="CopyCode">Copy Code</span> </div> </th> </tr> <tr> <td colspan="2"> <pre> CustomersDataTable customers = ... <span style="COLOR: #0000ff">var</span> query = <span style="COLOR: #0000ff">from</span> c <span style="COLOR: #0000ff">in</span> customers.AsIndexed() <span style="COLOR: #0000ff">where</span> c.City == <span style="COLOR: #800000">"London"</span> <span style="COLOR: #0000ff">select</span> c; </pre> </td> </tr> </tbody> </table> </div> <p> </p> <p class="MsoBodyText"> For that, you’ll need to add the following to your source file:</p> <p class="MsoBodyText"> <div class="FilteredContent" data-title="" data-itemid=""> <table class="SyntaxTable"> <tbody> <tr> <th>C#</th> <th> <div class="CopyCodeWrapper"> <span class="CopyCode">Copy Code</span> </div> </th> </tr> <tr> <td colspan="2"> <pre> <span style="COLOR: #0000ff">using</span> C1.LiveLinq.AdoNet; </pre> </td> </tr> </tbody> </table> </div> <p> <p class="MsoBodyText"> The <b>AsIndexed()</b> used will be <span class="C1HKeywordLink">C1.LiveLinq.AdoNet.AdoNetExtensions.AsIndexed<span style="DISPLAY: none">|keyword=AsIndexed Method (DataTable)</span></span>. It is specifically optimized for data in ADO.NET DataSets.</p> <a name="seealsobookmark"></a> </div> <div id="FooterContent"> <p> </p><p> </p><hr style="height: 1px"><p>Copyright (c) <script type="text/javascript"> var theDate=new Date() document.write(theDate.getFullYear()) </script> GrapeCity, inc. All rights reserved. <script> $(document).ready(function() { if (!(window.self !== window.top)) { // Not running in a frameset // Get the page name var pageName = location.href.substring(location.href.lastIndexOf("/") + 1); if (pageName.indexOf("#") != -1) { pageName = pageName.substring(0, pageName.indexOf("#")); } // Append to webframe.html var framePage = "webframe.html#" + pageName; location.href = framePage; } }); </script></p> <a target="_blank" href="http://our.componentone.com/groups/">Product Support Forum</a> | <a target="_blank" href="http://feedback.componentone.com/forums/272000-wpf-and-silverlight-documentation">Documentation Feedback</a> </div> </body> </html>