VS 2010 IDE integration with SQL 2008 T-SQL Editor

Visual Studio 2010 has new feature to invoke T-SQL Editor inside its IDE itself.

So unlike in VS 2008 and other previous Visual Studio versions where you had to open SQL Server Management Studio to run the T-SQL queries, VS 2010 provides this feature which comes handly when you need to interact with database without leaving your Visusl Studio IDE.

You can access it through Data menu by choosing Transact-SQL Editor option. It offers connectivity only with SQL Server 2008 only, in order to open T-SQL Editor.


click on the image to see in larger view, use back button to continue reading

Once the T-SQL Editor is open it also shows the SQL related toolbar on the top, as shown marked in RED color on top-left, and allows you to work with SQL 2008 Databases without leaving the VS 2010 IDE.

VS 2010 code editor’s Tab closing behavior

In any of the Visual Studio IDE, VS 2002 until VS 2008 each .cs or any other file was/is displayed in the form of a separate code-editor tab, and so at some point in time it was very common to have multiple files open in various code-editor tabs.

The problem comes when you want to close these tabs and it is and has been a troublesome process as in these versions of VS 2002 – VS 2008 there is a common closing tab on the right-hand-side so you have to go to that common closing button for each tab as shown in the screenshot below.

common closing button for all the tabs
Click on the image caption link to see larger view

In VS 2010 this behavior is changed and each tab has its own closing button, this makes it more simple and easy to use. Notice in the image below that each tab has its own closing button and there is no common closing button on the right-hand-side like in VS 2008 or any of the previous version of Visual Studio.


each tab has a closing button
Click on the image caption link to see larger view

VS 2010 compatibility with VS 2008

Visual Studio 2010 is backward compatible with Visual Studio 2008, and it allows upgrading Visual Studio 2008 solution/projects to VS 2010 with the help of upgrade wizard.

Any VS 2010 solution/project or the one which you upgraded from VS 2008 to VS 2010 cannot be re-opened in VS 2008. If you try to do so you will receive an error that you can't open a solution or project which is created with newer version of this application.

VS 2010 - Splash Screen

This is how splash screen looks in Visual Studio 2010.

Codeplex - WPF Application Framework

Microsoft launched WPF Application Framework,its alpha could be downloaded from codeplex site, by following the link below:
WPF Application Framework (WAF)

This application framework will help you create the applications based on layered architecture and the Model-View-ViewModel (aka MVVM, M-V-VM, PresentationModel) patterns.

.NET Framework 3.5 SP1 is a prerequisite for this.

Bing - Because Its Not Google

Microsoft has launched its new search engine which will replace live.com.