Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1205
  • Last Modified:

Visual C# Express support for SQL Server

I joined a programming course which covers the following topics

Programming Concepts
.Net 2.0 FrameWork
Microsoft C#.Net 2005
SQL Server Server (Query)
ADO.Net 2.0

I have Visual Studio Express 2008 (namely using C# express) , I heard though it doesn't support SQL server that is one of the topics I will be taking in the course. Can someone confirm if this is the case and hence will need the professional version of the studio?

Thanks in advance
2 Solutions
Of course as a professional I'm working with a professional edition of VS. However, what I learnd from the MS site of "express" editions (quotation about Visual C# express edition):
"Create data-enabled applications with the lightweight SQL Server Compact Edition or powerful client/serve applications with  SQL Server 2008 Express". You may also to download express sql server.
See http://www.microsoft.com/express/vcsharp/. So - can't see any problems.

Moreover, in theory one may write programs without using any "visual" tools, just using C# compiler and a text editor like Notepad (of course .Net plsatform should be installed on a computer but it's again free). And it is possible to write all sql stuff manuallyand it will work.

As a matter of fact I prefer to create all my data connections etc manually in the code but not using any visual tools.

I'm pretty sure that you won't have any problems accessing a non-express version of Sql Server using the express version of the C# IDE. I may be wrong, but even if I am, the express version of Sql Server should be more than sufficient for your needs.
Anurag ThakurCommented:
what did you really mean by support....
Sql Server Express is nearly scaled down versions of the actyual Server but only a few high end stuff such as agents, replication etc are missing
Sql Server Express should be sufficient for the training purposes as most of the thing which are taught in training can be taken care in SQL Express
Visual Studio 2008 Express (C#) does support SQL Server (Express or full, doesn't matter).

If you're asking whether or not you can connect to a SQL Server database from an application written with Visual Studio 2008 Express then the anwer is yes, you can (I've done it a ton of times).
Oh and Visual Studio itself doesn't care what version of SQL Server you're running - it's just using System.Data.SqlClient in either case.  As mentioned above SQL Server itself differs a bit between express and full versions though (the main difference is the lack of SSIS in the express versions - it controls things like scheduled tasks/maintenance plans).

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now