Stephane,

There may be tools out there, I don't know. I *do* know that two and a half years ago, there wasn't (or none that we knew about) and so we basically wrote our own back then. We wrote a little .NET utility that takes the results returned from a Stored Proc specified by you and creates an .xsd. That easily takes care of your database schema changes. Also, we wrote a VFP utility that will generate 3 Stored Procs for any table that you specify ... a GET proc, a DELETE proc and a PUT proc (that does either an update or an insert, depending on whether a primary key exists in the data).

None of it is totally automatic ... obviously you've got to remember to run the utilities when you makes schema changes. But still, it greatly simplifies things.

Sorry I can't be of more help. I hope you find a tool out there ... writing your own is nice, since you can make it do things the way *you* want it to ... but finding an existing tool is a lot easier if you're running into time constraints.

~~Bonnie


>I'v looked at many samples and code generators to generate classes for CRUD (Create, Retreive, Update, Delete) operations and none of them seems to do the job right so far.
>
>I'm looking for a simple way to create my typed datasets with an easy recreation method, my database schema is changing at a rapid rate as i am creating my application and i dont want to change my Store procs, Datasets, etc... everytime i change a table.
>
>Anyone has a good tool to suggest?
>
>Thanks.