Search code examples
visual-studiovisual-studio-2008linq-to-sqlbuild-processsqlmetal

How to add a SqlMetal build step in VS2008?


I've created a one-line batch file to run SqlMetal to regenerate a LINQ to SQL DataContext for my database; this works great.

Refresh_DataContext.bat:

"C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin\sqlmetal.exe" 
     /server:.\sqlexpress /database:MyDatabaseName 
     /code:"%~dp0\DataContext.vb" /context:DataContext 
     /views /functions /sprocs /pluralize 

So far I can run this by opening the enclosing folder in Explorer and running the batch file, and I've also added it to the Tools menu (Tools/External Tools.../Add).

Now I'd like to run this batch file whenever I build (in certain configurations). How do I do this?


Solution

  • Doh! Of course. Web Application projects have pre- and post- build events; Web Site projects don't.