I'll keep this brief because I want to make sure I beat Rob to check-in so that he's the one who has to deal with the merge issues... :)

In addition to a few important bug fixes, this change set rounds out CRUD support for composite keys. Update and Delete operations are now possible, with big thanks to Jason Kealy for finding a nice, contained way to address this. In addition, there is now a property on TableSchema called PrimaryKeys, which exposes, well, exactly what you'd expect.

Thanks as well go to Jim Shelly, who provided us with an improved query for extracting Many-to-Many tables from INFORMATION_SCHEMA, eliminating a column number dependency. With this as a base, I adjusted the M2M templates to support variable column counts. Hopefully we'll be able to put M2M to bed for a while...

Finally, continued thanks go to Brenton Webster, who updated the DTC-Free transactions tests. Until we get these documented, TransactionWithDtcOffTests.cs is the best place to see how to use this really cool piece of functionality...

Fixes

• Work Item 6267 - Add Support for composite keys
• Work Item 9736 - AutoScaffold: Should not show edit on composite key
• Work Item 9873 - Bug: property name instead of column name in columns struct
• Work Item 9899 - Error with nullable type of decimal
• Work Item 9906 - TransactionScope does not roll back w/out DTC

Download