Home » Softwares » Visual Studio » Visual Studio Express Database Explorer difference

Visual Studio Express Database Explorer difference

When you download Visual Studio 2010 Express Edition you have to choose which version you want. In those choice you have the C# version and the web version. Both of them seem to be similar but have some different template. For example, you cannot create a ASP.NET website with the C# one and cannot create a Console Application with the web one.

It also have an other big difference and it’s the Databae Explorer. The C# version won’t let you connect to SQL Server. Only SQL Compact or SQL file.

Here are 2 screen shots of the two Data Explorer:

Visual Studio 2010 C# Edition

Visual Studio 2010 Web Edition

This is interesting because if you want to use SQL Profile you need to use the SQL server and not a file or a compact edition. The reason behind this is that Microsoft may have think that application usually does not require to have a direct access to the SQL server and because they try to cut functionality in each of the Express edition, the C# edition got this cut. However, it’s possible to create a website with a SQL Server because usually web server use SQL Server and not a SQL database file.

If you like my article, think to buy my annual book, professionally edited by a proofreader. directly from me or on Amazon. I also wrote a TypeScript book called Holistic TypeScript

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.