FK Issue, Order of creation

ServiceStack.OrmLite
1

I need to create about 500 Tables with complex FK. I created the C# classes but the issue is these tables have to be created in a given order (Parent Table needed to be created before child table). Going through 500+ classes and ordering them is going to be time consuming, any other options. ?

2

You can automate ordering. Load all POCO classes via reflection and check recursively if their member has [Reference] attribute. Then get the the type from this attribute and call the check method again. When you meet the type without [Reference] attribute put it to the List<Type> and return. When this algorithm ends you’ll get list of types which are ordered in the way when parent tables go first and child tables go only after parents.

3

Good point. Will do.

4

This is bit more complecated than I thought as I need to develop a proper depdency managment. In short term I am creating the tables with OrmLiteConfig.SkipForeignKeys = true; then running code like

             var sql = "ALTER TABLE[dbo].[FirstChild] DROP CONSTRAINT[FK_TempSales_SalesReason]";
             Console.WriteLine(db.ExecuteSql(sql));

Is this the only way to create / drop FK ?

Jay