Showing results for VB2008 - Visual Basic Blog

This post assumes you’ve read the previous posts in this series:           Converting SQL to LINQ, Part 1: The Basics           Converting SQL to LINQ, Part 2: FROM and SELECT           Converting SQL to LINQ, Part 3: DISTINCT, WHERE, ORDER BY and Operators This post will discuss scalar and aggregate functions. Functions SQL SELECT clauses ...

It’s really embarrassing when a bug gets out the door in a product.  In particular, it’s hard for me to just sit and take it (however well deserved the criticism is) when a Microsoft product gets nailed in the press for a bad error.  It’s much worse when a friend or relative is the one dealing out the grief.  However, worst of all is...

This post assumes you’ve read the previous posts in this series: Converting SQL to LINQ, Part 1: The Basics Converting SQL to LINQ, Part 2: FROM and SELECT Continuing with specific query clauses, I will cover topics related to DISTINCT, WHERE and ORDER BY. DISTINCT SQL SELECT statements can include the DISTINCT specifier, which causes all dupl...

This post assumes you’ve read Converting SQL to LINQ, Part 1: The Basics. I’ve made the following name changes since the last post, which I hope will make the code examples clearer: ·         Customers -> CustomerTable ·         Orders -> OrderTable ·         cust -> Contact ·         CustomerName -> ContactName ·         ID ->...

Visual Studio has a small but extremely useful feature that allows you to hook external tools directly into the IDE’s Tools menu.  All you have to do is click Tools->External Tools… and then you can add your own custom menu items that will launch a specified program.   On a typical day I’ll probably fire up Reflector and/or ildasm a fe...

If you find yourself looking for something to do with your awesome new copy of Visual Studio 2008, you should check out the December 2007 edition of MSDN magazine. It features an article, written by me, that provides a walk through on how to visualize data on a map using VB 9, WPF and LINQ. To give you a sneak preview of what the app described in ...

I guess I've been working too hard on getting the product ready to ship to notice that Bart has put together an awesome blog series on VB9. It includes discussion of a feature called runtime agility or compiler agility that we haven't taken up on this blog. We introduced this feature to make it much easier for new .NET platforms (think Silverlight,...

Today the VS Ecosystem team released the Visual Studio 2008 SDK 1.0 and the Visual Studio 2008 shell. The VS 2008 SDK contains full native Visual Basic support and contains many VB samples. What was in the VB Pack for the VS 2005 SDK is now included in the VS 2008 SDK, plus more. I've started playing with building Visual Studio AddIns in Visua...

Yesterday I promised to post about the hidden gems in Visual Basic and Visual Studio 2008 that you haven’t read about in blog posts or seen at conferences. I forgot that I mentioned a few of my favorite features in the Beta1 announcement where I showed off the improvements in the Intellisense experience – statement completion for keywor...

As you may already know, VB LINQ statements enable SQL-like syntax for queries in the VB language.  LINQ syntax doesn't match SQL syntax exactly, so if you are already working with SQL or familiar with SQL queries, you may find yourself wanting to convert an existing SQL query to LINQ.This will be the first in a series of posts about convertin...