<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>The Visual Basic Team : Amanda Silver</title><link>http://blogs.msdn.com/vbteam/archive/category/4743.aspx</link><description /><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>VSLive San Francisco Content (Amanda Silver)</title><link>http://blogs.msdn.com/vbteam/archive/2008/03/31/vslive-san-francisco-content-amanda-silver.aspx</link><pubDate>Tue, 01 Apr 2008 00:19:26 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8346547</guid><dc:creator>VBTeam</dc:creator><slash:comments>7</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/8346547.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=8346547</wfw:commentRss><description>&lt;p&gt;All - I'm about to go on for my LINQ Deep Dive and Tips &amp;amp;Tricks session at VSLive in San Francisco. I posted all demos &amp;amp; slides here:&lt;/p&gt;  &lt;p&gt;&lt;a title="https://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=LaunchVB&amp;amp;ReleaseId=805" href="https://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=LaunchVB&amp;amp;ReleaseId=805"&gt;https://code.msdn.microsoft.com/Release/ProjectReleases.aspx?ProjectName=LaunchVB&amp;amp;ReleaseId=805&lt;/a&gt;&lt;/p&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=8346547" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/IDE/default.aspx">IDE</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB2008/default.aspx">VB2008</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/IQueryable/default.aspx">IQueryable</category></item><item><title>Awesome VB9 Blog Series by Bart De Smet (Amanda Silver)</title><link>http://blogs.msdn.com/vbteam/archive/2007/11/21/awesome-vb9-blog-series-by-bart-de-smet-amanda-silver.aspx</link><pubDate>Wed, 21 Nov 2007 13:48:42 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:6453446</guid><dc:creator>VBTeam</dc:creator><slash:comments>0</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/6453446.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=6453446</wfw:commentRss><description>&lt;p&gt;I guess I've been working too hard on getting the product ready to &lt;a href="http://blogs.msdn.com/vbteam/archive/2007/11/19/visual-basic-2008-ships.aspx"&gt;ship&lt;/a&gt; to notice that &lt;a href="http://community.bartdesmet.net/blogs/bart/"&gt;Bart&lt;/a&gt; has put together an &lt;a href="http://community.bartdesmet.net/blogs/bart/archive/tags/VB+9.0/default.aspx"&gt;awesome blog series on VB9&lt;/a&gt;. &lt;/p&gt;  &lt;p&gt;It includes discussion of a feature called &lt;a href="http://community.bartdesmet.net/blogs/bart/archive/2007/09/03/visual-basic-9-0-feature-focus-runtime-agility.aspx"&gt;runtime agility&lt;/a&gt; or &lt;a href="http://research.microsoft.com/~emeijer/Papers/VisualBasic9OOPSLA2007.pdf"&gt;compiler agility&lt;/a&gt; that we haven't taken up on this blog. We introduced this feature to make it much easier for new .NET platforms (think Silverlight, XNA, &amp;amp; .NET Micro Frameworks) to allow Visual Basic&amp;#160; programmers to target their platform. For those of you language/compiler wonks or VB zen masters -- this is a good feature to learn about as it gives you insight into the dependencies the Visual Basic compiler has on the Microsoft.VisualBasic.dll aka VBRuntime. For the mavericks, Bart talks about compiling his own version of the VB runtime that contains just the features he wants (CompareString). But this feature is designed to be a transparent implementation detail of the Visual Basic &lt;em&gt;tool&lt;/em&gt; for those of you that are just interested in getting your job done. Enjoy!&lt;/p&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=6453446" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB2008/default.aspx">VB2008</category></item><item><title>Hidden Gems in Visual Basic 2008 (Amanda Silver)</title><link>http://blogs.msdn.com/vbteam/archive/2007/11/20/hidden-gems-in-visual-basic-2008-amanda-silver.aspx</link><pubDate>Wed, 21 Nov 2007 09:24:16 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:6450618</guid><dc:creator>VBTeam</dc:creator><slash:comments>18</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/6450618.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=6450618</wfw:commentRss><description>&lt;p&gt;Yesterday I &lt;a href="http://blogs.msdn.com/vbteam/archive/2007/11/19/visual-basic-2008-ships.aspx"&gt;promised to post&lt;/a&gt; about the hidden gems in Visual Basic and Visual Studio 2008 that you haven&amp;#8217;t read about in blog posts or seen at conferences. I forgot that I mentioned a few of my favorite features in the &lt;a href="http://blogs.msdn.com/vbteam/archive/2007/04/19/visual-basic-orcas-beta1-is-in-the-wild.aspx"&gt;Beta1 announcement&lt;/a&gt; where I showed off the improvements in the Intellisense experience &amp;#8211; statement completion for keywords, local variables, and expressions. In that post, I also cover a new language feature called Relaxed Delegates which allows you to provide alternate signatures for events. Both of those are pretty great features &amp;#8211; but I promised to tell you about some &lt;i&gt;new &lt;/i&gt;stuff.&lt;/p&gt;  &lt;p&gt;I polled the team and we came up with the following top ten that weren&amp;#8217;t mentioned in my previous post. There&amp;#8217;s so much I &lt;i&gt;could &lt;/i&gt;talk about &amp;#8211; but you&amp;#8217;re going to have to check back. But first, I have to start with a keynote feature&amp;#8230; &lt;/p&gt;  &lt;h5&gt;&lt;b&gt;0) &lt;/b&gt;&lt;b&gt;Multi-targetting&lt;/b&gt;&lt;/h5&gt;  &lt;p&gt;In short, multi-targetting allows you to use Visual Studio 2008 (and VB 9!) to target the .NET 2.0 frameworks. All of the following features I&amp;#8217;ll show you can be leveraged even if you&amp;#8217;re targeting .NET 2.0! (With the exception of items #5 &amp;amp; #7 as they depend on the LINQ to Objects and LINQ to XML APIs which reside in .NET 3.5) To do this, when you start up Visual Studio and create a new project, just make sure that the target framework is set to .NET Framework 2.0. &lt;/p&gt;  &lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image002_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="161" alt="clip_image002" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image002_thumb.jpg" width="628" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;  &lt;p&gt;Note that projects you&amp;#8217;re upgrading, will automatically target .NET Framework 2.0 until you add references to .NET 3.0 or 3.5 assemblies. &lt;/p&gt;  &lt;h5&gt;&lt;b&gt;1) &lt;/b&gt;&lt;b&gt;Type Inference&lt;/b&gt;&lt;/h5&gt;  &lt;p&gt;In Visual Basic 9, in the following bit of code and NOTHING is late-bound &amp;#8211; everything is bound at compile-time which means you get Intellisense and type checking.&lt;/p&gt;  &lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; dialog = &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; OpenFileDialog()
        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; result = dialog.ShowDialog()
        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; printStr = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;C:\&amp;quot;
&lt;/span&gt;        &lt;span style="color: rgb(0,0,255)"&gt;If&lt;/span&gt; result = Windows.Forms.DialogResult.OK &lt;span style="color: rgb(0,0,255)"&gt;Then
&lt;/span&gt;            printStr = dialog.FileName
        &lt;span style="color: rgb(0,0,255)"&gt;End&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;If
&lt;/span&gt;        MsgBox(printStr)&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p&gt;&lt;/p&gt;

&lt;p&gt;This makes prototyping very quick, easy, and type-safe! This feature and the mechanisms that control it are comprehensively covered in &lt;a href="http://msdn.microsoft.com/msdnmag/issues/07/10/BasicInstincts/default.aspx"&gt;this article by a member of our QA team, Bill Horst&lt;/a&gt;. &lt;/p&gt;

&lt;h5&gt;&lt;b&gt;2) &lt;/b&gt;&lt;b&gt;If Operator&lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;Ever notice that the IIF function returns something of type Object? This means that you don&amp;#8217;t get Intellisense or type-checking by default on that result. For those of you that &lt;i&gt;insist&lt;/i&gt; on type-safe, early-bound code, you have to &lt;i&gt;cast&lt;/i&gt; the result. The code then looks something like this:&lt;/p&gt;

&lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; intC &lt;span style="color: rgb(0,0,255)"&gt;As&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;Integer&lt;/span&gt; = &lt;span style="color: rgb(0,0,255)"&gt;CInt&lt;/span&gt;(IIf(intA = intB, intA, intB - 1))&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p&gt;With the If operator, you can now write that line as:&lt;/p&gt;

&lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; intD &lt;span style="color: rgb(0,0,255)"&gt;As&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;Integer&lt;/span&gt; = &lt;span style="color: rgb(0,0,255)"&gt;If&lt;/span&gt;(intA = intB, intA, intB)&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p&gt;And with type inference it gets even easier on the eyes:&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image004_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; margin: 0px 0px 0px 55px; border-left: 0px; border-bottom: 0px" height="61" alt="clip_image004" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image004_thumb.jpg" width="315" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;I'm a fan of any feature that improves readability. &lt;/p&gt;

&lt;h5&gt;&lt;b&gt;3) &lt;/b&gt;&lt;b&gt;Object Initializers&lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;Generally, in the .NET frameworks, we try to design APIs that use the &lt;a href="http://www.cs.cmu.edu/~NatProg/papers/Stylos2007CreateSetCall.pdf"&gt;create-set-call pattern&lt;/a&gt; as our usability studies have indicated they are the easiest to use by the average programmer. Nevertheless, objects that don&amp;#8217;t have a parameterless constructor exist in the .NET framework. When that happens, it&amp;#8217;s really nice to be able to leverage Object Initializers which are kind of like a Dim and a With statement combined into an expression. That makes parameterized constructors somewhat easier to tolerate:&lt;/p&gt;

&lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; strm &lt;span style="color: rgb(0,0,255)"&gt;As&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; StreamWriter( _
                      &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; FileStream(&lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;C:\out.txt&amp;quot;&lt;/span&gt;, FileMode.OpenOrCreate) _
                        &lt;span style="color: rgb(0,0,255)"&gt;With&lt;/span&gt; {.Position = 10})&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p&gt;It also makes creating arrays of objects much easier. &lt;/p&gt;

&lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; Capitals() &lt;span style="color: rgb(0,0,255)"&gt;As&lt;/span&gt; City = {&lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; City &lt;span style="color: rgb(0,0,255)"&gt;With&lt;/span&gt; {.Name = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;Antanarivo&amp;quot;&lt;/span&gt;, .Country = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;Madagascar&amp;quot;&lt;/span&gt;}, _
          &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; City &lt;span style="color: rgb(0,0,255)"&gt;With&lt;/span&gt; {.Name = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;Belmopan&amp;quot;&lt;/span&gt;, .Country = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;Belize&amp;quot;&lt;/span&gt;}, _
          &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; City &lt;span style="color: rgb(0,0,255)"&gt;With&lt;/span&gt; {.Name = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;Monaco&amp;quot;&lt;/span&gt;, .Country = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;Monaco&amp;quot;&lt;/span&gt;}, _
          &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; City &lt;span style="color: rgb(0,0,255)"&gt;With&lt;/span&gt; {.Country = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;Palau&amp;quot;&lt;/span&gt;, .Name = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;Koror&amp;quot;&lt;/span&gt;}}&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p&gt;&lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;/b&gt;&lt;/p&gt;

&lt;h5&gt;&lt;b&gt;4) &lt;/b&gt;&lt;b&gt;Nullable &lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;Nullable is the feature you&amp;#8217;ll notice but rarely have to think about. It&amp;#8217;s basically the .NET representation for a Nullable &lt;a href="http://msdn2.microsoft.com/en-us/library/y23b5415(vs.71).aspx"&gt;value type&lt;/a&gt; (Integer, Date, etc.) Using the designer for LINQ to SQL, the Object-Relational Mapping layer introduced in Visual Studio 2008, nullable columns in your database are mapped to this type. The result is that you can write the following expression in VB and the &lt;i&gt;right thing happens &amp;#8211; &lt;/i&gt;null valued rows propagate null. In the example below, the Independence property on the Country type is a nullable date, denoted as &lt;span style="color: rgb(0,0,255)"&gt;Date&lt;/span&gt;?&lt;/p&gt;
&lt;a href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; virginIslands &lt;span style="color: rgb(0,0,255)"&gt;As&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; Country &lt;span style="color: rgb(0,0,255)"&gt;With&lt;/span&gt; {.Independence = &lt;span style="color: rgb(0,0,255)"&gt;Nothing&lt;/span&gt;}
        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; palau &lt;span style="color: rgb(0,0,255)"&gt;As&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; Country &lt;span style="color: rgb(0,0,255)"&gt;With&lt;/span&gt; {.Independence = #10/1/1994#}

        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; vILength = #8/24/2005# - virginIslands.Independence &lt;span style="color: rgb(0,128,0)"&gt;' Nothing
&lt;/span&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; pLength = #8/24/2005# - palau.Independence &lt;span style="color: rgb(0,128,0)"&gt;' 3980.00:00:00&lt;/span&gt;&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p&gt;&lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;/b&gt;&lt;/p&gt;

&lt;h5&gt;&lt;b&gt;5) &lt;/b&gt;&lt;b&gt;LINQ to DataSet &lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;I love this feature because it means never having to say you&amp;#8217;re sorry&amp;#8230; No, really, it means that you don&amp;#8217;t need to migrate to a new data access technology to reap the benefits of LINQ. I fill my DataSet just as before, and then I can query against the DataSet:&lt;/p&gt;

&lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Me&lt;/span&gt;.EmployeesTableAdapter.Fill(&lt;span style="color: rgb(0,0,255)"&gt;Me&lt;/span&gt;.NORTHWNDDataSet.Employees)
        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; query = &lt;span style="color: rgb(0,0,255)"&gt;From&lt;/span&gt; emp &lt;span style="color: rgb(0,0,255)"&gt;In&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;Me&lt;/span&gt;.NORTHWNDDataSet.Employees _
                    &lt;span style="color: rgb(0,0,255)"&gt;Where&lt;/span&gt; emp.Country = &lt;span style="color: rgb(163,21,21)"&gt;&amp;quot;USA&amp;quot;&lt;/span&gt; _
                    &lt;span style="color: rgb(0,0,255)"&gt;Order&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;By&lt;/span&gt; emp.HireDate _
                    &lt;span style="color: rgb(0,0,255)"&gt;Select&lt;/span&gt; emp
        &lt;span style="color: rgb(0,0,255)"&gt;Me&lt;/span&gt;.EmployeesBindingSource.DataSource = query&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p&gt;&lt;b&gt;&lt;/b&gt;&lt;/p&gt;

&lt;h5&gt;&lt;b&gt;6) &lt;/b&gt;&lt;b&gt;Syntax Tooltips&lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;How cool is this?&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image006_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="200" alt="clip_image006" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image006_thumb.jpg" width="382" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;How about this?&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image008_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="100" alt="clip_image008" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image008_thumb.jpg" width="319" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;What do you think of this?&lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image010_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="82" alt="clip_image010" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image010_thumb.jpg" width="450" border="0" /&gt;&lt;/a&gt;&lt;/b&gt;&lt;b&gt;&lt;/b&gt;&lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;/b&gt;&lt;/p&gt;

&lt;h5&gt;&lt;b&gt;7) &lt;/b&gt;&lt;b&gt;XML Namespace support in Intellisense&lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;We&amp;#8217;ve &lt;a href="http://blogs.msdn.com/vbteam/archive/2007/06/06/visual-basic-xml-transform-teched-demo-prep.aspx"&gt;blogged&lt;/a&gt; about &lt;a href="http://msdn2.microsoft.com/en-us/library/bb531325(VS.90).aspx"&gt;XML Intellisense&lt;/a&gt; before. But there&amp;#8217;s a tidbit we&amp;#8217;ve overlooked. &lt;/p&gt;

&lt;p&gt;When namespaces are used in the XML document you&amp;#8217;re reading from, the Intellisense engine matches the namespace prefix and the local name. This little productivity boost can yield a significant savings in keystrokes. Instead of typing the prefix then the colon and then the local name, you just type a little bit of the local name and hit enter. Here is a small example of how it works, starting with an input document and the applicable intellisense:&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image012_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="259" alt="clip_image012" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image012_thumb.jpg" width="534" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;If we just type the letter &amp;#8220;t&amp;#8221; the &amp;#8220;tomato&amp;#8221; entry will be selected:&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image014_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="61" alt="clip_image014" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image014_thumb.jpg" width="363" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;If we type the letter &amp;#8220;e&amp;#8221; the &amp;#8220;exa:eggplant&amp;#8221; will be selected and the completion list will &lt;i&gt;also&lt;/i&gt; contain the prefix &amp;#8220;exa&amp;#8221; and the &amp;#8220;elephant&amp;#8221; entry:&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image016_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="96" alt="clip_image016" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image016_thumb.jpg" width="373" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt; The next character that will be typed will determine which single entry will get selected. Now, how easy was that?&lt;/p&gt;

&lt;h5&gt;&lt;/h5&gt;

&lt;h5&gt;&lt;b&gt;8) &lt;/b&gt;&lt;b&gt;GoTo Type Definition&lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;Often, when you define a variable, you want to view the type definition in code or in the Object Browser. There&amp;#8217;s a new option in the context menu which allows you to go directly to the type definition instead of just the variable declaration. This is great when combined with type inference as it allows you confirm that the type of the variable is actually what you believe it to be. &lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image018_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="172" alt="clip_image018" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image018_thumb.jpg" width="381" border="0" /&gt;&lt;/a&gt;&lt;/b&gt; &lt;b&gt;&lt;/b&gt;&lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;/b&gt;&lt;/p&gt;

&lt;h5&gt;&lt;b&gt;9) &lt;/b&gt;&lt;b&gt;Type inference for loop variables&lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;Check out the following code:&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image020_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="112" alt="clip_image020" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image020_thumb.jpg" width="482" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;And this code:&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image022_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="117" alt="clip_image022" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image022_thumb.jpg" width="346" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;Without having to specify the type of the control variable, it&amp;#8217;s inferred from right-hand-side expression or the collection we&amp;#8217;re iterating over. &lt;/p&gt;

&lt;h5&gt;&lt;b&gt;10) &lt;/b&gt;&lt;b&gt;Performance improvements and&amp;#8230; Non-blocking operations!&lt;/b&gt;&lt;/h5&gt;

&lt;p&gt;The background compiler is an &lt;i&gt;awesome&lt;/i&gt; feature that gives you immediate feedback on the correctness of the code you write. We&amp;#8217;ve made some &lt;i&gt;&lt;a href="http://channel9.msdn.com/ShowPost.aspx?PostID=328382#328382"&gt;tremendous&lt;/a&gt;&lt;/i&gt; strides in the performance of the background compiler in this release. We believe that the background compiler is 3 times faster uses 3 times less memory. Anyone who has migrated their project to 2008 should notice an improvement after a couple minutes of use.&lt;/p&gt;

&lt;p&gt;While we&amp;#8217;ve made huge improvements on the throughput, certain operations like changing the declaration of a base class that&amp;#8217;s used many times in a large project is computationally expensive. If you attempted to invoke a feature that relied on compiled information before the background compiler has a chance to do its magic, like Intellisense or the Drop Downs, previous versions of Visual Studio would grind to a halt until the compilation was complete. Those operations are no-longer blocking. So, while you might occasionally get the drop downs to look like this:&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image024_2.jpg"&gt;&lt;img style="border-right: 0px; border-top: 0px; border-left: 0px; border-bottom: 0px" height="45" alt="clip_image024" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/HiddenGemsinVisualBasic2008AmandaSilver_138CC/clip_image024_thumb.jpg" width="268" border="0" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;The IDE will still be responsive. &lt;b&gt;&lt;/b&gt;&lt;/p&gt;

&lt;p&gt;Now do you have to &lt;a href="http://msdn2.microsoft.com/en-us/vstudio/products/aa700831.aspx"&gt;download it&lt;/a&gt;? Remember, you can always grab the &lt;a href="http://www.microsoft.com/express/"&gt;Express&lt;/a&gt; Edition!&lt;/p&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=6450618" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/IDE/default.aspx">IDE</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB_5F00_Express/default.aspx">VB_Express</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB2008/default.aspx">VB2008</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/IQueryable/default.aspx">IQueryable</category></item><item><title>Visual Basic 2008 Ships!!! (Amanda Silver)</title><link>http://blogs.msdn.com/vbteam/archive/2007/11/19/visual-basic-2008-ships.aspx</link><pubDate>Mon, 19 Nov 2007 20:27:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:6405290</guid><dc:creator>VBTeam</dc:creator><slash:comments>9</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/6405290.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=6405290</wfw:commentRss><description>&lt;p&gt;Hooray! Today we&amp;#8217;ve finally &lt;i&gt;shipped &lt;/i&gt;Visual Studio 2008, previously known as &amp;#8220;Orcas&amp;#8221;, previously known as some symbol which doesn&amp;#8217;t have an ascii representation. We&amp;#8217;ve &lt;a href="http://www.idealliance.org/proceedings/xml05/ship/247/VisualBasic9.PDF" mce_href="http://www.idealliance.org/proceedings/xml05/ship/247/VisualBasic9.PDF"&gt;come a long way&lt;/a&gt;, but it&amp;#8217;s been a great ride. In his &lt;a href="http://blogs.msdn.com/somasegar/archive/2007/11/19/visual-studio-2008-and-net-framework-3-5-shipped.aspx" mce_href="http://blogs.msdn.com/somasegar/archive/2007/11/19/visual-studio-2008-and-net-framework-3-5-shipped.aspx"&gt;blog&lt;/a&gt;, Soma mentions many of the flagship features at a high-level that will undoubtedly make the every developer and head of IT salivate, but this blog is about Visual Basic. :)&lt;/p&gt;  &lt;p&gt;This is a &lt;b&gt;&lt;i&gt;tremendous&lt;/i&gt;&lt;/b&gt; release for Visual Basic users everywhere as it&amp;#8217;s the first to introduce query expressions and XML as a first class data-type. Not only does this make Visual Basic the most productive choice for programming data-centric applications, it also makes us VB developers the &lt;i&gt;envy&lt;/i&gt; of many an &lt;a href="http://www.pluralsight.com/blogs/dbox/" mce_href="http://www.pluralsight.com/blogs/dbox/"&gt;alpha-geek&lt;/a&gt;. If you'd like to just try it out -- be sure to check out &lt;a href="http://www.microsoft.com/express/"&gt;Visual Basic Express&lt;/a&gt; which comes with all the features I talk about below.&lt;/p&gt;  &lt;p&gt;With query the entire .NET frameworks become a queryable data source. You can now query against anything available in the .NET Frameworks &amp;#8211; the registry, file system, live processes, etc. For example, the code below queries against the running processes and returns those with a thread count greater than 10, orders them by the thread count:&lt;/p&gt;  &lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; query = &lt;span style="color: rgb(0,0,255)"&gt;From&lt;/span&gt; proc &lt;span style="color: rgb(0,0,255)"&gt;In&lt;/span&gt; Process.GetProcesses _
            &lt;span style="color: rgb(0,0,255)"&gt;Let&lt;/span&gt; ThreadCount = proc.Threads.Count _
            &lt;span style="color: rgb(0,0,255)"&gt;Where&lt;/span&gt; ThreadCount &amp;gt; 10 _
            &lt;span style="color: rgb(0,0,255)"&gt;Order&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;By&lt;/span&gt; ThreadCount _
            &lt;span style="color: rgb(0,0,255)"&gt;Select&lt;/span&gt; proc.ProcessName, proc.Id, ThreadCount&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste" mce_href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p align="left"&gt;Using the LINQ to SQL Object-Relational Mapping framework, you can query against a SQL database as though it was just another collection of objects exposed by the frameworks. The following query finds all the products that have been discontinued, groups them into categories, and finds the total number of units in stock for each category:&lt;/p&gt;

&lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; db &lt;span style="color: rgb(0,0,255)"&gt;As&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;New&lt;/span&gt; NorthwindDataContext(&lt;span style="color: rgb(0,0,255)"&gt;My&lt;/span&gt;.Settings.NORTHWNDConnectionString)
        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; query = &lt;span style="color: rgb(0,0,255)"&gt;From&lt;/span&gt; prod &lt;span style="color: rgb(0,0,255)"&gt;In&lt;/span&gt; db.Products _
                    &lt;span style="color: rgb(0,0,255)"&gt;Where&lt;/span&gt; prod.Discontinued = &lt;span style="color: rgb(0,0,255)"&gt;True&lt;/span&gt; _
                    &lt;span style="color: rgb(0,0,255)"&gt;Group&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;By&lt;/span&gt; prod.CategoryID _
                    &lt;span style="color: rgb(0,0,255)"&gt;Into&lt;/span&gt; Count(), NumInStock = Sum(prod.UnitsInStock) _
                    &lt;span style="color: rgb(0,0,255)"&gt;Join&lt;/span&gt; cat &lt;span style="color: rgb(0,0,255)"&gt;In&lt;/span&gt; db.Categories &lt;span style="color: rgb(0,0,255)"&gt;On&lt;/span&gt; cat.CategoryID &lt;span style="color: rgb(0,0,255)"&gt;Equals&lt;/span&gt; CategoryID _
                    &lt;span style="color: rgb(0,0,255)"&gt;Select&lt;/span&gt; cat.CategoryName, Count, NumInStock&lt;/pre&gt;

&lt;p&gt;Unlike writing huge SQL query strings, I get immediate feedback on the query I write. &lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;i&gt;Intellisense&lt;/i&gt;&lt;/b&gt;:&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image002_2.jpg" mce_href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image002_2.jpg"&gt;&lt;img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="245" alt="clip_image002" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image002_thumb.jpg" width="616" border="0" mce_src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image002_thumb.jpg" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;i&gt;Syntax checking:&lt;/i&gt;&lt;/b&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image004_2.jpg" mce_href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image004_2.jpg"&gt;&lt;img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="78" alt="clip_image004" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image004_thumb.jpg" width="628" border="0" mce_src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image004_thumb.jpg" /&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;i&gt;Schema checking:&lt;/i&gt;&lt;/b&gt;&lt;/p&gt;

&lt;p&gt;&lt;b&gt;&lt;i&gt;&lt;a href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image006_2.jpg" mce_href="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image006_2.jpg"&gt;&lt;img style="border-top-width: 0px; border-left-width: 0px; border-bottom-width: 0px; border-right-width: 0px" height="136" alt="clip_image006" src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image006_thumb.jpg" width="611" border="0" mce_src="http://blogs.msdn.com/blogfiles/vbteam/WindowsLiveWriter/VisualBasic2008Ships_84BD/clip_image006_thumb.jpg" /&gt;&lt;/a&gt;&lt;/i&gt;&lt;/b&gt;&lt;/p&gt;

&lt;p&gt;I can use the same query language (VB!) to query against relational databases, XML, and collections of objects &amp;#8211; I don&amp;#8217;t need to learn any domain specific language, VB gives me access to all! It&amp;#8217;s really easy for me to join across domains (I&amp;#8217;ll take that up in a later blog post.) &lt;/p&gt;

&lt;p&gt;With XML as a first class data-type, &lt;a href="http://blogs.msdn.com/vbteam/archive/2007/06/06/visual-basic-xml-transform-teched-demo-prep.aspx" mce_href="http://blogs.msdn.com/vbteam/archive/2007/06/06/visual-basic-xml-transform-teched-demo-prep.aspx"&gt;Visual Basic becomes a full XML transform language&lt;/a&gt;. But it&amp;#8217;s also really easy for me to project to XML from my SQL database:&lt;/p&gt;

&lt;pre class="code"&gt;        &lt;span style="color: rgb(0,0,255)"&gt;Dim&lt;/span&gt; query = &lt;span style="color: rgb(0,0,255)"&gt;From&lt;/span&gt; prod &lt;span style="color: rgb(0,0,255)"&gt;In&lt;/span&gt; db.Products _
            &lt;span style="color: rgb(0,0,255)"&gt;Where&lt;/span&gt; prod.Discontinued = &lt;span style="color: rgb(0,0,255)"&gt;True&lt;/span&gt; _
            &lt;span style="color: rgb(0,0,255)"&gt;Group&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;By&lt;/span&gt; prod.CategoryID _
            &lt;span style="color: rgb(0,0,255)"&gt;Into&lt;/span&gt; prodGroup = &lt;span style="color: rgb(0,0,255)"&gt;Group&lt;/span&gt;, NumInStock = Sum(prod.UnitsInStock) _
            &lt;span style="color: rgb(0,0,255)"&gt;Join&lt;/span&gt; cat &lt;span style="color: rgb(0,0,255)"&gt;In&lt;/span&gt; db.Categories &lt;span style="color: rgb(0,0,255)"&gt;On&lt;/span&gt; cat.CategoryID &lt;span style="color: rgb(0,0,255)"&gt;Equals&lt;/span&gt; CategoryID _
            &lt;span style="color: rgb(0,0,255)"&gt;Select&lt;/span&gt; &lt;span style="color: rgb(100,100,185)"&gt;&amp;lt;&lt;/span&gt;&lt;span style="color: rgb(132,70,70)"&gt;Products&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;&amp;gt;
&lt;/span&gt;                       &lt;span style="color: rgb(100,100,185)"&gt;&amp;lt;&lt;/span&gt;&lt;span style="color: rgb(132,70,70)"&gt;Category&lt;/span&gt; &lt;span style="color: rgb(185,100,100)"&gt;CategoryID&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;=&lt;/span&gt;&lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;&amp;lt;%=&lt;/span&gt;&lt;/span&gt; CategoryID &lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;%&amp;gt;&lt;/span&gt;&lt;/span&gt; &lt;span style="color: rgb(185,100,100)"&gt;CategoryName&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;=&lt;/span&gt;&lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;&amp;lt;%=&lt;/span&gt;&lt;/span&gt; cat.CategoryName &lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;%&amp;gt;&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;&lt;/span&gt;&amp;gt;
&lt;/span&gt;                           &lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;&amp;lt;%=&lt;/span&gt;&lt;/span&gt; &lt;span style="color: rgb(0,0,255)"&gt;From&lt;/span&gt; prod &lt;span style="color: rgb(0,0,255)"&gt;In&lt;/span&gt; prodGroup _
                               &lt;span style="color: rgb(0,0,255)"&gt;Select&lt;/span&gt; &lt;span style="color: rgb(100,100,185)"&gt;&amp;lt;&lt;/span&gt;&lt;span style="color: rgb(132,70,70)"&gt;Product&lt;/span&gt; &lt;span style="color: rgb(185,100,100)"&gt;Price&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;=&lt;/span&gt;&lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;&amp;lt;%=&lt;/span&gt;&lt;/span&gt; prod.UnitPrice &lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;%&amp;gt;&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;&lt;/span&gt;&amp;gt;&lt;/span&gt;&lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;&amp;lt;%=&lt;/span&gt;&lt;/span&gt; prod.ProductName &lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;%&amp;gt;&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;&lt;/span&gt;&amp;lt;/&lt;/span&gt;&lt;span style="color: rgb(132,70,70)"&gt;Product&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;&amp;gt;&lt;/span&gt; &lt;span style="color: rgb(85,85,85)"&gt;&lt;span style="background: rgb(255,254,191)"&gt;%&amp;gt;
&lt;/span&gt;&lt;/span&gt;                       &lt;span style="color: rgb(100,100,185)"&gt;&amp;lt;/&lt;/span&gt;&lt;span style="color: rgb(132,70,70)"&gt;Category&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;&amp;gt;
&lt;/span&gt;                   &lt;span style="color: rgb(100,100,185)"&gt;&amp;lt;/&lt;/span&gt;&lt;span style="color: rgb(132,70,70)"&gt;Products&lt;/span&gt;&lt;span style="color: rgb(100,100,185)"&gt;&amp;gt;&lt;/span&gt;&lt;/pre&gt;
&lt;a href="http://11011.net/software/vspaste" mce_href="http://11011.net/software/vspaste"&gt;&lt;/a&gt;

&lt;p&gt;Last but not least, for those of you who aren&amp;#8217;t so excited about the LINQ (Language INtegrated Query) project, Visual Basic 2008 comes with a tremendous &lt;a href="http://channel9.msdn.com/ShowPost.aspx?PostID=334318" mce_href="http://channel9.msdn.com/ShowPost.aspx?PostID=334318"&gt;improvement in the Intellisense&lt;/a&gt; experience overall. One of our MVPs said that he literally types two characters and hits tab, two characters, tab &amp;#8211; it&amp;#8217;s as though the code writes itself!&lt;/p&gt;

&lt;p&gt;Obviously, we&amp;#8217;re &lt;i&gt;very&lt;/i&gt; excited about this release and hope it meets you with open arms eager to embrace the productivity! If you're ready to go to the next level and dig in, be sure to check out our &lt;a href=" http://msdn2.microsoft.com/en-us/bb931185.aspx"&gt;learning pages&lt;/a&gt; and &lt;a href="http://msdn2.microsoft.com/en-us/vbasic/bb466226.aspx"&gt;How-Do-I videos&lt;/a&gt; which walk you through these features and so much more. &lt;/p&gt;

&lt;p&gt;Tomorrow I&amp;#8217;ll blog about the least often mentioned goodies hidden in Visual Basic 2008 so that you can become the guru master of VB9. &amp;#8216;Til then&amp;#8230; &lt;/p&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=6405290" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/IDE/default.aspx">IDE</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB_5F00_Express/default.aspx">VB_Express</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Visual+Basic+History/default.aspx">Visual Basic History</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB2008/default.aspx">VB2008</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ+Cookbook/default.aspx">LINQ Cookbook</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/IQueryable/default.aspx">IQueryable</category></item><item><title>Channel 9 Interview - Amanda Silver on LINQ (Beth Massi)</title><link>http://blogs.msdn.com/vbteam/archive/2007/08/17/channel-9-interview-amanda-silver-on-linq-beth-massi.aspx</link><pubDate>Fri, 17 Aug 2007 22:24:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:4435659</guid><dc:creator>VBTeam</dc:creator><slash:comments>4</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/4435659.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=4435659</wfw:commentRss><description>&lt;P&gt;I just posted &lt;A class="" href="http://channel9.msdn.com/ShowPost.aspx?PostID=335058" target=_blank mce_href="http://channel9.msdn.com/ShowPost.aspx?PostID=335058"&gt;an interview with Amanda on Channel 9&lt;/A&gt; where she walks us through the new LINQ syntax available in &lt;A class="" href="http://msdn2.microsoft.com/en-us/vbasic/aa700831.aspx" target=_blank mce_href="http://msdn2.microsoft.com/en-us/vbasic/aa700831.aspx"&gt;VS 2008 Beta 2&lt;/A&gt;. I also posted some &lt;A class="" href="http://msdn2.microsoft.com/en-us/vbasic/bb466226.aspx#linq" target=_blank mce_href="http://msdn2.microsoft.com/en-us/vbasic/bb466226.aspx#linq"&gt;How Do I videos on LINQ&lt;/A&gt; to help get you started -- look for more of these beginning of next week!&lt;/P&gt;
&lt;P&gt;&lt;A class="" href="http://channel9.msdn.com/ShowPost.aspx?PostID=335058" target=_blank mce_href="http://channel9.msdn.com/ShowPost.aspx?PostID=335058"&gt;﻿In this interview&lt;/A&gt;, &lt;A href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx"&gt;Amanda Silver&lt;/A&gt;, a Lead Program Manager on the &lt;A href="http://blogs.msdn.com/vbteam/"&gt;Visual Basic Team&lt;/A&gt;, demonstrates new LINQ syntax around Joins and Aggregates that is now available in &lt;A class="" href="http://msdn2.microsoft.com/en-us/vbasic/aa700831.aspx" target=_blank mce_href="http://msdn2.microsoft.com/en-us/vbasic/aa700831.aspx"&gt;Visual Studio 2008 Beta 2&lt;/A&gt;. Amanda is a guru of LINQ in Visual Basic and gives insightful explanations of how to use this new syntax. &lt;/P&gt;
&lt;P&gt;The interview starts out a little funny because the first 20 seconds of my video tape got chewed up so we had to reshoot the intro later in the day. Amanda thought of a funny way to make the transition as you'll see. See if you can pinpoint the movie that inspired her!&lt;/P&gt;
&lt;P&gt;Enjoy!&lt;BR&gt;- &lt;A class="" href="http://blogs.msdn.com/bethmassi/" target=_blank mce_href="http://blogs.msdn.com/bethmassi/"&gt;Beth Massi&lt;/A&gt;, VS Community&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=4435659" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Beth+Massi/default.aspx">Beth Massi</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB2008/default.aspx">VB2008</category></item><item><title>Amanda Silver will be Presenting VB and Silverlight on Second Life! (Beth Massi)</title><link>http://blogs.msdn.com/vbteam/archive/2007/07/30/amanda-silver-will-be-presenting-vb-and-silverlight-on-second-life-beth-massi.aspx</link><pubDate>Mon, 30 Jul 2007 21:43:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:4135087</guid><dc:creator>VBTeam</dc:creator><slash:comments>1</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/4135087.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=4135087</wfw:commentRss><description>&lt;P&gt;&lt;A class="" href="https://www.visualstudioisland.com/" target=_blank mce_href="https://www.visualstudioisland.com/"&gt;&lt;IMG hspace=10 src="http://blogs.msdn.com/photos/bethmassi/images/4134974/original.aspx" align=left mce_src="http://blogs.msdn.com/photos/bethmassi/images/4134974/original.aspx"&gt;&lt;/A&gt;&lt;/P&gt;
&lt;P mce_keep="true"&gt;If you haven't seen or experienced &lt;A class="" href="http://www.secondlife.com/" target=_blank mce_href="http://www.secondlife.com/"&gt;Second Life&lt;/A&gt;&amp;nbsp;it's pretty amazing. It's an online, 3D, digital world. &lt;A class="" href="https://www.visualstudioisland.com/" target=_blank mce_href="https://www.visualstudioisland.com/"&gt;Visual Studio has created an island&lt;/A&gt;&amp;nbsp;where you can come listen to live Microsoft presenters in this virtual world's live presentation theater! &lt;A class="" href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx" target=_blank mce_href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx"&gt;Amanda Silver&lt;/A&gt; will be presenting Visual Basic on Silverlight tomorrow, &lt;STRONG&gt;July 31st at 4pm Pacific time&lt;/STRONG&gt;. There's a lot of other fun events you should check out as well. &lt;/P&gt;
&lt;P&gt;See you there!&lt;/P&gt;
&lt;P mce_keep="true"&gt;-&lt;A class="" href="http://blogs.msdn.com/bethmassi/" target=_blank mce_href="http://blogs.msdn.com/bethmassi/"&gt;Beth Massi&lt;/A&gt;, VS Community&lt;/P&gt;
&lt;P mce_keep="true"&gt;&amp;nbsp;&lt;/P&gt;
&lt;P mce_keep="true"&gt;&amp;nbsp;&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=4135087" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Beth+Massi/default.aspx">Beth Massi</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Silverlight/default.aspx">Silverlight</category></item><item><title>Lambdas, and Take While, and Group By, Oh My!</title><link>http://blogs.msdn.com/vbteam/archive/2007/07/26/lambdas-and-take-while-and-group-by-oh-my.aspx</link><pubDate>Thu, 26 Jul 2007 20:02:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:4068272</guid><dc:creator>VBTeam</dc:creator><slash:comments>4</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/4068272.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=4068272</wfw:commentRss><description>&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;Hooray! &lt;/FONT&gt;&lt;A href="http://msdn2.microsoft.com/en-us/vstudio/" mce_href="http://msdn2.microsoft.com/en-us/vstudio/"&gt;&lt;FONT face=Calibri size=3&gt;Visual Basic 2008 Beta2&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; has been released to the wild today to return to its natural habitat – the desktops of our beloved customers. (Please note our smiling GPM's face on that landing page -- he's &lt;STRONG&gt;so &lt;/STRONG&gt;happy the Beta is done.)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;What’s inside? So much that there might be &lt;I style="mso-bidi-font-style: normal"&gt;more&lt;/I&gt; new features than we released in Beta1, but who’s counting? Here’s a laundry list that’s specific to the VB language that’s &lt;I style="mso-bidi-font-style: normal"&gt;new &lt;/I&gt;for Beta2:&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpFirst style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="FONT-FAMILY: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT size=3&gt;·&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Query operators&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 1in; TEXT-INDENT: -0.25in; mso-list: l0 level2 lfo1; mso-add-space: auto"&gt;&lt;SPAN style="FONT-FAMILY: 'Courier New'; mso-fareast-font-family: 'Courier New'"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT size=3&gt;o&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt;Group By, Group Join, Join, Take [While], Skip [While], Aggregate, Count, Sum, Min, Max, Average, From &lt;/FONT&gt;&lt;SPAN style="FONT-FAMILY: Wingdings; mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-char-type: symbol; mso-symbol-font-family: Wingdings"&gt;&lt;SPAN style="mso-char-type: symbol; mso-symbol-font-family: Wingdings"&gt;à&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri&gt; Let&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="FONT-FAMILY: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT size=3&gt;·&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Nullable support&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="FONT-FAMILY: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT size=3&gt;·&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Lambda Expressions (aka Inline Functions)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="FONT-FAMILY: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT size=3&gt;·&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Partial Methods – &lt;/FONT&gt;&lt;A href="http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx" mce_href="http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx"&gt;&lt;FONT face=Calibri size=3&gt;ScottGu&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; mentioned this the other day &amp;amp; &lt;/FONT&gt;&lt;A href="http://blogs.msdn.com/vbteam/archive/2007/03/27/partial-methods.aspx" mce_href="http://blogs.msdn.com/vbteam/archive/2007/03/27/partial-methods.aspx"&gt;&lt;FONT face=Calibri size=3&gt;ScottWis&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; posted a couple weeks back&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpLast style="MARGIN: 0in 0in 10pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="FONT-FAMILY: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT size=3&gt;·&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Anonymous Types w/Keys – Which &lt;/FONT&gt;&lt;A href="http://www.panopticoncentral.net/archive/2007/05/11/20566.aspx" mce_href="http://www.panopticoncentral.net/archive/2007/05/11/20566.aspx"&gt;&lt;FONT face=Calibri size=3&gt;PaulV&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; has already discussed&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;Here are a bunch of queries you can now write with VB!&lt;/FONT&gt;&lt;/P&gt;
&lt;DIV style="BORDER-RIGHT: windowtext 1pt solid; PADDING-RIGHT: 4pt; BORDER-TOP: windowtext 1pt solid; PADDING-LEFT: 4pt; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 1pt; BORDER-LEFT: windowtext 1pt solid; PADDING-TOP: 1pt; BORDER-BOTTOM: windowtext 1pt solid; mso-element: para-border-div; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242"&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: green; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;' Find suppliers in the same city as customers&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;From&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Customers _&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Join&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; sup &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Suppliers _&lt;?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;On&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust.City &lt;SPAN style="COLOR: blue"&gt;Equals&lt;/SPAN&gt; sup.City _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Select&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust.CompanyName, sup.ContactName, cust.City&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: green; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;' Find suppliers in the same city, with the same postalcode as customers&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;From&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Customers _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Join&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; sup &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Suppliers _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;On&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust.City &lt;SPAN style="COLOR: blue"&gt;Equals&lt;/SPAN&gt; sup.City &lt;SPAN style="COLOR: blue"&gt;And&lt;/SPAN&gt; cust.PostalCode &lt;SPAN style="COLOR: blue"&gt;Equals&lt;/SPAN&gt; sup.PostalCode&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 10pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Select&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust.CompanyName, sup.ContactName, cust.City&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;' Find the average unit price and count for products by category&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;From&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; prod &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Products _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Group&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; &lt;SPAN style="COLOR: blue"&gt;By&lt;/SPAN&gt; prod.CategoryID _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Into&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; Average(prod.UnitPrice), Count()&lt;SPAN style="COLOR: green"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;' For each customer find the group of the suppliers in the same country&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;From&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Customers _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Group&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; &lt;SPAN style="COLOR: blue"&gt;Join&lt;/SPAN&gt; sup &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Suppliers _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;On&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust.Country &lt;SPAN style="COLOR: blue"&gt;Equals&lt;/SPAN&gt; sup.Country _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Into&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; SuppliersInCountry = &lt;SPAN style="COLOR: blue"&gt;Group&lt;/SPAN&gt; _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 10pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Select&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust.CompanyName, SuppliersInCountry&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;' For each customer, the count of the number of suppliers in the same country&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;From&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Customers _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Group&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; &lt;SPAN style="COLOR: blue"&gt;Join&lt;/SPAN&gt; sup &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Suppliers _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;On&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust.Country &lt;SPAN style="COLOR: blue"&gt;Equals&lt;/SPAN&gt; sup.Country _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Into&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; NumSuppliers = Count() _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Select&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; cust.CompanyName, NumSuppliers&lt;SPAN style="COLOR: green"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;' Avg price, avg # in stock, and max on order for non-discontinued products&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Aggregate&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; prod &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Products _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Where&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; &lt;SPAN style="COLOR: blue"&gt;Not&lt;/SPAN&gt; prod.Discontinued _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Into&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; AvgPrice = Average(prod.UnitPrice), _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;AvgInStock = Average(prod.UnitsInStock), _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 10pt; BORDER-LEFT: medium none; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; LINE-HEIGHT: 115%; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;MaxOnOrder = Max(prod.UnitsOnOrder)&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;' Find orderID, OrderDate, and OrderTotal for each order&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;From&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; order &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; db.Orders _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Where&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; order.OrderDate &amp;gt; #7/22/1996# _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Aggregate&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; ordDet &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; order.Order_Details _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Into&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; OrderTotal = _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;Sum(ordDet.UnitPrice *ordDet.Quantity * (1 - ordDet.Discount))&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Select&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; order.OrderID, order.OrderDate, OrderTotal&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: green; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;' Fill a dictionary with the customers by CompanyName&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: medium none; PADDING-LEFT: 0in; BACKGROUND: #f2f2f2; PADDING-BOTTOM: 0in; MARGIN: 0in 0in 0pt; BORDER-LEFT: medium none; LINE-HEIGHT: normal; PADDING-TOP: 0in; BORDER-BOTTOM: medium none; mso-layout-grid-align: none; mso-border-alt: solid windowtext .5pt; mso-background-themecolor: background1; mso-background-themeshade: 242; mso-padding-alt: 1.0pt 4.0pt 1.0pt 4.0pt"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;db.Customers.ToDictionary(&lt;SPAN style="COLOR: blue"&gt;Function&lt;/SPAN&gt;(cust &lt;SPAN style="COLOR: blue"&gt;As&lt;/SPAN&gt; Customer) cust.CompanyName)&lt;SPAN style="COLOR: green"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/DIV&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;In addition to all the new language support, we now have keyword Intellisense (finally!)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt" mce_keep="true"&gt;&lt;IMG title="Keyword Intellisense" style="WIDTH: 713px; HEIGHT: 344px" height=344 alt="Keyword Intellisense" src="http://blogs.msdn.com/photos/vbteam/images/4068260/original.aspx" width=713 mce_src="http://blogs.msdn.com/photos/vbteam/images/4068260/original.aspx"&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;We have &lt;A class="" title="XML Intellisense" href="http://blogs.msdn.com/vbteam/archive/2007/06/06/visual-basic-xml-transform-teched-demo-prep.aspx" mce_href="http://blogs.msdn.com/vbteam/archive/2007/06/06/visual-basic-xml-transform-teched-demo-prep.aspx"&gt;XML Intellisense&lt;/A&gt;! What?? That’s right.&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;IMG title="XML Intellisense" style="WIDTH: 476px; HEIGHT: 229px" height=229 alt="XML Intellisense" src="http://blogs.msdn.com/photos/vbteam/images/3119902/original.aspx" width=476 mce_src="http://blogs.msdn.com/photos/vbteam/images/3119902/original.aspx"&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt;And we’ve done some major performance improvements for the background compiler – let us know if you experience any sluggishness&amp;nbsp;for this&amp;nbsp;Beta.&amp;nbsp;&amp;nbsp;(BTW, you should check out &lt;A class="" title="Installation Notes for Beta2" href="http://weblogs.asp.net/scottgu/archive/2007/07/26/vs-2008-and-net-3-5-beta-2-released.aspx" mce_href="http://weblogs.asp.net/scottgu/archive/2007/07/26/vs-2008-and-net-3-5-beta-2-released.aspx"&gt;Scott's post&lt;/A&gt; on Beta2 to avoid some problems with AJAX extensions if you're installing to a machine that has had previous versions of Orcas installed on it or has VS 2005 side by side.) &lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BACKGROUND: white; MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none; mso-background-themecolor: background1"&gt;&lt;FONT face=Calibri size=3&gt;Also, don’t forget to look for other exciting features around the product that pertain to VB and/or LINQ. For example, Linq to SQL now supports the &lt;/FONT&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Like&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt; operator! There’s also a new &lt;/FONT&gt;&lt;A href="http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx" mce_href="http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx"&gt;&lt;FONT face=Calibri size=3&gt;ASP:LinqDataSource&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; control. &lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BACKGROUND: white; MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none; mso-background-themecolor: background1"&gt;&lt;FONT face=Calibri size=3&gt;&lt;/FONT&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class=MsoNormal style="BACKGROUND: white; MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none; mso-background-themecolor: background1"&gt;&lt;FONT face=Calibri size=3&gt;So, &lt;/FONT&gt;&lt;A href="http://msdn2.microsoft.com/en-us/vstudio/" mce_href="http://msdn2.microsoft.com/en-us/vstudio/"&gt;&lt;FONT face=Calibri size=3&gt;get the bits&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; while they’re hot!&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="BACKGROUND: white; MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none; mso-background-themecolor: background1"&gt;&lt;FONT face=Calibri size=3&gt;&lt;/FONT&gt;&amp;nbsp;&lt;/P&gt;
&lt;P class=MsoNormal style="BACKGROUND: white; MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none; mso-background-themecolor: background1"&gt;&lt;FONT face=Calibri size=3&gt;-Amanda&lt;/FONT&gt;&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=4068272" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Paul+Vick/default.aspx">Paul Vick</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/IDE/default.aspx">IDE</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Scott+Wisniewski/default.aspx">Scott Wisniewski</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB2008/default.aspx">VB2008</category></item><item><title>Slide Deck for Conquering XML with LINQ to XML Webcast [Beth Massi]</title><link>http://blogs.msdn.com/vbteam/archive/2007/07/05/slide-deck-for-conquering-xml-with-linq-to-xml-webcast-beth-massi.aspx</link><pubDate>Fri, 06 Jul 2007 02:22:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:3715506</guid><dc:creator>VBTeam</dc:creator><slash:comments>1</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/3715506.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=3715506</wfw:commentRss><description>&lt;P&gt;&lt;A class="" href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx" target=_blank mce_href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx"&gt;Amanda Silver&lt;/A&gt;&amp;nbsp;gave a &lt;A class="" href="http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;amp;Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032344189%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e" target=_blank mce_href="http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;amp;Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032344189%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e"&gt;great webcast Tuesday morning on LINQ&amp;nbsp;to XML&lt;/A&gt;&amp;nbsp;(if you missed it, just click the link and view it on-demand). &lt;A class="" href="http://blogs.msdn.com/vbteam/attachment/3715506.ashx" mce_href="http://blogs.msdn.com/vbteam/attachment/3715506.ashx"&gt;Here is the deck&amp;nbsp;she used&lt;/A&gt;. &lt;/P&gt;
&lt;P&gt;Happy LINQing!&lt;/P&gt;
&lt;P&gt;-&lt;A class="" href="http://blogs.msdn.com/bethmassi/" target=_blank mce_href="http://blogs.msdn.com/bethmassi/"&gt;Beth Massi&lt;/A&gt;, Program Manager VS Community&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=3715506" width="1" height="1"&gt;</description><enclosure url="http://blogs.msdn.com/vbteam/attachment/3715506.ashx" length="235848" type="application/vnd.openxmlformats-officedocument.pres" /><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Beth+Massi/default.aspx">Beth Massi</category></item><item><title>Today's Live From Redmond Webcast Rescheduled [Beth Massi]</title><link>http://blogs.msdn.com/vbteam/archive/2007/06/27/today-s-live-from-redmond-webcast-rescheduled.aspx</link><pubDate>Wed, 27 Jun 2007 17:34:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:3566083</guid><dc:creator>VBTeam</dc:creator><slash:comments>1</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/3566083.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=3566083</wfw:commentRss><description>&lt;P&gt;&lt;A class="" href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx" target=_blank mce_href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx"&gt;Amanda Silver&lt;/A&gt; came down with a nasty sickness last night so we just had to reschedule her &lt;A class="" href="http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032344176&amp;amp;EventCategory=4&amp;amp;culture=en-US&amp;amp;CountryCode=US" target=_blank mce_href="http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032344176&amp;amp;EventCategory=4&amp;amp;culture=en-US&amp;amp;CountryCode=US"&gt;Live From Redmond: VB9 - Conquering XML with LINQ to XML talk&lt;/A&gt;&amp;nbsp;for this Tuesday July 3rd. If you're already registered then you're good to go for next week and automated emails should have been sent out to notify you all of the change. If you haven't registered yet, what are you waiting for? :-)&lt;/P&gt;
&lt;P&gt;Sincerest apologies from &lt;A class="" href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx" target=_blank mce_href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx"&gt;Amanda&lt;/A&gt; -- and we hope she feels better very soon!&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=3566083" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Beth+Massi/default.aspx">Beth Massi</category></item><item><title>Live From Redmond Webcast Just Added on LINQ to XML (Beth Massi)</title><link>http://blogs.msdn.com/vbteam/archive/2007/06/13/live-from-redmond-webcast-just-added-on-linq-to-xml-beth-massi.aspx</link><pubDate>Thu, 14 Jun 2007 04:40:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:3280537</guid><dc:creator>VBTeam</dc:creator><slash:comments>0</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/3280537.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=3280537</wfw:commentRss><description>&lt;P&gt;Back by popular demand! &lt;A class="" href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx" target=_blank mce_href="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx"&gt;Amanda Silver&lt;/A&gt; will be presenting &lt;A class="" href='http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;amp;Params=~CMTYDataSvcParams^~arg+Name%3d"ID"+Value%3d"1032344176"/^~arg+Name%3d"ProviderID"+Value%3d"A6B43178-497C-4225-BA42-DF595171F04C"/^~arg+Name%3d"lang"+Value%3d"en"/^~arg+Name%3d"cr"+Value%3d"US"/^~sParams^~/sParams^~/CMTYDataSvcParams^' target=_blank mce_href='http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;amp;Params=~CMTYDataSvcParams^~arg+Name%3d"ID"+Value%3d"1032344176"/^~arg+Name%3d"ProviderID"+Value%3d"A6B43178-497C-4225-BA42-DF595171F04C"/^~arg+Name%3d"lang"+Value%3d"en"/^~arg+Name%3d"cr"+Value%3d"US"/^~sParams^~/sParams^~/CMTYDataSvcParams^'&gt;Live From Redmond: VB9 - Conquering XML with LINQ to XML&lt;/A&gt;&amp;nbsp;on June 27th. &lt;/P&gt;
&lt;P&gt;In Visual Basic 9.0, XML becomes a built-in data type with a rich editing experience that &lt;EM&gt;completely eliminates&lt;/EM&gt; the conceptual barrier between the code that you write and the XML that you’re trying to express.&amp;nbsp;&amp;nbsp;Amanda will take you from the guts of the LINQ to XML API to the easy to grasp abstractions presented in Visual Basic 9.0. It will cover tips, tricks, and gotchas so that you reach peak performance when programming against XML with Visual Basic 9.0.&lt;/P&gt;
&lt;P&gt;Hope to see you at the Webcast!&lt;/P&gt;
&lt;P&gt;For more webcasts, past, present and future please visit the &lt;A class="" href="http://msdn2.microsoft.com/en-us/vbasic/aa727125.aspx" target=_blank mce_href="http://msdn2.microsoft.com/en-us/vbasic/aa727125.aspx"&gt;Visual Basic Webcast page&lt;/A&gt;.&lt;/P&gt;
&lt;P&gt;-&lt;A class="" href="http://blogs.msdn.com/bethmassi/" target=_blank mce_href="http://blogs.msdn.com/bethmassi/"&gt;Beth Massi&lt;/A&gt;, Program Manager VS Community&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=3280537" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Beth+Massi/default.aspx">Beth Massi</category></item><item><title>Visual Basic XML Transform - TechEd demo prep</title><link>http://blogs.msdn.com/vbteam/archive/2007/06/06/visual-basic-xml-transform-teched-demo-prep.aspx</link><pubDate>Wed, 06 Jun 2007 19:13:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:3120262</guid><dc:creator>VBTeam</dc:creator><slash:comments>7</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/3120262.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=3120262</wfw:commentRss><description>&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;Hello from Orlando! I’ve been at TechEd 2007 this week in &lt;I style="mso-bidi-font-style: normal"&gt;very &lt;/I&gt;sunny Orlando. As part of my demo prep, I had to create a little xml transform to convert the TechEd schedule that I got off the &lt;/FONT&gt;&lt;A href="http://www.msteched.com/" mce_href="http://www.msteched.com/"&gt;&lt;FONT face=Calibri size=3&gt;www.msteched.com&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; website in an Excel XML format into a more readable xml file format. I could have done this all with one transform, but the newer XML file format made for good demo fodder to show off the XML Intellisense features coming in Orcas Beta2. &lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;I thought the code was interesting and fun – a great blend of XML properties, XML Literals, and query – so I’ve posted it below:&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Imports&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; System.IO&lt;?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Imports&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; &lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #b96464"&gt;xmlns:ss&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;=&lt;/SPAN&gt;&lt;SPAN style="COLOR: #555555"&gt;"&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;urn:schemas-microsoft-com:office:spreadsheet&lt;/SPAN&gt;&lt;SPAN style="COLOR: #555555"&gt;"&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: #6464b9; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;Module&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; Module1&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: green"&gt;'Metadata info&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;Enum&lt;/SPAN&gt; Column&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Code&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Title&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Description&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Track&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Session&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Level&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Speaker&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Room&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;Timeslot&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;End&lt;/SPAN&gt; &lt;SPAN style="COLOR: blue"&gt;Enum&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;Sub&lt;/SPAN&gt; Main()&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;Dim&lt;/SPAN&gt; fromFile = &lt;SPAN style="COLOR: #a31515"&gt;"C:\TechEdScheduleExcelFormat.xml"&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;Dim&lt;/SPAN&gt; toFile = &lt;SPAN style="COLOR: #a31515"&gt;"C:\MyXMLFormat.xml"&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;Dim&lt;/SPAN&gt; excelXML = XElement.Load(fromFile)&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: green"&gt;' Remove first row - metadata info&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;excelXML...&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;ss:Row&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;.First.Remove()&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;Dim&lt;/SPAN&gt; xml = _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;?&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;xml&lt;/SPAN&gt; &lt;SPAN style="COLOR: #b96464"&gt;version&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;=&lt;/SPAN&gt;&lt;SPAN style="COLOR: #555555"&gt;"&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;1.0&lt;/SPAN&gt;&lt;SPAN style="COLOR: #555555"&gt;"&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;?&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;EventSchedule&lt;/SPAN&gt; &lt;SPAN style="COLOR: #b96464"&gt;Event&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;=&lt;/SPAN&gt;&lt;SPAN style="COLOR: #555555"&gt;"&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;TechEd2007&lt;/SPAN&gt;&lt;SPAN style="COLOR: #555555"&gt;"&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;From&lt;/SPAN&gt; session &lt;SPAN style="COLOR: blue"&gt;In&lt;/SPAN&gt; excelXML...&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;ss:Row&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt; _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;Let&lt;/SPAN&gt; info = session...&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;ss:Data&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt; _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;Select&lt;/SPAN&gt; _&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Event&lt;/SPAN&gt; &lt;SPAN style="COLOR: #b96464"&gt;ID&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;=&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Code).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Title&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Title).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Title&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Description&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Description).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Description&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Track&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Track).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Track&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Session&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Session).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Session&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Level&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Level).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Level&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Speaker&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Speaker).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Speaker&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Room&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Room).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Room&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;TimeSlot&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;&amp;lt;%=&lt;/SPAN&gt; info(Column.Timeslot).Value &lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;TimeSlot&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;Event&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;/SPAN&gt; _&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;SPAN style="BACKGROUND: yellow; COLOR: #555555; mso-highlight: yellow"&gt;%&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;lt;/&lt;/SPAN&gt;&lt;SPAN style="COLOR: #844646"&gt;EventSchedule&lt;/SPAN&gt;&lt;SPAN style="COLOR: #6464b9"&gt;&amp;gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: #6464b9; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;xml.Save(toFile)&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;Shell(&lt;SPAN style="COLOR: #a31515"&gt;"C:\Program Files\Internet Explorer\iexplore.exe "&lt;/SPAN&gt; &amp;amp; toFile, AppWinStyle.MaximizedFocus)&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;o:p&gt;&amp;nbsp;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;SPAN style="COLOR: blue"&gt;End&lt;/SPAN&gt; &lt;SPAN style="COLOR: blue"&gt;Sub&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt; LINE-HEIGHT: normal; mso-layout-grid-align: none"&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;&lt;SPAN style="COLOR: blue"&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt;End&lt;/SPAN&gt;&lt;SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Lucida Console'; mso-no-proof: yes; mso-bidi-font-family: 'Times New Roman'"&gt; &lt;SPAN style="COLOR: blue"&gt;Module&lt;o:p&gt;&lt;/o:p&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt"&gt;&lt;FONT face=Calibri size=3&gt;All this, so that in the demo, I could:&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpFirst style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1; mso-add-space: auto"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;1)&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Open the resulting file, “MyXMLFormat.xml”, in Visual Studio&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1; mso-add-space: auto"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;2)&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Right click on the XML menu item&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1; mso-add-space: auto"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;3)&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Select create schema to infer an XSD from that file:&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1; mso-add-space: auto"&gt;&lt;IMG title="Create Schema" style="WIDTH: 341px; HEIGHT: 151px" height=151 alt="Create Schema" src="http://blogs.msdn.com/photos/vbteam/images/3119924/original.aspx" width=341 mce_src="http://blogs.msdn.com/photos/vbteam/images/3119924/original.aspx"&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1; mso-add-space: auto"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1; mso-add-space: auto"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;4)&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;Save the schema as an XSD and add it as an existing item in my project:&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; mso-add-space: auto"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&lt;IMG title="Save as XSD" style="WIDTH: 458px; HEIGHT: 114px" height=114 alt="Save as XSD" src="http://blogs.msdn.com/photos/vbteam/images/3119804/original.aspx" width=458 mce_src="http://blogs.msdn.com/photos/vbteam/images/3119804/original.aspx"&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpLast style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1; mso-add-space: auto"&gt;&lt;SPAN style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;5)&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT face=Calibri size=3&gt;And get an &lt;I style="mso-bidi-font-style: normal"&gt;awesome &lt;/I&gt;Intellisense experience over the XML:&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpLast style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1; mso-add-space: auto"&gt;&lt;IMG title="XML Intellisense" style="WIDTH: 476px; HEIGHT: 229px" height=229 alt="XML Intellisense" src="http://blogs.msdn.com/photos/vbteam/images/3119902/original.aspx" width=476 mce_src="http://blogs.msdn.com/photos/vbteam/images/3119902/original.aspx"&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.25in"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 0pt 0.25in"&gt;&lt;FONT face=Calibri size=3&gt;Pretty cool, no? &lt;/FONT&gt;&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=3120262" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category></item><item><title>Bill &amp; Steve (Jobs!) reminisce about floating point BASIC</title><link>http://blogs.msdn.com/vbteam/archive/2007/05/31/bill-steve-jobs-reminisce-about-floating-point-basic.aspx</link><pubDate>Thu, 31 May 2007 20:07:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:3010603</guid><dc:creator>VBTeam</dc:creator><slash:comments>0</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/3010603.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=3010603</wfw:commentRss><description>&lt;FONT face=Calibri&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT size=3&gt;Another entry in the annals of BASIC history today…. &lt;/FONT&gt;&lt;A href="http://d5.allthingsd.com/20070531/video-steve-jobs-and-bill-gates-highlight-reel/" mce_href="http://d5.allthingsd.com/20070531/video-steve-jobs-and-bill-gates-highlight-reel/"&gt;&lt;FONT size=3&gt;Bill Gates and Steve Jobs sat down for an interview&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt; with Kara Swisher and Walt Mossberg of All Things Digital for the D5 conference. One of the highlights of the video is recalling the agreement Apple struck with Microsoft for a version of BASIC which supported floating point numbers. &lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&lt;/SPAN&gt;Apparently, Steve &lt;I style="mso-bidi-font-style: normal"&gt;begged &lt;/I&gt;Steve Wozniak to implement such a version of BASIC, eventually licensed a version that supported floating point numbers from Microsoft, and then released it as &lt;/FONT&gt;&lt;A href="http://en.wikipedia.org/wiki/Applesoft_BASIC" mce_href="http://en.wikipedia.org/wiki/Applesoft_BASIC"&gt;&lt;FONT size=3&gt;Applesoft BASIC&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt; in 1979. Watching them tell the story is like having your parents tell you how they met – kind of gross, but endearing.&lt;/FONT&gt;&lt;/P&gt;&lt;/FONT&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=3010603" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Visual+Basic+History/default.aspx">Visual Basic History</category></item><item><title>AmandaS' LINQ talk at VSLive Orlando</title><link>http://blogs.msdn.com/vbteam/archive/2007/05/07/linq-talk-at-vslive-orlando.aspx</link><pubDate>Tue, 08 May 2007 08:21:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:2474567</guid><dc:creator>VBTeam</dc:creator><slash:comments>5</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/2474567.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=2474567</wfw:commentRss><description>&lt;P&gt;&lt;SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-family: Arial; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin"&gt;&lt;FONT size=3&gt;I escaped from Redmond this week to present at &lt;/FONT&gt;&lt;A href="http://www.ftponline.com/conferences/vslive/2007/orlando/" mce_href="http://www.ftponline.com/conferences/vslive/2007/orlando/"&gt;&lt;FONT size=3&gt;VSLive Orlando&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt; on LINQ in Visual Studio Orcas. As promised, please find the slides and demos included as an attachment below. &lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-family: Arial; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin"&gt;&lt;FONT size=3&gt;As mentioned during the talk – that was intended to be an overview. If you want really want to understand the nitty-gritty details behind what make LINQ possible, be certain to tune into my &lt;/FONT&gt;&lt;A href="http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;amp;Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032332489%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name" mce_href="http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;amp;Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032332489%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name"&gt;&lt;FONT size=3&gt;LINQ Deep Dive&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt; &lt;/FONT&gt;&lt;A href="http://msdn2.microsoft.com/en-us/vbasic/aa727125.aspx" mce_href="http://msdn2.microsoft.com/en-us/vbasic/aa727125.aspx"&gt;&lt;FONT size=3&gt;WebCast&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt; on May 23&lt;SUP&gt;rd&lt;/SUP&gt;. If you’d like me to go into something specific during the webcast, just respond to this post. I can’t promise to get to everything in the webcast itself, but I do promise to answer any LINQ related questions in response to this post or the webcast. Be sure to pose questions to the LINQ forum if you think others might be able to help or have the same question. &lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-family: Arial; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin"&gt;&lt;FONT size=3&gt;&lt;IMG title="Billy Hollis and Amanda Silver talking about the future of Visual Basic over a lemonade" style="WIDTH: 320px; HEIGHT: 240px" height=240 alt="Billy Hollis and Amanda Silver talking about the future of Visual Basic over a lemonade" hspace=20 src="http://blogs.msdn.com/photos/vbteam/images/2474795/original.aspx" width=320 align=left vspace=10 mce_src="http://blogs.msdn.com/photos/vbteam/images/2474795/original.aspx"&gt;&lt;?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P&gt;&lt;SPAN style="FONT-FAMILY: 'Calibri','sans-serif'; mso-bidi-font-family: Arial; mso-ascii-theme-font: minor-latin; mso-hansi-theme-font: minor-latin"&gt;&lt;FONT size=3&gt;I had a great time at &lt;/FONT&gt;&lt;A href="http://www.ftponline.com/conferences/vslive/2007/orlando/" mce_href="http://www.ftponline.com/conferences/vslive/2007/orlando/"&gt;&lt;FONT size=3&gt;VSLive&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt; today, I hope you enjoyed it as much as I did. I’m looking forward to &lt;/FONT&gt;&lt;A href="http://www.microsoft.com/events/teched2007/default.mspx" mce_href="http://www.microsoft.com/events/teched2007/default.mspx"&gt;&lt;FONT size=3&gt;TechEd&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt;!&lt;o:p&gt;&lt;/o:p&gt;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P mce_keep="true"&gt;&amp;nbsp;&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=2474567" width="1" height="1"&gt;</description><enclosure url="http://blogs.msdn.com/vbteam/attachment/2474567.ashx" length="1894118" type="application/x-zip-compressed" /><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/LINQ_2F00_VB9/default.aspx">LINQ/VB9</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/IDE/default.aspx">IDE</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/VB_5F00_Express/default.aspx">VB_Express</category></item><item><title>Four dynamic languages for .NET interoperating!</title><link>http://blogs.msdn.com/vbteam/archive/2007/05/02/four-dynamic-languages-for-net-interoperating.aspx</link><pubDate>Wed, 02 May 2007 21:06:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:2378074</guid><dc:creator>VBTeam</dc:creator><slash:comments>3</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/2378074.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=2378074</wfw:commentRss><description>&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;John Lam just posted a &lt;/FONT&gt;&lt;A href="http://silverlight.net/Learn/learnvideo.aspx?video=74"&gt;&lt;FONT face=Calibri size=3&gt;screen cast&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; of four dynamic languages interoperating in SIlverlight on the Mac! Check it out!&lt;/FONT&gt;&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=2378074" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/DLR/default.aspx">DLR</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Silverlight/default.aspx">Silverlight</category></item><item><title>What do the announcements at Mix mean for the Visual Basic developer? </title><link>http://blogs.msdn.com/vbteam/archive/2007/04/30/what-do-the-announcements-at-mix-mean-for-the-visual-basic-developer.aspx</link><pubDate>Tue, 01 May 2007 08:52:00 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:2351444</guid><dc:creator>VBTeam</dc:creator><slash:comments>7</slash:comments><comments>http://blogs.msdn.com/vbteam/comments/2351444.aspx</comments><wfw:commentRss>http://blogs.msdn.com/vbteam/commentrss.aspx?PostID=2351444</wfw:commentRss><description>&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;At the &lt;/FONT&gt;&lt;A href="http://www.visitmix.com/" mce_href="http://www.visitmix.com/"&gt;&lt;FONT face=Calibri size=3&gt;Mix&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; conference today in Las Vegas, &lt;/FONT&gt;&lt;A href="http://rayozzie.spaces.live.com/" mce_href="http://rayozzie.spaces.live.com/"&gt;&lt;FONT face=Calibri size=3&gt;Ray Ozzie&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; and &lt;/FONT&gt;&lt;A href="http://weblogs.asp.net/scottgu/" mce_href="http://weblogs.asp.net/scottgu/"&gt;&lt;FONT face=Calibri size=3&gt;Scott Guthrie&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; were dropping goodies like tootsie pops from a piñata. There was so much packed into their over &lt;/FONT&gt;&lt;A href="http://metahost.origindigital.com/microsoft/20070430/mix07_20070430_500.asx" mce_href="http://metahost.origindigital.com/microsoft/20070430/mix07_20070430_500.asx"&gt;&lt;FONT face=Calibri size=3&gt;two hour keynote&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; that I thought it would be useful to distill the announcements down into one bite-sized post that should make for a pretty quick read (but unfortunately, includes no code samples.)&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpFirst style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-bidi-font-family: Calibri"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;-&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt;&lt;B style="mso-bidi-font-weight: normal"&gt;VB on Silverlight&lt;/B&gt; – In short, this means that you can now use Visual Basic as the code-behind for whiz-bang &lt;/FONT&gt;&lt;/FONT&gt;&lt;A href="http://silverlight.net/fox/" mce_href="http://silverlight.net/fox/"&gt;&lt;FONT face=Calibri size=3&gt;rich&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; &lt;/FONT&gt;&lt;A href="http://silverlight.net/mscom/" mce_href="http://silverlight.net/mscom/"&gt;&lt;FONT face=Calibri size=3&gt;interactive&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; applications that run on Windows or the Mac and can run in IE, Firefox, and Safari. You can download the &lt;/FONT&gt;&lt;A href="http://silverlight.net/GetStarted/" mce_href="http://silverlight.net/GetStarted/"&gt;&lt;FONT face=Calibri size=3&gt;alpha .NET-enabled release&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; but to develop you will need the &lt;/FONT&gt;&lt;A href="http://www.microsoft.com/downloads/details.aspx?FamilyId=6C2B309B-8F2D-44A5-B04F-836F0D4EC1C4&amp;amp;displaylang=en" mce_href="http://www.microsoft.com/downloads/details.aspx?FamilyId=6C2B309B-8F2D-44A5-B04F-836F0D4EC1C4&amp;amp;displaylang=en"&gt;&lt;FONT face=Calibri size=3&gt;Visual Studio Extensions for Silverlight for “Orcas” Beta1. &lt;/FONT&gt;&lt;/A&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/SPAN&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in"&gt;&lt;B style="mso-bidi-font-weight: normal"&gt;&lt;?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-bidi-font-family: Calibri"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;-&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt;&lt;B style="mso-bidi-font-weight: normal"&gt;Unparalleled support for dynamic languages – &lt;/B&gt;As you may have noticed us &lt;/FONT&gt;&lt;/FONT&gt;&lt;A href="http://www.langnetsymposium.com/" mce_href="http://www.langnetsymposium.com/"&gt;&lt;FONT face=Calibri size=3&gt;hinting&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; at over the past couple of &lt;/FONT&gt;&lt;A href="http://channel9.msdn.com/Showpost.aspx?postid=116702" mce_href="http://channel9.msdn.com/Showpost.aspx?postid=116702"&gt;&lt;FONT face=Calibri size=3&gt;years&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; now, VB has certain aspects to it that are dynamic – late binding, explicit member indexing, runtime conversions and operators, etc. With Silverlight comes the introduction of the DLR, a shared runtime component for dynamic languages atop .NET. There are many, many, things this means for VB that will unfold over the coming months, but one of the most important ones is that it will enable simple interoperability between Visual Basic and the other dynamic languages on .NET like &lt;/FONT&gt;&lt;A href="http://www.iunknown.com/" mce_href="http://www.iunknown.com/"&gt;&lt;FONT face=Calibri size=3&gt;Ruby&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt;, &lt;/FONT&gt;&lt;A href="http://blogs.msdn.com/hugunin/" mce_href="http://blogs.msdn.com/hugunin/"&gt;&lt;FONT face=Calibri size=3&gt;Python&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt;, and JScript. &lt;B style="mso-bidi-font-weight: normal"&gt;&lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in"&gt;&lt;B style="mso-bidi-font-weight: normal"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-bidi-font-family: Calibri"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;-&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt;&lt;B style="mso-bidi-font-weight: normal"&gt;Live Services – &lt;/B&gt;The Live Services team has created Windows &lt;/FONT&gt;&lt;/FONT&gt;&lt;A href="http://www.codeplex.com/liveinabox" mce_href="http://www.codeplex.com/liveinabox"&gt;&lt;FONT face=Calibri size=3&gt;Live in a Box&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt; that will allow you to begin integrating rich photo experiences, search, contacts and more into your applications. &lt;SPAN style="mso-spacerun: yes"&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;B style="mso-bidi-font-weight: normal"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpMiddle style="MARGIN: 0in 0in 0pt 0.5in"&gt;&lt;B style="mso-bidi-font-weight: normal"&gt;&lt;o:p&gt;&lt;FONT face=Calibri size=3&gt;&amp;nbsp;&lt;/FONT&gt;&lt;/o:p&gt;&lt;/B&gt;&lt;/P&gt;
&lt;P class=MsoListParagraphCxSpLast style="MARGIN: 0in 0in 10pt 0.5in; TEXT-INDENT: -0.25in; mso-list: l0 level1 lfo1"&gt;&lt;SPAN style="mso-ascii-font-family: Calibri; mso-hansi-font-family: Calibri; mso-fareast-font-family: Calibri; mso-bidi-font-family: Calibri"&gt;&lt;SPAN style="mso-list: Ignore"&gt;&lt;FONT face=Calibri size=3&gt;-&lt;/FONT&gt;&lt;SPAN style="FONT: 7pt 'Times New Roman'"&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt;&lt;B style="mso-bidi-font-weight: normal"&gt;Productivity Frameworks – &lt;/B&gt;Scott and Ray didn’t talk about this in their keynote, but with Mix comes a couple of new productivity frameworks. The first is &lt;/FONT&gt;&lt;/FONT&gt;&lt;A href="http://asp.net/downloads/futures/default.aspx?tabid=62" mce_href="http://asp.net/downloads/futures/default.aspx?tabid=62"&gt;&lt;FONT face=Calibri size=3&gt;Dynamic ASP.NET controls&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; which uses runtime database schema and coding conventions to data-bind and generate ASP.NET pages. The second is “&lt;/FONT&gt;&lt;A href="http://www.microsoft.com/downloads/details.aspx?FamilyID=471bb3ac-b31a-49cd-a567-f2e286715c8f&amp;amp;displaylang=en" mce_href="http://www.microsoft.com/downloads/details.aspx?FamilyID=471bb3ac-b31a-49cd-a567-f2e286715c8f&amp;amp;displaylang=en"&gt;&lt;FONT face=Calibri size=3&gt;Jasper&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt;”, a &lt;/FONT&gt;&lt;A href="http://pather.net/shyam/ViewPost.aspx?PostId=6" mce_href="http://pather.net/shyam/ViewPost.aspx?PostId=6"&gt;&lt;FONT face=Calibri size=3&gt;dynamic data access&lt;/FONT&gt;&lt;/A&gt;&lt;FONT size=3&gt;&lt;FONT face=Calibri&gt; layer that is independent of a presentation technology which sits atop the Entity Framework. We’re looking forward to seeing the reception for these kinds of frameworks. &lt;B style="mso-bidi-font-weight: normal"&gt;&lt;o:p&gt;&lt;/o:p&gt;&lt;/B&gt;&lt;/FONT&gt;&lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;So, that’s the two-bite version of the announcements… Over the next couple of weeks we’ll post new entries, videos, and samples demonstrating what each of these means in detail – though for some dirty details, you’ll have to wait for the &lt;/FONT&gt;&lt;A href="http://msdn.microsoft.com/events/pdc/" mce_href="http://msdn.microsoft.com/events/pdc/"&gt;&lt;FONT face=Calibri size=3&gt;PDC&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt;. &lt;/FONT&gt;&lt;/P&gt;
&lt;P class=MsoNormal style="MARGIN: 0in 0in 10pt"&gt;&lt;FONT face=Calibri size=3&gt;I’ll be at &lt;/FONT&gt;&lt;A href="http://www.ftponline.com/conferences/vslive/2007/orlando/" mce_href="http://www.ftponline.com/conferences/vslive/2007/orlando/"&gt;&lt;FONT face=Calibri size=3&gt;VSLive&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; next week to talk about &lt;/FONT&gt;&lt;A href="http://www.ftponline.com/conferences/vslive/2007/orlando/netday.aspx" mce_href="http://www.ftponline.com/conferences/vslive/2007/orlando/netday.aspx"&gt;&lt;FONT face=Calibri size=3&gt;LINQ and Integrated XML in VB Orcas&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt;. I also have my turn for the &lt;/FONT&gt;&lt;A href="http://blogs.msdn.com/bethmassi/archive/2007/04/09/live-from-redmond-webcast-series.aspx" mce_href="http://blogs.msdn.com/bethmassi/archive/2007/04/09/live-from-redmond-webcast-series.aspx"&gt;&lt;FONT face=Calibri size=3&gt;webcast series&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; for the &lt;/FONT&gt;&lt;A href="http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;amp;Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032332489%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name" mce_href="http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&amp;amp;Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032332489%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name"&gt;&lt;FONT face=Calibri size=3&gt;VB LINQ deep dive&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; and &lt;/FONT&gt;&lt;A href="http://www.microsoft.com/events/teched2007/default.mspx" mce_href="http://www.microsoft.com/events/teched2007/default.mspx"&gt;&lt;FONT face=Calibri size=3&gt;TechEd&lt;/FONT&gt;&lt;/A&gt;&lt;FONT face=Calibri size=3&gt; not that shortly after I get back – so I’ve got some work to do! Enough overview, back to coding!&lt;/FONT&gt;&lt;/P&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=2351444" width="1" height="1"&gt;</description><category domain="http://blogs.msdn.com/vbteam/archive/tags/Amanda+Silver/default.aspx">Amanda Silver</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/DLR/default.aspx">DLR</category><category domain="http://blogs.msdn.com/vbteam/archive/tags/Silverlight/default.aspx">Silverlight</category></item></channel></rss>