Connecting to SQL Server with Visual Studio Express Editions [closed]

by

You should be able to choose the SQL Server Database file option to get the right kind of database (the system.data.SqlClient provider), and then manually correct the connection string to point to your db.

I think the reasoning behind those db choices probably goes something like this:

  • If you’re using the Express Edition, and you’re not using Visual Web Developer, you’re probably building a desktop program.
  • If you’re building a desktop program, and you’re using the express edition, you’re probably a hobbyist or uISV-er working at home rather than doing development for a corporation.
  • If you’re not developing for a corporation, your app is probably destined for the end-user and your data store is probably going on their local machine.
  • You really shouldn’t be deploying server-class databases to end-user desktops. An in-process db like Sql Server Compact or MS Access is much more appropriate.

However, this logic doesn’t quite hold. Even if each of those 4 points is true 90% of the time, by the time you apply all four of them it only applies to ~65% of your audience, which means up to 35% of the express market might legitimately want to talk to a server-class db, and that’s a significant group. And so, the simplified (greedy) version:

  • A real db server (and the hardware to run it) costs real money. If you have access to that, you ought to be able to afford at least the standard edition of visual studio.

More Related Contents:

  1. visual studio 2008: HELP lost data! [closed]
  2. How to set session timeout in web.config
  3. How do I create/edit a Manifest file?
  4. Metadata file ‘.dll’ could not be found
  5. How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?
  6. String escape into XML
  7. Application.Exit
  8. What is the “right” way to bring a Windows Forms Application to the foreground?
  9. NUnit vs. Visual Studio 2008’s test projects for unit testing [closed]
  10. Generic base class for WinForm UserControl
  11. How does Entity Framework work with recursive hierarchies? Include() seems not to work with it
  12. Determine list of event handlers bound to event
  13. Debug Target Is Missing?
  14. the source file is different from when the module was built
  15. How do I add my new User Control to the Toolbox or a new Winform?
  16. How can I generate UUID in C#
  17. Resolving extension methods/LINQ ambiguity
  18. How can I get Visual Studio 2008 Windows Forms designer to render a Form that implements an abstract base class?
  19. How do I programmatically list all projects in a solution?
  20. How to declare a friend assembly?
  21. Which files in a Visual C# Studio project don’t need to be versioned?
  22. Why doesn’t VS 2008 display extension methods in Intellisense for String class
  23. How do I run NUnit in debug mode from Visual Studio?
  24. Windows Service not appearing in services list after install
  25. HttpWebRequest: The request was aborted: The request was canceled
  26. Cannot find namespace ‘System.Data.SqlServerCe’
  27. how do i check if a printer is installed and ready using C#?
  28. Static Linking of libraries created on C# .NET
  29. Post Publish Events
  30. C# Compiler optimization – Unused methods

Leave a Comment