ANN: Using ADO.NET inside SQL Server 2005 with SQLCLR

P

Pablo Castro [MS]

SQL Server 2005 enables the creation of procedures, functions, etc. using
managed code. Since you can use managed code, sooner or later you'll want to
access some data in the same or a different server, and for that you'll most
likely use ADO.NET.

I wrote an article that goes through the new features in ADO.NET 2.0 that
are specific to its use inside SQLCLR, and also discusses some advanced
aspects such as transaction management when running inside the database
server.

I hope you enjoy it. If you have feedback, comments, etc. on the article I'd
love to hear them.

Article is at:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/mandataaccess.asp

Thanks,
--
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MSDN Webcast: Introducing ADO.NET 2.0 for SQL Server 2005 2
Can't insert record into SQL server express from ADO.NET inside IIS 4
Visual Studio 2005 Beta 1 is out there! ADO.NET 2.0 included :) 3
SQL Server Stored Procedure Try Catch and ADO.Net exception handli 8
CLR problems with security under ADO.NET and SQL Server 2005 2
SQL Server 2005 causes problems with second connection 2
Using SQL Server temp tables with ADO.NET Datareader 1
Permission to access dB problem in SQL Server 2005 Express from inside VS2005 2

Top