SAN FRANCISCO, 25 AUGUST 2008 - Microsoft Visual Studio 2008 (VS08) Service Pack 1 (SP1) took eight months to arrive. Considering the capabilities that have been added, eight months might not seem so long. In some ways, SP1 feels like the completion of what Visual Studio 2008 was supposed to be. It's certainly not just the collection of bug fixes that you'd expect from the term "service pack."
It's about the data
SP1 finally includes the ADO.Net Entity Framework (EF), the Entity Data Model (EDM), and LINQ to Entities. EDM is a full-blown language-independent, database-independent entity-relationship model. It is supported by an Entity SQL language and is especially useful for data-centric line-of-business applications. LINQ to Entities integrates queries against Entities into C# and Visual Basic, which may obviate the need to learn the subtleties of Entity SQL for many programmers.
Note that Entity SQL is significantly different from the Transact-SQL query language used in Microsoft SQL Server. Speaking of SQL Server, SP1 adds full support for SQL Server 2008 to Visual Studio 2008, hot on the heels of the release of SQL Server 2008.
I'm happy to say that the VS08 HTML editor is no longer broken for Classic ASP. The HTML editor is still not smart enough to resolve server-side includes, however.
On the Web
The major new Web features of SP1 are ASP.Net Dynamic Data and URL Routing. Both seem to have been influenced by the popularity of Ruby on Rails, in that they support the Model-View-Controller pattern and quick generation of Web pages from database schemas.
Dynamic Data lets you build a basic data-driven Web application very quickly, based on a data model, in much the same spirit as building a Rails scaffold application. It also improves the way the data-bound controls work, adding validation and templates. The MSDN walk-through of creating a new dynamic data Web site using scaffolding includes two ways of creating the data model: one using LINQ to SQL, and the other using the Entity Framework. Check the Dynamic Data in Action section of the official ASP.Net page for a series of video tutorials.
Sign up for Computerworld eNewsletters.