Share via


Visual Studio and SQL Server 2008

With the release of SQL Server 2005 and Visual Studio 2005 we delivered significant new improvements to make developers more productive when working with data stored in SQL Server.

With Visual Studio 2008 and the upcoming version of SQL Server 2008 we’re going to continue driving new innovations and ensure that developers can build richer data driven applications. As I’ve talked about in the past, one of my favorite features of VS2008 is the introduction of LINQ which is an exciting evolution in data programming that provides common query capabilities within the programming language. LINQ closes the gap between the programming world and the data world by providing a common query facility for in-memory and external data. Integrating query capabilities into the programming language provides a simple, natural way to build strongly typed queries that benefit from design-time features like IntelliSense. This is an exciting leap forward to bridge the gap between Data and Programming.

Here are some things to keep in mind to know what it takes to have Visual Studio support SQL Server 2008.

· For the November CTP of SQL Server 2008, which came out a few weeks ago, we have released a patch which enables Visual Studio 2005 to connect to a SQL Server 2008 database.

· For Visual Studio 2008 to support SQL Server 2008, we will be delivering a patch to coincide with the next CTP of SQL Server 2008.

· Tools support of some of the new features in SQL Server 2008 will become available closer to the RTM of that product. This will give us time to test, optimize and ensure the best experience for developers using Visual Studio and the .NET Framework with SQL Server 2008.

For more details on integration I encourage you to read the following blog entry from our Data Programmability team.

Namaste!

Comments

  • Anonymous
    December 09, 2007
    Somasegar's WebLog : Visual Studio and S...

  • Anonymous
    January 08, 2008
    Good that there is a patch available for VS 2005 to connect to SQL 2008. Also are there express editions of VS 2008 as was the case with VS 2005?

  • Anonymous
    January 10, 2008
    The comment has been removed

  • Anonymous
    January 10, 2008
    Mark - We are committed to productivity for database developers.  I would like to talk about your concerns futher.  Please contact me at megp@microsoft.com.

  • Anonymous
    January 11, 2008
    Yes, there are Express Editions of VS 2008 like what we had in VS 2005.  Likewise, when SQL Server 2008 ships later this year, there will be an Express Edition of SQL Server. -somasegar

  • Anonymous
    January 20, 2008
    Question on this: For Visual Studio 2008 to support SQL Server 2008, we will be delivering a patch to coincide with the next CTP of SQL Server 2008 When is next CTP of SQL Server 2008 coming out? Waiting eagerly to use LINQ/dbml from within VS.NET 2008.

  • Anonymous
    January 21, 2008
    The next CTP of SQL Server 2008 will likely come out towards the end of Feburary - in time for the "VS2008, Windows Server 2008 and SQL Server 2008" launch. -somasegar

  • Anonymous
    February 10, 2008
    Thanks for the info, but how about leaving a highlighted note on this here: http://www.microsoft.com/downloads/details.aspx?FamilyID=e1109aef-1aa2-408d-aa0f-9df094f993bf&displaylang=en and somewhere else related to VS2008 where developers are expected to pass by. That would have saved me several hours of browsing and searching. Given the hype about the two products, it's very hard to believe the patch isn't ready yet. /gustav

  • Anonymous
    March 27, 2008
    When will the patch for VS 2008 become available?

  • Anonymous
    April 10, 2008
    For anyone watching this space for an update here's a link to the patch for VS 2008 http://www.microsoft.com/downloads/details.aspx?familyid=A999C84F-0FE5-4926-A1BF-4730D1CAA98C&displaylang=en I haven't tried it yet, has anyone else? Got any comments on it?

  • Anonymous
    May 13, 2008
    I am testing it - seems to work, at least worked once. I worked, i managed to create a connection and some DBML file but then it lost connection and I can't connect again.

  • Anonymous
    June 03, 2008
    Download Visual Studio 2008 SP1 Beta here. Added full support for SQL Server 2008 and many other cool features. http://www.microsoft.com/downloads/details.aspx?FamilyId=CF99C752-1391-4BC3-BABC-86BC0B9E8E5A&displaylang=en

  • Anonymous
    August 25, 2008
    ok, I'm lost on the Microsoft site at this point.  I'm attempting to buy a single package of Visual Studio 2008 and SQL Server to run on MS Server 2003/2008.   When I look at the MS website there is an option for VS Professional with MSDN Professional which includes a "subscription" to SQL Server.  Is the SQL server only supported by VS in that package?

  • Anonymous
    September 03, 2008
    Mark, you are so d*mn right! There is not even one single programming language on the market that can compete with MS Visual Foxpro. I've been working with VFP for 10 years now. But I also worked a lot with PHP, ASP.NET, C#, VB and J2EE for more than 7 years. VFP is best when it goes for data - even with SQL server in the backend VFP is uncomparable. It's a pitty that MSFT dropped VFP. It' fast, ultra-stable. RAD-capable, easy to deploy ans do on. Linq is a nice try to bring VFP ideas into the .Net world, but.... Did you know that a small spanish company managed what the Microsoft guys couldn't? Look here: http://www.etecnologia.net/

  • Anonymous
    November 19, 2008
    You are right Mark. When it comes to data manipulation vfp is great. I think MS will loose a lot of programmers by leaving vfp. I'm sure if etecnologia will succeed in their project most of vfp developers will buy etecnologia product. And because vfp.net anounced by Etecnologia will be their primary product, they will invest in it and make it far better than everything MS has at the moment when comes to data access. I don't know why the "smart guys" from MS can't learn from the VFP flexibility and at least make another language easy to work with like vfp was if not move vfp in .net and promote it as the best tool for data access. It is much simple to work with sql server backend and vfp as frontend than with these days .net products. For me is important to make an application fast and flexible and things what I could do with vfp easy and with couple of instructions I need 10 times more time consuming to do in C#

  • Anonymous
    April 18, 2010
    Ms has remove and add several plugin, to get better "visual studio", and i think visual studio more powerfull in new version

  • Anonymous
    August 10, 2011
    Can Any one Send me the details steps to connect visual studio 2008 to sql server please i need to know urgebtly please reply in rahulprocessor@gmail.com

  • Anonymous
    August 10, 2011
    Rahul, you can learn more about using the Entity Framework to connect to SQL on MSDN.  This is a good place to start: msdn.microsoft.com/.../bb399572%28v=VS.90%29.aspx Polita Paulus Microsoft