This project is read-only.

Needing help understanding the database structure

Topics: Troubleshooting
Nov 30, 2012 at 10:08 AM
Edited Nov 30, 2012 at 10:09 AM


SysCache seems to have broken my taxonmy tables, I am getting exceptions when trying to modify taxonomies or a query using taxonomy field as filter.

As I have already dozens of contents created using taxonomies, I will try to repair the database where seems that a record is missing.

New to Orchard, I am not used to NHibernate but fluent on SLQ Server.

Before diving into the code, I would appreciate some indications on the place where I could find the information used by NHibernate to create tables and links between these tables.


From a first look, I see that NHibernate does not generate external keys to link tables ? 

Is there any naming convention in the column names which could also help in relating tables ?


Thanks for help.


Nov 30, 2012 at 5:20 PM

That information, including instructions to create foreign keys, can be found in Migrations.cs files.

Nov 30, 2012 at 6:11 PM

Finally I found a small bug in Taxonomies' TermPart.cs and reported it.