Conventions and Many To Many Relationships

Hello all,

Sorry to keep hammering the forums with noob questions, but I'm still trying to get my head around all the goodness that is Subsonic. In my database, I have a number of tables that are many-to-many tables. Is there some sort of naming convention that I should be using to make subsonic pick it up automatically?

Thanks,

Will

A few pointers:

1. Each and every table must have a primary key in order for SubSonic to pick it up.
2. Foreign keys should retain the name of their Primary Key name from the source table.
3. Relationships need to be defined in order for SubSonic to pick up on it.
4. Tablenames and columnnames should be singular, preferably without underscores
5. SubSonic works best when each table has a single column primary key.  Compound primary keys in associative entity tables, not so much.  This has been argued to death, but the reality is, single key works, compound keys seem to cause grief.
6. Do not use reserved words from .NET or TSQL/PLSQL/MySQL in the column or tablenames regardless whether you believe it should work.  It probably wont.

There is also a convention for many to many but I don't know if this is required

You call the mapping table the of the two tables and end it with Map

Teacher -> TeacherClassMap <- Class