Thursday, March 22, 2007 at 10:00am EST
This webcast will show how to create Visual APL assemblies which integrate with SQL Server 2005 as stored procedures!
Integrating Visual APL assemblies with SQL Server 2005
This webcast will show the basics of deploying Visual APL assemblies to a database in Microsoft SQL Server 2005, and using methods in your deployed assemblies as stored procedures.
Stored procedures are the most common form of database automation in SQL Server 2005, and using Visual APL to integrate your functions and code directly into SQL for use as stored procedures is a powerful tool.
Examples shown in this webcast include:
Enabling the CLR on a database in SQL Server 2005.
How to add the common Visual APL assemblies to a database.
Introduction to the Microsoft.SqlServer.Server namespace, which is the Microsoft namespace that contains all objects, types, and functions for interacting with SQL Server.
Create a class library, create a method, and mark that method with the Microsoft.SqlServer.Server.SqlProcedure attribute. Marking a method with this attribute allerts SQL Server that the method can be used as a stored procedure once the assembly has been deployed.
Deploy your newly created Visual APL assembly to the SQL database.
Call your method as a stored procedure from SQL queries, and even call your stored procedure from other stored procedures!