C#: Autogenerating DDL and ORM classes from XML schema (XSD) file

I have a rather large XSD file available here.

I want to generate the following from the file:

1. Generate DDL (for PostgreSQL), the DDL should contain initial values where appropriate, as specified by 'permitted' values in the XSD

2. Generate an ORM that will allow me to perform CRUD operations on the records in the database created in step 1

Can anyone suggest a tool or series of tools/technologies to achieve this?

In case I have to roll my own solution, can someone suggest a good tutorial for XSLT (preferably a cookbook - since I already know some XML/XPath).

Incidentally, I tried xsd.exe on Windows - i开发者_如何学JAVAt failed and printed an error message suggesting that there was a circular reference in the XSD file. I then tried xsd.exe on mono, that worked - but the file created had some invalid statements. I am guessing (perhaps incorrectly) that xsd.exe is NOT the way to achieve these twin goals - if I am wrong, let me know.

Also, I took at Ann Lewkowicz's XSLT transform file to generate a DDL from an XSD file - BUT that appeared to have got stuck in an infinite loop - and also complained about 'infinite recursion'

So I need help with the following:

• First of all, can anyone test/check if the XSD file is indeed screwed up? - and if it is, how to fix it?
• How do I go about generating a DDL and ORM from the XSD file?

Personally I would have written the generator myself. There may be good generators out there, but I haven't seen any. All I've tried using (though I never used an XSD as the starting point) generate terrible code, and worse, are rather impossible to customize to handle every quirk that inevitably turns up.

Doing so is a lot less work than people seem to imagine, and gives many benefits, not least that you'll actually have total control over exactly what is generated. And you could even (and quite easily) take it to the next level and generate the stuff at run-time. The latter is hardly meaningful if the schema is final, but can be a huge time-saver if it's constantly evolving.

I'm quite sure this isn't the answer you were hoping for, and I'd be interested too if anyone knows of good tools for the job.