{"id":5183,"date":"2007-11-19T12:27:00","date_gmt":"2007-11-19T12:27:00","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/vbteam\/2007\/11\/19\/visual-basic-2008-ships-amanda-silver\/"},"modified":"2024-07-05T14:38:16","modified_gmt":"2024-07-05T21:38:16","slug":"visual-basic-2008-ships-amanda-silver","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/vbteam\/visual-basic-2008-ships-amanda-silver\/","title":{"rendered":"Visual Basic 2008 Ships!!! (Amanda Silver)"},"content":{"rendered":"

Hooray! Today we’ve finally shipped <\/i>Visual Studio 2008, previously known as “Orcas”, previously known as some symbol which doesn’t have an ascii representation. We’ve come a long way<\/a>, but it’s been a great ride. In his blog<\/a>, 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. \ud83d\ude42<\/p>\n

This is a tremendous<\/i><\/b> release for Visual Basic users everywhere as it’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 envy<\/i> of many an alpha-geek<\/a>. If you’d like to just try it out — be sure to check out Visual Basic Express<\/a> which comes with all the features I talk about below.<\/p>\n

With query the entire .NET frameworks become a queryable data source. You can now query against anything available in the .NET Frameworks – 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:<\/p>\n

        Dim<\/span> query = From<\/span> proc In<\/span> Process.GetProcesses _\n            Let<\/span> ThreadCount = proc.Threads.Count _\n            Where<\/span> ThreadCount > 10 _\n            Order<\/span> By<\/span> ThreadCount _\n            Select<\/span> proc.ProcessName, proc.Id, ThreadCount<\/pre>\n
<\/a><\/p>\n
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:<\/p>\n
        Dim<\/span> db As<\/span> New<\/span> NorthwindDataContext(My<\/span>.Settings.NORTHWNDConnectionString)\n        Dim<\/span> query = From<\/span> prod In<\/span> db.Products _\n                    Where<\/span> prod.Discontinued = True<\/span> _\n                    Group<\/span> By<\/span> prod.CategoryID _\n                    Into<\/span> Count(), NumInStock = Sum(prod.UnitsInStock) _\n                    Join<\/span> cat In<\/span> db.Categories On<\/span> cat.CategoryID Equals<\/span> CategoryID _\n                    Select<\/span> cat.CategoryName, Count, NumInStock<\/pre>\n
Unlike writing huge SQL query strings, I get immediate feedback on the query I write. <\/p>\n
Intellisense<\/i><\/b>:<\/p>\n
\"clip_image002\"<\/a><\/p>\n
Syntax checking:<\/i><\/b><\/p>\n
\"clip_image004\"<\/a><\/p>\n
Schema checking:<\/i><\/b><\/p>\n
\"clip_image006\"<\/a><\/i><\/b><\/p>\n
I can use the same query language (VB!) to query against relational databases, XML, and collections of objects – I don’t need to learn any domain specific language, VB gives me access to all! It’s really easy for me to join across domains (I’ll take that up in a later blog post.) <\/p>\n
With XML as a first class data-type, Visual Basic becomes a full XML transform language<\/a>. But it’s also really easy for me to project to XML from my SQL database:<\/p>\n
        Dim<\/span> query = From<\/span> prod In<\/span> db.Products _\n            Where<\/span> prod.Discontinued = True<\/span> _\n            Group<\/span> By<\/span> prod.CategoryID _\n            Into<\/span> prodGroup = Group<\/span>, NumInStock = Sum(prod.UnitsInStock) _\n            Join<\/span> cat In<\/span> db.Categories On<\/span> cat.CategoryID Equals<\/span> CategoryID _\n            Select<\/span> <<\/span>Products<\/span>>\n<\/span>                       <<\/span>Category<\/span> CategoryID<\/span>=<\/span><%=<\/span><\/span> CategoryID %><\/span><\/span> CategoryName<\/span>=<\/span><%=<\/span><\/span> cat.CategoryName %><\/span><\/span>>\n<\/span>                           <%=<\/span><\/span> From<\/span> prod In<\/span> prodGroup _\n                               Select<\/span> <<\/span>Product<\/span> Price<\/span>=<\/span><%=<\/span><\/span> prod.UnitPrice %><\/span><\/span>><\/span><%=<\/span><\/span> prod.ProductName %><\/span><\/span><\/<\/span>Product<\/span>><\/span> %>\n<\/span><\/span>                       <\/<\/span>Category<\/span>>\n<\/span>                   <\/<\/span>Products<\/span>><\/span><\/pre>\n
<\/a><\/p>\n
Last but not least, for those of you who aren’t so excited about the LINQ (Language INtegrated Query) project, Visual Basic 2008 comes with a tremendous improvement in the Intellisense<\/a> experience overall. One of our MVPs said that he literally types two characters and hits tab, two characters, tab – it’s as though the code writes itself!<\/p>\n
Obviously, we’re very<\/i> 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 learning pages<\/a> and How-Do-I videos<\/a> which walk you through these features and so much more. <\/p>\n
Tomorrow I’ll blog about the least often mentioned goodies hidden in Visual Basic 2008 so that you can become the guru master of VB9. ‘Til then… <\/p>\n","protected":false},"excerpt":{"rendered":"
Hooray! Today we’ve finally shipped Visual Studio 2008, previously known as “Orcas”, previously known as some symbol which doesn’t have an ascii representation. We’ve come a long way, but it’s been a great ride. In his blog, Soma mentions many of the flagship features at a high-level that will undoubtedly make the every developer and […]<\/p>\n","protected":false},"author":260,"featured_media":8818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[192,195],"tags":[28,67,74,77,93,94,117,164,166,172],"class_list":["post-5183","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-featured","category-visual-basic","tag-amanda-silver","tag-extension_methods","tag-ide","tag-iqueryable","tag-linq-cookbook","tag-linqvb9","tag-orcas","tag-vb_express","tag-vb2008","tag-visual-basic-history"],"acf":[],"blog_post_summary":"
Hooray! Today we’ve finally shipped Visual Studio 2008, previously known as “Orcas”, previously known as some symbol which doesn’t have an ascii representation. We’ve come a long way, but it’s been a great ride. In his blog, Soma mentions many of the flagship features at a high-level that will undoubtedly make the every developer and […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/5183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/users\/260"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/comments?post=5183"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/posts\/5183\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media\/8818"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/media?parent=5183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/categories?post=5183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/vbteam\/wp-json\/wp\/v2\/tags?post=5183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}