1 / 15

SQL Server 2005 CLR Integration ADO 2.0

gelsey
Download Presentation

SQL Server 2005 CLR Integration ADO 2.0

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

    1. SQL Server 2005 CLR Integration ADO.NET 2.0 Marcus Perryman marcpe@microsoft.com http://blogs.msdn.com/marcpe

    2. Agenda select top 1 * from [sql2005 developer features] go waitfor delay ’00:45:00’ select * from [ado v2 features]; go

    3. SQL Server Development Today

    4. The .NET Development Platform

    5. SQL Server 2005 Development

    6. SQL Server 2005 Development

    7. What can we do with CLR code? Common T-SQL objects can be implemented in CLR code User defined functions (and table valued functions) Stored procedures Triggers Additional objects can be implemented in CLR code User Defined Types User Defined Aggregates (MAX, MIN, SUM … )

    8. When do we use CLR code? T-SQL code is great for CRUD operations CLR code is great for; General purpose Library support (.NET Framework) Tool support (Visual Studio 2005) Safety and (by scenario) performance “For the dirty jobs T-SQL doesn’t want to do”

    9. Where do we use CLR code? “Distance” between the code and the data Scale up/out possibilities of different tiers Abstraction of the database technology Security requirements Set-based versus procedural code Possibilities for using shared code libraries in multiple tiers

    10. CLR Code Inside SQL Server

    11. Agenda select top 1 * from [sql2005 developer features] go waitfor delay ’00:45:00’ select * from [ado v2 features]; go

    13. ADO.NET 2.0 Features SQL 2005 User Defined Type support Query notifications Asynchronous support Multiple active result sets Client statistics Factory APIs DataSet & DataTable enhancements Binary serialization, stand-alone DataTables Bulk Load API

    14. SQL Server 2005 Resources Web Sites Product site http://www.microsoft.com/sql/2005/default.asp MSDN Centre http://msdn.microsoft.com/sql SQL Team http://www.sqlteam.com SQL Junkies http://www.sqljunkies.com SQL Server 2005 Express Edition http://lab.msdn.microsoft.com/express/sql/default.aspx Webcasts http://msdn.microsoft.com/sql/2005webcasts Books http://www.microsoft.com/sql/2005/samplechapters.asp User Groups http://msdn.microsoft.com/usergroups/find.asp Newsgroups Microsoft.public.sqlserver.*

More Related