Browse Site by Tags - CodeSmith Community

Self-referencing FK insert?

I have a table where I want to FK to the table's Primary key (so as to create parent/child relationships among the rows). The problem I have is getting the PK value on insert. I do an DataRepository .MyObjectProvider. Insert(TransactionManager, o_myobject) but obviously get an error when the FK value...

Posted to Community Support (Forum) by MeasuredSpace on 09-21-2007
Filed under: .netTiers, ForeignKeys, primary key

Properly returning TableKeySchema[] for GetTableKeys()

In creating my custom schema provider I used the MySQL provider as a model and saw how that separates immediate file handling (GetMyTableKeys) from related files (GetOtherTableKeys). I'm sure I'm not building the other table keys properly. Can someone confirm if I'm doing this correctly?...

Posted to General (Forum) by CaptainStarbuck on 11-17-2008
Filed under: ForeignKeys, SchemaProvider, primary key, GetTableKeys, TableKeySchema

Exploring recursive relationships with SchemaExplorer

I've got table A which has a ParentID that relates back to it's own ID. How can I use schemaExplorer to discover if a table has a recursive relationship?

Posted to General (Forum) by sam_dlg on 07-17-2008
Filed under: SchemaExplorer, ForeignKeys, primary key, beginner