We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Visual C# Express support for SQL Server

a_anis3000
a_anis3000 asked
on
Medium Priority
1,217 Views
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
a_anis3000
 
Comment
Watch Question

anarki_jimbelSenior Developer
CERTIFIED EXPERT

Commented:
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 ThakurTechnical Manager

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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
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).
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.