We are using the typed dataset generation mechanism in Visual Studio 2005 to generate an XSD file and from that typed dataset code (in c#).

We are working from a database with half a dozen tables that thas been created using a file containing SQL CREATE TABLE statements. This is our definitive schema in the project. Once we have the database set up, we use Server Explorer in VS2005 to drop tables from the database into four XSD forms. Each XSD represents a dataset. Then we run the configure option on the tables to generate the CRUD methods for the tables in that dataset.

Wondering how we can automate this process so that the generated C# DAL is automatically created from the database using our make file?

Has anyone else wanted to do this?

Thanks,

John.

Code Smith is a code generation tool.

The typed dataset generation is done in Visual Studio when you save the XSD file. I don't need CodeSmith. What I want to be able to do is automate this in the build process rather than doing this step manually is the Visual Studio IDE.

Not sure how my post got moved from MSDN Forums » .NET Development » XML and the .NET Framework to MSDN Forums » Windows Forms » Windows Forms Data Controls and Databinding

My Q has nothing to do with Windows Forms.