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 (19)

  1. OPC Diary says:

    Somasegar’s WebLog : Visual Studio and S…

  2. Hyderabad says:

    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?

  3. Mark Gordon says:

    If you really want to make database developers more productive move VFP into the .NET family and give us a true data centric language. Current data capabilities in .NET and SQL Server are not even on par with FoxBase let alone Visual FoxPro.

    The real issue is MSFT is too busy trying to attract developers using non-microsoft tools such as ruby into .NET instead of worrying about their current customer base.

    This just get me so mad Microsoft owns the VFP source code so there is no research required just port the current language over and you guys won’t. The form designer, report writer and sql server are fine IN VS and Sql Server… All we NEED is the data access functions. Hell I would be happy with an equilivent of the following commands

    open database (pass in a connection string)

    use (opens a table in the current open database)

    SELECT (database and table name) .I.E SELECT (mydatabase.mytablename)

    scatter memvar to object name

    gather memvar form object name

    seek function

    set order to

    scan for

    endscan

    replace statement

    SELECT INTO CURSOR

    appen blank

    begin transaction

    commit transaction

    Take a look at the following example to add a record

    OPEN DATABASE MyDatabase

    USE mytable

    begin tranasction

    scatter memv blank

    m.myfieldname = "mystring"

    insert into mydatabase.mytable from memvar

    commit transaction

    Now figure out how many lines of .BLOAT code is necessary to pull off the same trick … This really is a no brainer when it comes to how to make developers more productive.

    Even if you guys did implement these functions I’m sure you would F it up somehow by over complicating the entire process for some obsure academic case….

    Developers who have no idea what these command are have no idea of the flexiability this would give us and the productivity increase we would experience of not having to screw around with database reader and adaters.

    In additional

    – Fix function performance issues in SQL Server

    – Add a debugger to SQL Server

    – Fix the group by clause so we can include a unique identifier for each record in the data set return by in the select statement.

    I wish there was an alternative to VFP so MSFT would commit some resources to developing a REAL database language. Instead of the crap we are dealt with from Microsoft in terms of data access… The best solution would be an alternative to Microsoft so I would not have to deal with Microsoft all !!!!!!!

    Best Regards,

    Mark Gordon

  4. MegP_MS says:

    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.

  5. Somasegar says:

    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

  6. Sam says:

    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.

  7. Somasegar says:

    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

  8. Gustav Brock says:

    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

  9. Dave says:

    When will the patch for VS 2008 become available?

  10. Dave says:

    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?

  11. radek says:

    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.

  12. Tiby says:

    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

  13. David says:

    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?

  14. Herold says:

    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/

  15. Camil says:

    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#

  16. efriel says:

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

  17. Rahul Agrawal says:

    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

  18. phuff says:

    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