E-Book Content
Visual Studio .NET Developer ®
Business Solutions for Developers Using the Microsoft® .NET Framework and Visual Studio® .NET
Using the SQL Server 2005 CLR from Visual Studio 2005 Rick Dobson The next version of Visual Studio and SQL Server will pack a much more powerful punch than the two products do today. One of the most exciting new synergistic features is the ability to create SQL Server database objects with managed code from Visual Studio. In this article, Rick Dobson introduces you to these exciting new capabilities.
A
recent popular saying goes, “If the glove doesn’t fit, then you must acquit.” However, in this case, the glove fits perfectly: Microsoft is guilty of providing vastly improved interoperability! Its upcoming releases for Visual Studio and SQL Server are more tightly integrated than ever before. This article is a “first look” at one of the centerpieces of this interoperability: the ability to create SQL Server database objects from Visual Studio. Through a series of screen shots and code samples, you’ll see firsthand how to take advantage of the CLR in SQL Server 2005 from Visual Studio 2005. Does this mean T-SQL is history? No. You may still find T-SQL handy when creating database objects, but now you have a choice—you can also create objects using the familiar VB or C# languages, too. If you are a professional developer with a basic grasp of T-SQL, you are likely to find this new interoperability highly productive. Even if you’re a SQL Server DBA with extensive T-SQL experience, you’ll almost certainly find that the ability to supplement T-SQL with VB or C# opens a whole new range of programming flexibility. I’ll begin with an overview of the process for using Visual Studio to create database objects that reside and function inside SQL Server. I’ll follow up with
January 2005 Volume 5, Number 1
1
Using the SQL Ser