Integrating Visual APL assemblies with SQL Server 2005, Part 2: Using Visual APL to control, manipulate, and act as the source of data for SQL queries.
SQL Server 2005 allows amazing integration with true .Net languages, such as Visual APL and C#. This integration allows .Net assemblies to control the output of SQL queries by calling functions in the assembly to perform as-needed data control and filtering during SQL queries.
Once the ground work has been laid for using these technologies in a Visual APL project, this WebCast will show a practical example of using Visual APL component files as a data source for queries run in SQL Server.
This webcast will cover some of the different options for sending data back and forth between Visual APL and SQL Server, including:
- An SQL Command
- A string message
- SQL data record
- SQL data reader
- Using Visual APL functions to produce data as it is needed by an SQL query, allowing the explicit control of data type and content.
This WebCast will also cover the basics of Table Value Functions, including:
- How you can define them and use them is Visual APL.
- How there are two functions involved in the process, one that defines an enumeration for SQL to iterate across, and the second which actually builds the data for every member of the enumeration, at the moment that the member is requested by SQL Server.
This WebCast will cover how to use “out” parameters to precisely control the content of rows of data in an SQL table result.
This webcast will be available from the following urls:
For the best experience, enter the following in your browser address bar:
mms://wms.aplnext.com/meeting27
If your firewall does not permit access via mms, use:
http://wms.aplnext.com/meeting27
These links are live now, and have a short webcast looping for you to see which works best for you.
Details
This webcast will have an accompanying IM session. There will be a moderator using IM to take your questions, provide answers and forward questions to the presenters to be answered during the webcast. This should provide a similar experience to raising your hand to ask a question during a presentation, but with the advantage that you can chat without getting in trouble. The moderator IM account to be used with the presentation will be MS/Yahoo.
IM account
webcast@aplnext.com
If you don't have Windows Live Messenger you can get it free at: http://get.live.com/messenger/overview
If you don't have a Microsoft Passport Id or a Windows Live ID you can get it for free at: http://ideas.live.com by clicking on the “Sign In“ link on the upper right corner of the page.
Once you have your Windows Live ID open the Windows Live Messenger and click on the “Sign In“ button. After signing in go to Contacts > Add a Contact and type “webcast@aplnext.com“ in the “Instant Messaging Address:“ field. At this point you should be able to participate in the Realtime WebCast Q&A.
If you are behind a firewall you can try the web based version at http://webmessenger.msn.com/
If you cannot use IM just send your questions by email to webcast@aplnext.com.