I've posted a short note on the in-proc data provider with SQL Server 2005 over on my CLRSQL weblog. I'll expand on this entry over the weekend, and talk about the execution of commands and support for transactions.