SQL Stored Proc MSBuild Deploy Windmill tilting

msbuild.readinglist.md

• http://www.beefycode.com/post/Resolving-Binary-References-in-MSBuild.aspx How to append to a property and use BeforeResolveReferences similar to the ResolveAssemblyReferencesDependsOn I want to hook into
• http://blogs.msdn.com/b/msbuild/archive/2005/11/23/496396.aspx and http://blogs.msdn.com/b/msbuild/archive/2006/02/10/528822.aspx How to insert custom build steps.
• http://shop.oreilly.com/product/9780735626287.do Book I need to get
• http://msdn.microsoft.com/en-us/library/ms164287.aspx Leads to a discussion of property versus item.

Stackoverflwo links:

• http://stackoverflow.com/questions/134224/generating-an-xml-serialization-assembly-as-part-of-my-build
• http://stackoverflow.com/questions/2748974/how-to-set-sgen-toolpath-in-msbuild-to-target-3-5-framework

overview.txt

A list of links and notes related to my current MSBuild quest.

I built a simple CLR Proc to call a web service method. This was the start of my problems. SQL gave specific error messages about adding WCF related assemblies. So I used a web reference. I then got an error message about not being able to automatically generate the serialization assembly at runtime. To fix this, I had Visual Studio create one at compile time. However, it was not automatically deployed. I was unsatisfied with using the post desploy sql script to add this assembly because I had to hard code the path. I wanted someting that would work on all machines.

I came up with a solution that works on Visual Studio 2010 by editing the csproj file manually. I need to make it better.

vs2008.txt

I'd like to get this to work in Visual Studio 2008.

So far I'm trying to do this:
devenv foo.sln  /deploy /project foo.SqlCaller /log foo.SqlCaller.deploy.log 

However, Its not writing a log now.