MSDN Technical Briefing: SQL Server 2005 - 17th August
I've just finished delivering a session on CLR support in SQL 2005 and had several people ask for the demos. Here they are.
Grab the zip file here, and the slides here.
You will need SQL 2005 beta 2 or later and VS 2005 Beta 2. To install the db open the SQL workbench project .\PhotoDemo\PhotoDemoSql\PhotoDemoSql.sqlsuo, change the path references in play.sql, createassemblies.sql and CreateEverything.sql. Open .\PhotoDemo\Application\PhotoClient\PhotoClient.sln in VS 2005 and build it. Run CreateEverything.sql in SQL WB to install the db and the managed assemblies. When building the C# app sometimes the build fails with a missing assembly. If this happens right click on the ImageFuincs project and select build. Then do a build all on the solution. I don’t know why this happens.
The app has a connection string in frmMainApp.cs that you will need to update to point to your db.
This is *demo* code. Expect it to break and expect no support.
Marcus