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.
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.
