CodeSmith Community

Could anyone point me at the template that decides what constitutes a relationship table?

.netTiers works as expected if my relationship tables do not contain their own auto generated primary key. 

However, we have the case where we are linking association tables to association tables, and thus using a surrogate guid pk in all tables, including our relationship tables. 

This appears to make netTiers think our association tables are first class entity tables, and the indirect mappings are not being generated on the first class entity objects, just the properties to get all the corresponding association table rows.

Thanks in advance!

 Derrick

 derrick1298,

It's in here https://nettiers.svn.sourceforge.net/svnroot/nettiers/source/trunk/Source/TemplateLib/CommonSqlCode.cs 

Great, thanks! 

Derrick, were you able to modify this to get the results you wanted? 

 I also have a database that uses surrogate keys in the join tables... Is it really as simple as getting the template to recogize these as many to many relationships?  Does anyone know if the generated code in the service base class would work properly with this modification?  Maybe I'm asking if there are any known issues with doing this, I realize I'd have to test whatever sort of modifications I made to the template

I was able to modify the code in CommonSqlCode.cs so that it recognized my junction tables.  After that some many to many relationships were modeled without issue.  However the template started to crash before it could complete.  I think it had problems generating names for methods.  Anyhow, we have deicided to change our tables so that the FK columns are the PK and we'll just leave the identity column intact.