public static void Seed(ComplexNavigationsContext context)
{
var l1s = ComplexNavigationsData.CreateLevelOnes();
var l2s = ComplexNavigationsData.CreateLevelTwos();
var l3s = ComplexNavigationsData.CreateLevelThrees();
var l4s = ComplexNavigationsData.CreateLevelFours();
context.LevelOne.AddRange(l1s);
ComplexNavigationsData.WireUpPart1(l1s, l2s, l3s, l4s);
context.SaveChanges();
ComplexNavigationsData.WireUpPart2(l1s, l2s, l3s, l4s);
var globalizations = new List <ComplexNavigationGlobalization>();
for (var i = 0; i < 10; i++)
{
var language = new ComplexNavigationLanguage {
Name = "Language" + i, CultureString = "Foo" + i
};
var globalization = new ComplexNavigationGlobalization {
Text = "Globalization" + i, Language = language
};
globalizations.Add(globalization);
context.Languages.Add(language);
context.Globalizations.Add(globalization);
}
var mls1 = new ComplexNavigationString {
DefaultText = "MLS1", Globalizations = globalizations.Take(3).ToList()
};
var mls2 = new ComplexNavigationString {
DefaultText = "MLS2", Globalizations = globalizations.Skip(3).Take(3).ToList()
};
var mls3 = new ComplexNavigationString {
DefaultText = "MLS3", Globalizations = globalizations.Skip(6).Take(3).ToList()
};
var mls4 = new ComplexNavigationString {
DefaultText = "MLS4", Globalizations = globalizations.Skip(9).ToList()
};
context.MultilingualStrings.AddRange(mls1, mls2, mls3, mls4);
var field1 = new ComplexNavigationField {
Name = "Field1", Label = mls1, Placeholder = null
};
var field2 = new ComplexNavigationField {
Name = "Field2", Label = mls3, Placeholder = mls4
};
context.Fields.AddRange(field1, field2);
context.SaveChanges();
}
public static void Seed(ComplexNavigationsContext context)
{
var l1_01 = new Level1 {
Id = 1, Name = "L1 01", Date = new DateTime(2001, 1, 1)
};
var l1_02 = new Level1 {
Id = 2, Name = "L1 02", Date = new DateTime(2002, 2, 2)
};
var l1_03 = new Level1 {
Id = 3, Name = "L1 03", Date = new DateTime(2003, 3, 3)
};
var l1_04 = new Level1 {
Id = 4, Name = "L1 04", Date = new DateTime(2004, 4, 4)
};
var l1_05 = new Level1 {
Id = 5, Name = "L1 05", Date = new DateTime(2005, 5, 5)
};
var l1_06 = new Level1 {
Id = 6, Name = "L1 06", Date = new DateTime(2006, 6, 6)
};
var l1_07 = new Level1 {
Id = 7, Name = "L1 07", Date = new DateTime(2007, 7, 7)
};
var l1_08 = new Level1 {
Id = 8, Name = "L1 08", Date = new DateTime(2008, 8, 8)
};
var l1_09 = new Level1 {
Id = 9, Name = "L1 09", Date = new DateTime(2009, 9, 9)
};
var l1_10 = new Level1 {
Id = 10, Name = "L1 10", Date = new DateTime(2010, 10, 10)
};
var l1_11 = new Level1 {
Id = 11, Name = "L1 11", Date = new DateTime(2009, 11, 11)
};
var l1_12 = new Level1 {
Id = 12, Name = "L1 12", Date = new DateTime(2008, 12, 12)
};
var l1_13 = new Level1 {
Id = 13, Name = "L1 13", Date = new DateTime(2007, 1, 1)
};
var l2_01 = new Level2 {
Id = 1, Name = "L2 01", Date = new DateTime(2010, 10, 10)
};
var l2_02 = new Level2 {
Id = 2, Name = "L2 02", Date = new DateTime(2002, 2, 2)
};
var l2_03 = new Level2 {
Id = 3, Name = "L2 03", Date = new DateTime(2008, 8, 8)
};
var l2_04 = new Level2 {
Id = 4, Name = "L2 04", Date = new DateTime(2004, 4, 4)
};
var l2_05 = new Level2 {
Id = 5, Name = "L2 05", Date = new DateTime(2006, 6, 6)
};
var l2_06 = new Level2 {
Id = 6, Name = "L2 06", Date = new DateTime(2005, 5, 5)
};
var l2_07 = new Level2 {
Id = 7, Name = "L2 07", Date = new DateTime(2007, 7, 7)
};
var l2_08 = new Level2 {
Id = 8, Name = "L2 08", Date = new DateTime(2003, 3, 3)
};
var l2_09 = new Level2 {
Id = 9, Name = "L2 09", Date = new DateTime(2009, 9, 9)
};
var l2_10 = new Level2 {
Id = 10, Name = "L2 10", Date = new DateTime(2001, 1, 1)
};
var l2_11 = new Level2 {
Id = 11, Name = "L2 11", Date = new DateTime(2000, 1, 1)
};
var l3_01 = new Level3 {
Id = 1, Name = "L3 01"
};
var l3_02 = new Level3 {
Id = 2, Name = "L3 02"
};
var l3_03 = new Level3 {
Id = 3, Name = "L3 03"
};
var l3_04 = new Level3 {
Id = 4, Name = "L3 04"
};
var l3_05 = new Level3 {
Id = 5, Name = "L3 05"
};
var l3_06 = new Level3 {
Id = 6, Name = "L3 06"
};
var l3_07 = new Level3 {
Id = 7, Name = "L3 07"
};
var l3_08 = new Level3 {
Id = 8, Name = "L3 08"
};
var l3_09 = new Level3 {
Id = 9, Name = "L3 09"
};
var l3_10 = new Level3 {
Id = 10, Name = "L3 10"
};
var l4_01 = new Level4 {
Id = 1, Name = "L4 01"
};
var l4_02 = new Level4 {
Id = 2, Name = "L4 02"
};
var l4_03 = new Level4 {
Id = 3, Name = "L4 03"
};
var l4_04 = new Level4 {
Id = 4, Name = "L4 04"
};
var l4_05 = new Level4 {
Id = 5, Name = "L4 05"
};
var l4_06 = new Level4 {
Id = 6, Name = "L4 06"
};
var l4_07 = new Level4 {
Id = 7, Name = "L4 07"
};
var l4_08 = new Level4 {
Id = 8, Name = "L4 08"
};
var l4_09 = new Level4 {
Id = 9, Name = "L4 09"
};
var l4_10 = new Level4 {
Id = 10, Name = "L4 10"
};
var l1s = new[] { l1_01, l1_02, l1_03, l1_04, l1_05, l1_06, l1_07, l1_08, l1_09, l1_10, l1_11, l1_12, l1_13 };
var l2s = new[] { l2_01, l2_02, l2_03, l2_04, l2_05, l2_06, l2_07, l2_08, l2_09, l2_10, l2_11 };
var l3s = new[] { l3_01, l3_02, l3_03, l3_04, l3_05, l3_06, l3_07, l3_08, l3_09, l3_10 };
var l4s = new[] { l4_01, l4_02, l4_03, l4_04, l4_05, l4_06, l4_07, l4_08, l4_09, l4_10 };
context.LevelOne.AddRange(l1s);
context.LevelTwo.AddRange(l2s);
context.LevelThree.AddRange(l3s);
context.LevelFour.AddRange(l4s);
l1s[0].OneToOne_Required_PK = l2s[0];
l1s[1].OneToOne_Required_PK = l2s[1];
l1s[2].OneToOne_Required_PK = l2s[2];
l1s[3].OneToOne_Required_PK = l2s[3];
l1s[4].OneToOne_Required_PK = l2s[4];
l1s[5].OneToOne_Required_PK = l2s[5];
l1s[6].OneToOne_Required_PK = l2s[6];
l1s[7].OneToOne_Required_PK = l2s[7];
l1s[8].OneToOne_Required_PK = l2s[8];
l1s[9].OneToOne_Required_PK = l2s[9];
l1s[10].OneToOne_Required_PK = l2s[10];
l1s[0].OneToOne_Required_FK = l2s[9];
l1s[1].OneToOne_Required_FK = l2s[8];
l1s[2].OneToOne_Required_FK = l2s[7];
l1s[3].OneToOne_Required_FK = l2s[6];
l1s[4].OneToOne_Required_FK = l2s[5];
l1s[5].OneToOne_Required_FK = l2s[4];
l1s[6].OneToOne_Required_FK = l2s[3];
l1s[7].OneToOne_Required_FK = l2s[2];
l1s[8].OneToOne_Required_FK = l2s[1];
l1s[9].OneToOne_Required_FK = l2s[0];
l1s[10].OneToOne_Required_FK = l2s[10];
l1s[0].OneToMany_Required = new List <Level2> {
l2s[0], l2s[1], l2s[2], l2s[3], l2s[4], l2s[5], l2s[6], l2s[7], l2s[8], l2s[9], l2s[10]
};
l1s[0].OneToMany_Required_Self = new List <Level1> {
l1s[0], l1s[1], l1s[11]
};
l1s[1].OneToMany_Required_Self = new List <Level1> {
l1s[2], l1s[12]
};
l1s[2].OneToMany_Required_Self = new List <Level1> {
l1s[3]
};
l1s[3].OneToMany_Required_Self = new List <Level1> {
l1s[4]
};
l1s[4].OneToMany_Required_Self = new List <Level1> {
l1s[5]
};
l1s[5].OneToMany_Required_Self = new List <Level1> {
l1s[6]
};
l1s[6].OneToMany_Required_Self = new List <Level1> {
l1s[7]
};
l1s[7].OneToMany_Required_Self = new List <Level1> {
l1s[8]
};
l1s[8].OneToMany_Required_Self = new List <Level1> {
l1s[9]
};
l1s[9].OneToMany_Required_Self = new List <Level1>();
l1s[10].OneToMany_Required_Self = new List <Level1> {
l1s[10]
};
l1s[11].OneToMany_Required_Self = new List <Level1>();
l1s[12].OneToMany_Required_Self = new List <Level1>();
l2s[0].OneToOne_Required_PK = l3s[0];
l2s[1].OneToOne_Required_PK = l3s[1];
l2s[2].OneToOne_Required_PK = l3s[2];
l2s[3].OneToOne_Required_PK = l3s[3];
l2s[4].OneToOne_Required_PK = l3s[4];
l2s[5].OneToOne_Required_PK = l3s[5];
l2s[6].OneToOne_Required_PK = l3s[6];
l2s[7].OneToOne_Required_PK = l3s[7];
l2s[8].OneToOne_Required_PK = l3s[8];
l2s[9].OneToOne_Required_PK = l3s[9];
l2s[0].OneToOne_Required_FK = l3s[9];
l2s[1].OneToOne_Required_FK = l3s[8];
l2s[2].OneToOne_Required_FK = l3s[7];
l2s[3].OneToOne_Required_FK = l3s[6];
l2s[4].OneToOne_Required_FK = l3s[5];
l2s[5].OneToOne_Required_FK = l3s[4];
l2s[6].OneToOne_Required_FK = l3s[3];
l2s[7].OneToOne_Required_FK = l3s[2];
l2s[8].OneToOne_Required_FK = l3s[1];
l2s[9].OneToOne_Required_FK = l3s[0];
l2s[0].OneToMany_Required = new List <Level3> {
l3s[0], l3s[1], l3s[2], l3s[3], l3s[4], l3s[5], l3s[6], l3s[7], l3s[8], l3s[9]
};
l2s[0].OneToMany_Required_Self = new List <Level2> {
l2s[0], l2s[1], l2s[10]
};
l2s[1].OneToMany_Required_Self = new List <Level2> {
l2s[2]
};
l2s[2].OneToMany_Required_Self = new List <Level2> {
l2s[3]
};
l2s[3].OneToMany_Required_Self = new List <Level2> {
l2s[4]
};
l2s[4].OneToMany_Required_Self = new List <Level2> {
l2s[5]
};
l2s[5].OneToMany_Required_Self = new List <Level2> {
l2s[6]
};
l2s[6].OneToMany_Required_Self = new List <Level2> {
l2s[7]
};
l2s[7].OneToMany_Required_Self = new List <Level2> {
l2s[8]
};
l2s[8].OneToMany_Required_Self = new List <Level2> {
l2s[9]
};
l2s[9].OneToMany_Required_Self = new List <Level2>();
l2s[10].OneToMany_Required_Self = new List <Level2>();
l3s[0].OneToOne_Required_PK = l4s[0];
l3s[1].OneToOne_Required_PK = l4s[1];
l3s[2].OneToOne_Required_PK = l4s[2];
l3s[3].OneToOne_Required_PK = l4s[3];
l3s[4].OneToOne_Required_PK = l4s[4];
l3s[5].OneToOne_Required_PK = l4s[5];
l3s[6].OneToOne_Required_PK = l4s[6];
l3s[7].OneToOne_Required_PK = l4s[7];
l3s[8].OneToOne_Required_PK = l4s[8];
l3s[9].OneToOne_Required_PK = l4s[9];
l3s[0].OneToOne_Required_FK = l4s[9];
l3s[1].OneToOne_Required_FK = l4s[8];
l3s[2].OneToOne_Required_FK = l4s[7];
l3s[3].OneToOne_Required_FK = l4s[6];
l3s[4].OneToOne_Required_FK = l4s[5];
l3s[5].OneToOne_Required_FK = l4s[4];
l3s[6].OneToOne_Required_FK = l4s[3];
l3s[7].OneToOne_Required_FK = l4s[2];
l3s[8].OneToOne_Required_FK = l4s[1];
l3s[9].OneToOne_Required_FK = l4s[0];
l3s[0].OneToMany_Required = new List <Level4> {
l4s[0], l4s[1], l4s[2], l4s[3], l4s[4], l4s[5], l4s[6], l4s[7], l4s[8], l4s[9]
};
l3s[0].OneToMany_Required_Self = new List <Level3> {
l3s[0], l3s[1]
};
l3s[1].OneToMany_Required_Self = new List <Level3> {
l3s[2]
};
l3s[2].OneToMany_Required_Self = new List <Level3> {
l3s[3]
};
l3s[3].OneToMany_Required_Self = new List <Level3> {
l3s[4]
};
l3s[4].OneToMany_Required_Self = new List <Level3> {
l3s[5]
};
l3s[5].OneToMany_Required_Self = new List <Level3> {
l3s[6]
};
l3s[6].OneToMany_Required_Self = new List <Level3> {
l3s[7]
};
l3s[7].OneToMany_Required_Self = new List <Level3> {
l3s[8]
};
l3s[8].OneToMany_Required_Self = new List <Level3> {
l3s[9]
};
l3s[9].OneToMany_Required_Self = new List <Level3>();
l4s[0].OneToMany_Required_Self = new List <Level4> {
l4s[0], l4s[1]
};
l4s[1].OneToMany_Required_Self = new List <Level4> {
l4s[2]
};
l4s[2].OneToMany_Required_Self = new List <Level4> {
l4s[3]
};
l4s[3].OneToMany_Required_Self = new List <Level4> {
l4s[4]
};
l4s[4].OneToMany_Required_Self = new List <Level4> {
l4s[5]
};
l4s[5].OneToMany_Required_Self = new List <Level4> {
l4s[6]
};
l4s[6].OneToMany_Required_Self = new List <Level4> {
l4s[7]
};
l4s[7].OneToMany_Required_Self = new List <Level4> {
l4s[8]
};
l4s[8].OneToMany_Required_Self = new List <Level4> {
l4s[9]
};
l4s[9].OneToMany_Required_Self = new List <Level4>();
context.SaveChanges();
l1s[0].OneToOne_Optional_PK = l2s[0];
l1s[2].OneToOne_Optional_PK = l2s[2];
l1s[4].OneToOne_Optional_PK = l2s[4];
l1s[6].OneToOne_Optional_PK = l2s[6];
l1s[8].OneToOne_Optional_PK = l2s[8];
l1s[1].OneToOne_Optional_FK = l2s[8];
l1s[3].OneToOne_Optional_FK = l2s[6];
l1s[5].OneToOne_Optional_FK = l2s[4];
l1s[7].OneToOne_Optional_FK = l2s[2];
l1s[9].OneToOne_Optional_FK = l2s[0];
l1s[0].OneToMany_Optional = new List <Level2> {
l2s[1], l2s[3], l2s[5], l2s[7], l2s[9]
};
l1s[1].OneToMany_Optional_Self = new List <Level1> {
l1s[0]
};
l1s[3].OneToMany_Optional_Self = new List <Level1> {
l1s[2]
};
l1s[5].OneToMany_Optional_Self = new List <Level1> {
l1s[4]
};
l1s[7].OneToMany_Optional_Self = new List <Level1> {
l1s[6]
};
l1s[9].OneToMany_Optional_Self = new List <Level1> {
l1s[8]
};
l1s[0].OneToOne_Optional_Self = l1s[9];
l1s[1].OneToOne_Optional_Self = l1s[8];
l1s[2].OneToOne_Optional_Self = l1s[7];
l1s[3].OneToOne_Optional_Self = l1s[6];
l1s[4].OneToOne_Optional_Self = l1s[5];
l2s[0].OneToOne_Optional_PK = l3s[0];
l2s[2].OneToOne_Optional_PK = l3s[2];
l2s[5].OneToOne_Optional_PK = l3s[4];
l2s[7].OneToOne_Optional_PK = l3s[6];
l2s[9].OneToOne_Optional_PK = l3s[8];
l2s[1].OneToOne_Optional_FK = l3s[8];
l2s[3].OneToOne_Optional_FK = l3s[6];
l2s[4].OneToOne_Optional_FK = l3s[4];
l2s[6].OneToOne_Optional_FK = l3s[2];
l2s[8].OneToOne_Optional_FK = l3s[0];
l2s[0].OneToMany_Optional = new List <Level3> {
l3s[1], l3s[5], l3s[9]
};
l2s[1].OneToMany_Optional = new List <Level3> {
l3s[3], l3s[7]
};
l2s[1].OneToMany_Optional_Self = new List <Level2> {
l2s[0]
};
l2s[3].OneToMany_Optional_Self = new List <Level2> {
l2s[2]
};
l2s[5].OneToMany_Optional_Self = new List <Level2> {
l2s[4]
};
l2s[7].OneToMany_Optional_Self = new List <Level2> {
l2s[6]
};
l2s[9].OneToMany_Optional_Self = new List <Level2> {
l2s[8]
};
l2s[0].OneToOne_Optional_Self = l2s[9];
l2s[1].OneToOne_Optional_Self = l2s[8];
l2s[2].OneToOne_Optional_Self = l2s[7];
l2s[3].OneToOne_Optional_Self = l2s[6];
l2s[4].OneToOne_Optional_Self = l2s[5];
l3s[0].OneToOne_Optional_PK = l4s[0];
l3s[2].OneToOne_Optional_PK = l4s[2];
l3s[4].OneToOne_Optional_PK = l4s[4];
l3s[6].OneToOne_Optional_PK = l4s[6];
l3s[8].OneToOne_Optional_PK = l4s[8];
l3s[1].OneToOne_Optional_FK = l4s[8];
l3s[3].OneToOne_Optional_FK = l4s[6];
l3s[5].OneToOne_Optional_FK = l4s[4];
l3s[7].OneToOne_Optional_FK = l4s[2];
l3s[9].OneToOne_Optional_FK = l4s[0];
l3s[0].OneToMany_Optional = new List <Level4> {
l4s[1], l4s[3], l4s[5], l4s[7], l4s[9]
};
l3s[1].OneToMany_Optional_Self = new List <Level3> {
l3s[0]
};
l3s[3].OneToMany_Optional_Self = new List <Level3> {
l3s[2]
};
l3s[5].OneToMany_Optional_Self = new List <Level3> {
l3s[4]
};
l3s[7].OneToMany_Optional_Self = new List <Level3> {
l3s[6]
};
l3s[9].OneToMany_Optional_Self = new List <Level3> {
l3s[8]
};
l3s[0].OneToOne_Optional_Self = l3s[9];
l3s[1].OneToOne_Optional_Self = l3s[8];
l3s[2].OneToOne_Optional_Self = l3s[7];
l3s[3].OneToOne_Optional_Self = l3s[6];
l3s[4].OneToOne_Optional_Self = l3s[5];
l4s[1].OneToMany_Optional_Self = new List <Level4> {
l4s[0]
};
l4s[3].OneToMany_Optional_Self = new List <Level4> {
l4s[2]
};
l4s[5].OneToMany_Optional_Self = new List <Level4> {
l4s[4]
};
l4s[7].OneToMany_Optional_Self = new List <Level4> {
l4s[6]
};
l4s[9].OneToMany_Optional_Self = new List <Level4> {
l4s[8]
};
context.SaveChanges();
for (var i = 0; i < 10; i++)
{
var language = new ComplexNavigationLanguage {
Name = "Language" + i, CultureString = "Foo" + i
};
context.Languages.Add(language);
}
context.SaveChanges();
var ii = 0;
foreach (var l in context.Languages)
{
var globalization = new ComplexNavigationGlobalization {
Text = "Globalization" + ii, Language = l
};
ii++;
context.Globalizations.Add(globalization);
}
context.SaveChanges();
var globalizations = context.Globalizations.ToList();
var mls1 = new ComplexNavigationString {
DefaultText = "MLS1", Globalizations = globalizations.Take(3).ToList()
};
var mls2 = new ComplexNavigationString {
DefaultText = "MLS2", Globalizations = globalizations.Skip(3).Take(3).ToList()
};
var mls3 = new ComplexNavigationString {
DefaultText = "MLS3", Globalizations = globalizations.Skip(6).Take(3).ToList()
};
var mls4 = new ComplexNavigationString {
DefaultText = "MLS4", Globalizations = globalizations.Skip(9).ToList()
};
context.MultilingualStrings.AddRange(mls1, mls2, mls3, mls4);
context.SaveChanges();
var field1 = new ComplexNavigationField {
Name = "Field1", Label = mls1, Placeholder = null
};
var field2 = new ComplexNavigationField {
Name = "Field2", Label = mls3, Placeholder = mls4
};
context.Fields.AddRange(field1, field2);
context.SaveChanges();
}