Visual C# Express support for SQL Server

Posted on 2009-02-16
Last Modified: 2013-11-09
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
Question by:a_anis3000
    LVL 29

    Expert Comment

    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 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.

    LVL 6

    Expert Comment

    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.
    LVL 26

    Expert Comment

    by:Anurag Thakur
    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
    LVL 3

    Accepted Solution

    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).
    LVL 3

    Assisted Solution

    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).

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I have purchased two new systems and both are now Universal Extensible Firmware Interface (UEFI) based. UEFI is replacing BIOS for the desktop PC. It is a Linux based firmware with enough robustness it can communicate with a website without loading …
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now