Language Integrated Query (LINQ)

<div dir="ltr" style="text-align: left;" trbidi="on"> <div style="text-align: justify;"> <span style="font-family: "arial" , sans-serif; font-size: 12pt;">LINQ is a type of query language. A query is a type of expression that retrieves data from a source. Different languages have been developed over time for the various types of data sources, for example SQL for relational databases and XQuery for XML.</span><br /> <span style="font-family: "arial" , sans-serif; font-size: 12pt;"><br /></span></div> <div style="text-align: justify;"> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8qKArAmHMo-nligQhHDfbjnEjbzvqQiGWL4Fa5lhuNTOWy1WzCBO40sxxhig8poQO8ZXVkNOqbh64CtsGhErtmugMQxwhYcsAEcj9GXesnGBk-B3PJawl9RZKs42gmpqPDhSUsjrcLRY/s1600/LINQ.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="linq" border="0" height="208" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8qKArAmHMo-nligQhHDfbjnEjbzvqQiGWL4Fa5lhuNTOWy1WzCBO40sxxhig8poQO8ZXVkNOqbh64CtsGhErtmugMQxwhYcsAEcj9GXesnGBk-B3PJawl9RZKs42gmpqPDhSUsjrcLRY/s320/LINQ.png" title="linq" width="320" /></a></div> <span style="font-family: "arial" , sans-serif; font-size: 12pt;"><br /></span> <span style="font-family: "arial" , sans-serif; font-size: 12pt;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: "arial" , sans-serif; font-size: 12pt;">LINQ is used in C# (which is a Desktop application development high level language) to retrieve data. It is almost similar to SQL (Structured Query Language), only little bit </span></div> <div style="text-align: justify;"> <span style="font-family: "arial" , sans-serif; font-size: 12pt;">difference in syntax. </span></div> <span style="font-family: "arial" , sans-serif; font-size: 12pt;"><br /></span> <br /> <div class="MsoNormal" style="line-height: normal; margin-bottom: 0.0001pt; text-align: justify;"> <span style="font-family: "arial" , sans-serif; font-size: 12.0pt; line-height: 107%;"><b>Example of LINQ</b></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in;"> <span style="font-family: "arial" , sans-serif; font-size: 12.0pt; line-height: 107%;"><b><br /></b></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;"> </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">class</span><span style="font-family: "courier new"; font-size: 10pt;"> IntroToLINQ<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">    {        <o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">        </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">static</span><span style="font-family: "courier new"; font-size: 10pt;"> </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">void</span><span style="font-family: "courier new"; font-size: 10pt;"> Main()<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">        {<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            </span><span style="color: green; font-family: "courier new"; font-size: 10.0pt;">// The Three Parts of a LINQ Query:</span><span style="font-family: "courier new"; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            </span><span style="color: green; font-family: "courier new"; font-size: 10.0pt;">//  1. Data source.</span><span style="font-family: "courier new"; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">int</span><span style="font-family: "courier new"; font-size: 10pt;">[] numbers = </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">new</span><span style="font-family: "courier new"; font-size: 10pt;"> </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">int</span><span style="font-family: "courier new"; font-size: 10pt;">[7] { 0, 1, 2, 3, 4, 5, 6 };<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <br /></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            </span><span style="color: green; font-family: "courier new"; font-size: 10.0pt;">// 2. Query creation.</span><span style="font-family: "courier new"; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            </span><span style="color: green; font-family: "courier new"; font-size: 10.0pt;">// numQuery is an IEnumerable<int></span><span style="font-family: "courier new"; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">var</span><span style="font-family: "courier new"; font-size: 10pt;"> numQuery =<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">                </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">from</span><span style="font-family: "courier new"; font-size: 10pt;"> num </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">in</span><span style="font-family: "courier new"; font-size: 10pt;"> numbers<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">                </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">where</span><span style="font-family: "courier new"; font-size: 10pt;"> (num % 2) == 0<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">                </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">select</span><span style="font-family: "courier new"; font-size: 10pt;"> num;<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <br /></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            </span><span style="color: green; font-family: "courier new"; font-size: 10.0pt;">// 3. Query execution.</span><span style="font-family: "courier new"; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">foreach</span><span style="font-family: "courier new"; font-size: 10pt;"> (</span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">int</span><span style="font-family: "courier new"; font-size: 10pt;"> num </span><span style="color: blue; font-family: "courier new"; font-size: 10.0pt;">in</span><span style="font-family: "courier new"; font-size: 10pt;"> numQuery)<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            {<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">                Console.Write(</span><span style="color: #a31515; font-family: "courier new"; font-size: 10.0pt;">"{0,1} "</span><span style="font-family: "courier new"; font-size: 10pt;">, num);<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">            }<o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <span style="font-family: "courier new"; font-size: 10pt;">        }<o:p></o:p></span></div> <br /> <div class="MsoNormal" style="line-height: normal; margin-bottom: .0001pt; margin-bottom: 0in; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt;"> <div style="text-align: justify;"> <span style="font-family: "courier new"; font-size: 10pt;">    }</span></div> <div style="text-align: justify;"> <span style="font-family: "courier new"; font-size: 10pt;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 10pt;">Here is the list of all functions provided in the downloadable file.</span></div> <div style="text-align: justify;"> <span style="font-family: "arial" , "helvetica" , sans-serif; font-size: 10pt;"><br /></span></div> </div> <div class="MsoNormal"> <table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: none; margin-left: 6.75pt; margin-right: 6.75pt; text-align: left; width: 728px;"> <tbody> <tr> <td style="border: solid #BBBBBB 1.0pt; mso-border-alt: solid #BBBBBB .75pt; padding: 7.5pt 7.5pt 7.5pt 7.5pt;" valign="top"><div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Restriction-Operators-b15d29ca" title="This sample shows different uses of Restriction Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Restriction Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Restriction-Operators-b15d29ca/description#WhereSimple1" target="_self" title="This sample uses where to find all elements of an array less than 5."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Where - Simple 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Restriction-Operators-b15d29ca/description#WhereSimple2" target="_self" title="This sample uses where to find all products that are out of stock."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Where - Simple 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Restriction-Operators-b15d29ca/description#WhereSimple3" target="_self" title="This sample uses where to find all products that are in stock and cost more than 3.00 per unit."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Where - Simple 3</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Restriction-Operators-b15d29ca/description#WhereDrilldown" target="_self" title="This sample uses where to find all customers in Washington and then uses the resulting sequence to drill down into their orders."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Where - Drilldown</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Restriction-Operators-b15d29ca/description#WhereIndexed" target="_self" title="This sample demonstrates an indexed Where clause that returns digits whose name is shorter than their value."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Where - Indexed</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825" title="This sample shows different uses of Projection Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Projection Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectSimple1" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Select - Simple 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectSimple2" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Select - Simple 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectTransformation" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Select - Transformation</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectAnonymousTypes1" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Select - Anonymous Types 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectAnonymousTypes2" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Select - Anonymous Types 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectAnonymousTypes3" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Select - Anonymous Types 3</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectIndexed" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Select - Indexed</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectFiltered" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Select - Filtered</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectManyCompoundfrom1" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">SelectMany - Compound from 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectManyCompoundfrom2" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">SelectMany - Compound from 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectManyCompoundfrom3" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">SelectMany - Compound from 3</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectManyfromAssignment" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">SelectMany - from Assignment</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectManyMultiplefrom" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">SelectMany - Multiple from</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l8 level1 lfo2; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-09787825/description#SelectManyIndexed" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">SelectMany - Indexed</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc" title="This sample shows different uses of Partitioning Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Partitioning Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l10 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc/description#TakeSimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Take - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l10 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc/description#TakeNested" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Take - Nested</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l10 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc/description#SkipSimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Skip - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l10 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc/description#SkipNested" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Skip - Nested</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l10 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc/description#TakeWhileSimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">TakeWhile - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l10 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc/description#TakeWhileIndexed" target="_self" title="New Link"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">TakeWhile - Indexed</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l10 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc/description#SkipWhileSimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">SkipWhile - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l10 level1 lfo3; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Partitioning-Operators-c68aaccc/description#SkipWhileIndexed" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">SkipWhile - Indexed</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e" title="This sample shows different uses of Ordering Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Ordering Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#OrderBySimple1" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">OrderBy - Simple 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#OrderBySimple2" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">OrderBy - Simple 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#OrderBySimple3" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">OrderBy - Simple 3</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#OrderBycomparer" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">OrderBy - Comparer</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#OrderByDescendingSimple1" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">OrderByDescending - Simple 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#OrderByDescendingSimple2" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">OrderByDescending - Simple 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#OrderByDescendingComparer" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">OrderByDescending - Comparer</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#thenBySimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">ThenBy - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#thenByComparer" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">ThenBy - Comparer</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#thenByDescendingSimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">ThenByDescending - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#ThenByDescendingComparer" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">ThenByDescending - Comparer</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l2 level1 lfo4; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/SQL-Ordering-Operators-050af19e/description#reverse" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Reverse</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> </td> <td style="border-left: none; border: solid #BBBBBB 1.0pt; mso-border-alt: solid #BBBBBB .75pt; mso-border-left-alt: solid #BBBBBB .75pt; padding: 7.5pt 7.5pt 7.5pt 7.5pt;" valign="top"><div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea" title="This sample shows different uses of Grouping Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Grouping Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l6 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea/description#Simple1" target="_self" title="This sample uses group by to partition a list of numbers by their remainder when divided by 5."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">GroupBy - Simple 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l6 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea/description#Simple2" target="_self" title="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">GroupBy - Simple 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l6 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea/description#Simple3" target="_self" title="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">GroupBy - Simple 3</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l6 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea/description#Nested" target="_self" title="This sample uses group by to partition a list of each customer's orders, first by year, and then by month."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">GroupBy - Nested</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l6 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea/description#Comparer" target="_self" title="This sample uses GroupBy to partition trimmed elements of an array using a custom comparer that matches words that are anagrams of each other."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">GroupBy - Comparer</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l6 level1 lfo5; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Grouping-c62703ea/description#ComparerMapped" target="_self" title="This sample uses GroupBy to partition trimmed elements of an array using a custom comparer that matches words that are anagrams of each other, and then converts the results to uppercase."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">GroupBy - Comparer, Mapped</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe" title="This sample shows different uses of Set Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Set Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l12 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe/description#distinct1" target="_self" title="This sample uses Distinct to remove duplicate elements in a sequence of factors of 300."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Distinct - 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l12 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe/description#distinct2" target="_self" title="This sample uses Distinct to find the unique Category names."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Distinct - 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l12 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe/description#union1" target="_self" title="This sample uses Union to create one sequence that contains the unique values from both arrays."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Union - 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l12 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe/description#union2" target="_self" title="This sample uses Union to create one sequence that contains the unique first letter from both product and customer names."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Union - 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l12 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe/description#intersect1" target="_self" title="This sample uses Intersect to create one sequence that contains the common values shared by both arrays."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Intersect - 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l12 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe/description#intersect2" target="_self" title="This sample uses Intersect to create one sequence that contains the common first letter from both product and customer names."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Intersect - 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l12 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe/description#except1" target="_self" title="This sample uses Except to create a sequence that contains the values from numbersAthat are not also in numbersB."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Except - 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l12 level1 lfo6; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Set-Operators-374f34fe/description#except2" target="_self" title="This sample uses Except to create one sequence that contains the first letters of product names that are not also first letters of customer names."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Except - 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Conversion-Operators-e4e59714" title="This sample shows different uses of Conversion Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Conversion Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l13 level1 lfo7; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Conversion-Operators-e4e59714/description#ToArray" target="_self" title="This sample uses ToArray to immediately evaluate a sequence into an array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">ToArray</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l13 level1 lfo7; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Conversion-Operators-e4e59714/description#ToList" target="_self" title="This sample uses ToList to immediately evaluate a sequence into a List<T>."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">ToList</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l13 level1 lfo7; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Conversion-Operators-e4e59714/description#ToDictionary" target="_self" title="This sample uses ToDictionary to immediately evaluate a sequence and a related key expression into a dictionary."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">ToDictionary</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l13 level1 lfo7; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Conversion-Operators-e4e59714/description#OfType" target="_self" title="This sample uses OfType to return only the elements of the array that are of type double."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">OfType</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Element-Operators-0f3f12ce" title="This sample shows different uses of Element Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Element Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l5 level1 lfo8; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Element-Operators-0f3f12ce/description#FirstSimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">First - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l5 level1 lfo8; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Element-Operators-0f3f12ce/description#FirstCondition" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">First - Condition</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l5 level1 lfo8; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Element-Operators-0f3f12ce/description#FirstOrDefaultSimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">FirstOrDefault - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l5 level1 lfo8; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Element-Operators-0f3f12ce/description#FirstOrDefaultCondition" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">FirstOrDefault - Condition</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l5 level1 lfo8; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Element-Operators-0f3f12ce/description#ElementAt" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">ElementAt</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Generation-Operators-8a3fbff7" title="This sample shows different uses of Generation Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Generation Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l3 level1 lfo9; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Generation-Operators-8a3fbff7/description#Range" target="_self" title="This sample uses Range to generate a sequence of numbers from 100 to 149 that is used to find which numbers in that range are odd and even."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Range</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l3 level1 lfo9; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Generation-Operators-8a3fbff7/description#Repeat" target="_self" title="This sample uses Repeat to generate a sequence that contains the number 7 ten times."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Repeat</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Quantifiers-f00e7e3e" title="This sample shows different uses of Quantifiers"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Quantifiers</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l4 level1 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Quantifiers-f00e7e3e/description#AnySimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Any - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l4 level1 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Quantifiers-f00e7e3e/description#AnyGrouped" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Any - Grouped</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l4 level1 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Quantifiers-f00e7e3e/description#AllSimple" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">All - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l4 level1 lfo10; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Quantifiers-f00e7e3e/description#AllGrouped" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">All - Grouped</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> </td> <td style="border-left: none; border: solid #BBBBBB 1.0pt; mso-border-alt: solid #BBBBBB .75pt; mso-border-left-alt: solid #BBBBBB .75pt; padding: 7.5pt 7.5pt 7.5pt 7.5pt; width: 181.0pt;" valign="top" width="241"><div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869" title="This sample shows different uses of Aggregate Operators "><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Aggregate Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#CountSimple" target="_self" title="This sample uses Count to get the number of unique factors of 300."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Count - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#CountConditional" target="_self" title="This sample uses Count to get the number of odd ints in the array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Count - Conditional</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#CountNested" target="_self" title="This sample uses Count to return a list of customers and how many orders each has."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Count - Nested</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#CountGrouped" target="_self" title="This sample uses Count to return a list of categories and how many products each has."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Count - Grouped</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#SumSimple" target="_self" title="This sample uses Sum to get the total of the numbers in an array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Sum - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#SumProjection" target="_self" title="This sample uses Sum to get the total number of characters of all words in the array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Sum - Projection</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#SumGrouped" target="_self" title="This sample uses Sum to get the total units in stock for each product category."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Sum - Grouped</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#MinSimple" target="_self" title="This sample uses Min to get the lowest number in an array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Min - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#MinProjection" target="_self" title="This sample uses Min to get the length of the shortest word in an array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Min - Projection</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#MinGrouped" target="_self" title="This sample uses Min to get the cheapest price among each category's products."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Min - Grouped</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#MinElements" target="_self" title="This sample uses Min to get the products with the cheapest price in each category."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Min - Elements</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#MaxSimple" target="_self" title="This sample uses Max to get the highest number in an array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Max - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#MaxProjection" target="_self" title="This sample uses Max to get the length of the longest word in an array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Max - Projection</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#MaxGrouped" target="_self" title="This sample uses Max to get the most expensive price among each category's products."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Max - Grouped</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#MaxElements" target="_self" title="This sample uses Max to get the products with the most expensive price in each category."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Max - Elements</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#AverageSimple" target="_self" title="This sample uses Average to get the average of all numbers in an array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Average - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#AverageProjection" target="_self" title="This sample uses Average to get the average length of the words in the array."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Average - Projection</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#AverageGrouped" target="_self" title="This sample uses Average to get the average price of each category's products."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Average - Grouped</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#AggregateSimple" target="_self" title="This sample uses Aggregate to create a running product on the array that calculates the total product of all elements."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Aggregate - Simple</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l14 level1 lfo11; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Aggregate-Operators-c51b3869/description#AggregateSeed" target="_self" title="This sample uses Aggregate to create a running account balance that subtracts each withdrawal from the initial balance of 100, as long as the balance never drops below 0."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Aggregate - Seed</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Miscellaneous-6b72bb2a" title="This sample shows different uses of Miscellaneous Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Miscellaneous Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l9 level1 lfo12; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Miscellaneous-6b72bb2a/description#Concat1" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Concat - 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l9 level1 lfo12; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Miscellaneous-6b72bb2a/description#Concat2" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Concat - 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l9 level1 lfo12; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Miscellaneous-6b72bb2a/description#EqualAll1" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">EqualAll - 1</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l9 level1 lfo12; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Miscellaneous-6b72bb2a/description#EqualAll2" target="_self"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">EqualAll - 2</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Custom-41738490" title="This sample shows different uses of Custom Sequence Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Custom Sequence Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l7 level1 lfo13; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-to-DataSets-Custom-41738490/description#Combine" target="_self" title="This sample calculates the dot product of two integer vectors."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Combine</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Query-Execution-ce0d3b95" title="This sample shows different uses of Query Execution"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Query Execution</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l1 level1 lfo14; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Query-Execution-ce0d3b95/description#DeferredExecution" target="_self" title="The following sample shows how query execution is deferred until the query is enumerated at a foreach statement."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Deferred Execution</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l1 level1 lfo14; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Query-Execution-ce0d3b95/description#ImmediateExecution" target="_self" title="The following sample shows how queries can be executed immediately with operators such as ToList()."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Immediate Execution</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l1 level1 lfo14; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Query-Execution-ce0d3b95/description#QueryReuse" target="_self" title="The following sample shows how, because of deferred execution, queries can be used again after data changes and will then operate on the new data."><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Query Reuse</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; mso-outline-level: 2;"> <a href="http://code.msdn.microsoft.com/LINQ-Join-Operators-dabef4e9" title="This sample shows different uses of Join Operators"><b><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 12pt;">Join Operators</span></b></a><b><span style="color: #3a3e43; font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></b></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l11 level1 lfo15; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Join-Operators-dabef4e9/description#crossjoin" target="_self" title="New Link"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Cross Join</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l11 level1 lfo15; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Join-Operators-dabef4e9/description#groupjoin" target="_self" title="New Link"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Group Join</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l11 level1 lfo15; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Join-Operators-dabef4e9/description#crossgroup" target="_self" title="New Link"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Cross Join with Group Join</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> <div class="MsoNormal" style="line-height: normal; margin-left: 30.0pt; mso-element-anchor-horizontal: page; mso-element-anchor-vertical: page; mso-element-frame-hspace: 9.0pt; mso-element-left: 12.05pt; mso-element-top: 4.55pt; mso-element-wrap: around; mso-element: frame; mso-height-rule: exactly; mso-list: l11 level1 lfo15; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; tab-stops: list .5in; text-indent: -.25in;"> <!--[if !supportLists]--><span style="font-family: "symbol"; font-size: 10pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">         </span></span><!--[endif]--><span dir="LTR"></span><a href="http://code.msdn.microsoft.com/LINQ-Join-Operators-dabef4e9/description#leftouterjoin" target="_self" title="New Link"><span style="color: #960bb4; font-family: "times new roman" , serif; font-size: 10pt;">Left Outer Join</span></a><span style="font-family: "times new roman" , serif; font-size: 10pt;"><o:p></o:p></span></div> </td> </tr> </tbody></table> <div style="text-align: justify;"> <span style="font-family: "arial" , sans-serif; font-size: 16px;"><br /></span></div> <div style="text-align: justify;"> <span style="font-family: "arial" , sans-serif; font-size: 16px;">If you want to know more about LINQ then you can download this file from here and check all the operations and the functions used in LINQ.</span></div> <div style="text-align: center;"> <span style="font-family: "arial" , sans-serif; font-size: 16px;"><br /></span></div> <div style="text-align: center;"> <span style="font-family: "arial" , sans-serif;"><b><span style="font-size: large;"><a href="https://drive.google.com/file/d/0B0zLWZC69TQaTVc5N1lqSVJmamM/view?usp=sharing">Click Here to Download</a></span></b></span></div> </div> </div>

Language Integrated Query (LINQ)

LINQ is a type of query language. A query is a type of expression that retrieves data from a source. Different languages have been develop...

Read more »