public static void Load() { var ama = new AmericanMusicAwardEntity { Category = "Indie Rock", Year = 1991, Result = AwardResult.Nominated } .Execute(AwardOperation.Save); BandEntity smashingPumpkins = new BandEntity { Name = "Smashing Pumpkins", Members = "Billy Corgan, James Iha, D'arcy Wretzky, Jimmy Chamberlin" .Split(',').Select(s => new ArtistEntity { Name = s.Trim(), Sex = s.Contains("Wretzky") ? Sex.Female : Sex.Male, Status = s.Contains("Wretzky") ? Status.Married : (Status?)null }).ToMList(), LastAward = ama, }.Execute(BandOperation.Save); CountryEntity usa = new CountryEntity { Name = "USA" }; CountryEntity japan = new CountryEntity { Name = Japan }; smashingPumpkins.Members.ForEach(m => m.Friends = smashingPumpkins.Members.Where(a => a.Sex != m.Sex).Select(a => a.ToLiteFat()).ToMList()); smashingPumpkins.Execute(BandOperation.Save); new NoteWithDateEntity { CreationTime = DateTime.Now.AddHours(+8), CreationDate = (Date)DateTime.Now.AddHours(+8), Text = "American alternative rock band", Target = smashingPumpkins } .Execute(NoteWithDateOperation.Save); LabelEntity virgin = new LabelEntity { Name = "Virgin", Country = usa, Node = SqlHierarchyId.GetRoot().FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Siamese Dream", Year = 1993, Author = smashingPumpkins, Songs = { new SongEmbedded { Name = "Disarm" } }, Label = virgin }.Execute(AlbumOperation.Save); AlbumEntity mellon = new AlbumEntity { Name = "Mellon Collie and the Infinite Sadness", Year = 1995, Author = smashingPumpkins, Songs = { new SongEmbedded { Name = "Zero", Duration = TimeSpan.FromSeconds(123) }, new SongEmbedded { Name = "1976" }, new SongEmbedded { Name = "Tonight, Tonight", Duration = TimeSpan.FromSeconds(376) } }, BonusTrack = new SongEmbedded { Name = "Jellybelly" }, Label = virgin }.Execute(AlbumOperation.Save); new NoteWithDateEntity { CreationTime = DateTime.Now.AddDays(-100).AddHours(-8), CreationDate = (Date)DateTime.Now.AddDays(-100).AddHours(-8), Text = "The blue one with the angel", Target = mellon } .Execute(NoteWithDateOperation.Save); LabelEntity wea = new LabelEntity { Name = "WEA International", Country = usa, Owner = virgin.ToLite(), Node = virgin.Node.FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Zeitgeist", Year = 2007, Author = smashingPumpkins, Songs = { new SongEmbedded { Name = "Tarantula" } }, BonusTrack = new SongEmbedded { Name = "1976" }, Label = wea, }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "American Gothic", Year = 2008, Author = smashingPumpkins, Songs = { new SongEmbedded { Name = "The Rose March", Duration = TimeSpan.FromSeconds(276) } }, Label = wea, }.Execute(AlbumOperation.Save); var pa = new PersonalAwardEntity { Category = "Best Artist", Year = 1983, Result = AwardResult.Won }.Execute(AwardOperation.Save); ArtistEntity michael = new ArtistEntity { Name = "Michael Jackson", Dead = true, LastAward = pa, Status = Status.Single, Friends = { smashingPumpkins.Members.SingleEx(a => a.Name.Contains("Billy Corgan")).ToLite() } }.Execute(ArtistOperation.Save);; new NoteWithDateEntity { CreationTime = new DateTime(2009, 6, 25, 0, 0, 0), CreationDate = new Date(2009, 6, 25), Text = "Death on June, 25th", Target = michael } .Execute(NoteWithDateOperation.Save); new NoteWithDateEntity { CreationTime = new DateTime(2000, 1, 1, 0, 0, 0), CreationDate = new Date(2000, 1, 1), Text = null !, Target = michael }
public static void Load() { var ama = new AmericanMusicAwardEntity { Category = "Indie Rock", Year = 1991, Result = AwardResult.Nominated } .Execute(AwardOperation.Save); BandEntity smashingPumpkins = new BandEntity { Name = "Smashing Pumpkins", Members = "Billy Corgan, James Iha, D'arcy Wretzky, Jimmy Chamberlin" .Split(',').Select(s => new ArtistEntity { Name = s.Trim(), Sex = s.Contains("Wretzky") ? Sex.Female : Sex.Male, Status = s.Contains("Wretzky") ? Status.Married : (Status?)null }).ToMList(), LastAward = ama, }.Execute(BandOperation.Save); CountryEntity usa = new CountryEntity { Name = "USA" }; CountryEntity japan = new CountryEntity { Name = Japan }; smashingPumpkins.Members.ForEach(m => m.Friends = smashingPumpkins.Members.Where(a => a.Sex != m.Sex).Select(a => a.ToLiteFat()).ToMList()); smashingPumpkins.Execute(BandOperation.Save); new NoteWithDateEntity { CreationTime = DateTime.Now.AddHours(+8), Text = "American alternative rock band", Target = smashingPumpkins } .Execute(NoteWithDateOperation.Save); LabelEntity virgin = new LabelEntity { Name = "Virgin", Country = usa, Node = SqlHierarchyId.GetRoot().FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Siamese Dream", Year = 1993, Author = smashingPumpkins, Songs = { new SongEmbedded { Name = "Disarm" } }, Label = virgin }.Execute(AlbumOperation.Save); AlbumEntity mellon = new AlbumEntity { Name = "Mellon Collie and the Infinite Sadness", Year = 1995, Author = smashingPumpkins, Songs = { new SongEmbedded { Name = "Zero", Duration = TimeSpan.FromSeconds(123) }, new SongEmbedded { Name = "1976" }, new SongEmbedded { Name = "Tonight, Tonight", Duration = TimeSpan.FromSeconds(376) } }, BonusTrack = new SongEmbedded { Name = "Jellybelly" }, Label = virgin }.Execute(AlbumOperation.Save); new NoteWithDateEntity { CreationTime = DateTime.Now.AddDays(-100).AddHours(-8), Text = "The blue one with the angel", Target = mellon } .Execute(NoteWithDateOperation.Save); LabelEntity wea = new LabelEntity { Name = "WEA International", Country = usa, Owner = virgin.ToLite(), Node = virgin.Node.FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Zeitgeist", Year = 2007, Author = smashingPumpkins, Songs = { new SongEmbedded { Name = "Tarantula" } }, BonusTrack = new SongEmbedded { Name = "1976" }, Label = wea, }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "American Gothic", Year = 2008, Author = smashingPumpkins, Songs = { new SongEmbedded { Name = "The Rose March", Duration = TimeSpan.FromSeconds(276) } }, Label = wea, }.Execute(AlbumOperation.Save); var pa = new PersonalAwardEntity { Category = "Best Artist", Year = 1983, Result = AwardResult.Won }.Execute(AwardOperation.Save); ArtistEntity michael = new ArtistEntity { Name = "Michael Jackson", Dead = true, LastAward = pa, Status = Status.Single, Friends = { smashingPumpkins.Members.SingleEx(a => a.Name.Contains("Billy Corgan")).ToLite() } }.Execute(ArtistOperation.Save);; new NoteWithDateEntity { CreationTime = new DateTime(2009, 6, 25, 0, 0, 0), Text = "Death on June, 25th", Target = michael } .Execute(NoteWithDateOperation.Save); new NoteWithDateEntity { CreationTime = new DateTime(2000, 1, 1, 0, 0, 0), Text = null, Target = michael } .SetMixin((CorruptMixin c) => c.Corrupt, true) .Do(n => n.Mixin <ColaboratorsMixin>().Colaborators.Add(michael)) .Execute(NoteWithDateOperation.Save); LabelEntity universal = new LabelEntity { Name = "UMG Recordings", Country = usa, Node = virgin.Node.NextSibling() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Ben", Year = 1972, Author = michael, Songs = { new SongEmbedded { Name = "Ben" } }, BonusTrack = new SongEmbedded { Name = "Michael" }, Label = universal, }.Execute(AlbumOperation.Save); LabelEntity sony = new LabelEntity { Name = "Sony", Country = japan, Node = universal.Node.NextSibling() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Thriller", Year = 1982, Author = michael, Songs = "Wanna Be Startin' Somethin', Thriller, Beat It" .Split(',').Select(s => new SongEmbedded { Name = s.Trim() }).ToMList(), BonusTrack = new SongEmbedded { Name = "Billie Jean" }, Label = sony }.Execute(AlbumOperation.Save); LabelEntity mjj = new LabelEntity { Name = "MJJ", Country = usa, Owner = sony.ToLite(), Node = sony.Node.FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Bad", Year = 1989, Author = michael, Songs = "Bad, Man in the Mirror, Dirty Diana, Smooth Criminal" .Split(',').Select(s => new SongEmbedded { Name = s.Trim() }).ToMList(), Label = mjj }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "Dangerous", Year = 1991, Author = michael, Songs = "Black or White, Who Is It, Give it to Me" .Split(',').Select(s => new SongEmbedded { Name = s.Trim() }).ToMList(), Label = mjj }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "HIStory", Year = 1995, Author = michael, Songs = "Billie Jean, Stranger In Moscow" .Split(',').Select(s => new SongEmbedded { Name = s.Trim() }).ToMList(), BonusTrack = new SongEmbedded { Name = "Heal The World" }, Label = mjj }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "Blood on the Dance Floor", Year = 1995, Author = michael, Songs = "Blood on the Dance Floor, Morphine" .Split(',').Select(s => new SongEmbedded { Name = s.Trim() }).ToMList(), Label = mjj }.Execute(AlbumOperation.Save);; var ga = (GrammyAwardEntity) new GrammyAwardEntity { Category = "Foreing Band", Year = 2001, Result = AwardResult.Won } .Execute(AwardOperation.Save); BandEntity sigurRos = new BandEntity { Name = "Sigur Ros", Members = "Jón Þór Birgisson, Georg Hólm, Orri Páll Dýrason" .Split(',').Select(s => new ArtistEntity { Name = s.Trim() }.Execute(ArtistOperation.Save)).ToMList(), LastAward = ga, }.Execute(BandOperation.Save); LabelEntity fatCat = new LabelEntity { Name = "FatCat Records", Country = usa, Owner = universal.ToLite(), Node = universal.Node.FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Ágaetis byrjun", Year = 1999, Author = sigurRos, Songs = "Scefn-g-englar" .Split(',').Select(s => new SongEmbedded { Name = s.Trim() }).ToMList(), BonusTrack = new SongEmbedded { Name = "Intro" }, Label = fatCat, }.Execute(AlbumOperation.Save); LabelEntity emi = new LabelEntity { Name = "EMI", Country = usa, Node = sony.Node.NextSibling() }.Execute(LabelOperation.Save); new AlbumEntity { Name = "Takk...", Year = 2005, Author = sigurRos, Songs = "Hoppípolla, Glósóli, Saeglópur" .Split(',').Select(s => new SongEmbedded { Name = s.Trim() }).ToMList(), BonusTrack = new SongEmbedded { Name = "Svo hljótt" }, Label = emi }.Execute(AlbumOperation.Save); new AwardNominationEntity { Author = sigurRos.ToLite(), Award = ga.ToLite() }.Save(); new AwardNominationEntity { Author = michael.ToLite(), Award = ga.ToLite() }.Save(); new AwardNominationEntity { Author = smashingPumpkins.ToLite(), Award = ga.ToLite() }.Save(); new AwardNominationEntity { Author = sigurRos.ToLite(), Award = ama.ToLite() }.Save(); new AwardNominationEntity { Author = michael.ToLite(), Award = ama.ToLite() }.Save(); new AwardNominationEntity { Author = smashingPumpkins.ToLite(), Award = ama.ToLite() }.Save(); new AwardNominationEntity { Author = michael.ToLite(), Award = pa.ToLite() }.Save(); new AwardNominationEntity { Author = michael.ToLite(), Award = null }.Save(); new ConfigEntity { EmbeddedConfig = new EmbeddedConfigEmbedded { Awards = { ga.ToLite() } } }.Execute(ConfigOperation.Save); }
public static void Load() { var ama = new AmericanMusicAwardEntity { Category = "Indie Rock", Year = 1991, Result = AwardResult.Nominated } .Execute(AwardOperation.Save); BandEntity smashingPumpkins = new BandEntity { Name = "Smashing Pumpkins", Members = "Billy Corgan, James Iha, D'arcy Wretzky, Jimmy Chamberlin" .Split(',').Select(s => new ArtistEntity { Name = s.Trim(), Sex = s.Contains("Wretzky") ? Sex.Female : Sex.Male, Status = s.Contains("Wretzky") ? Status.Married : (Status?)null }).ToMList(), LastAward = ama, }.Execute(BandOperation.Save); CountryEntity usa = new CountryEntity { Name = "USA" }; CountryEntity japan = new CountryEntity { Name = Japan }; smashingPumpkins.Members.ForEach(m => m.Friends = smashingPumpkins.Members.Where(a => a.Sex != m.Sex).Select(a => a.ToLiteFat()).ToMList()); smashingPumpkins.Execute(BandOperation.Save); new NoteWithDateEntity { CreationTime = DateTime.Now.AddHours(+8), Text = "American alternative rock band", Target = smashingPumpkins } .Execute(NoteWithDateOperation.Save); LabelEntity virgin = new LabelEntity { Name = "Virgin", Country = usa, Node = SqlHierarchyId.GetRoot().FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Siamese Dream", Year = 1993, Author = smashingPumpkins, Songs = { new SongEntity { Name = "Disarm" } }, Label = virgin }.Execute(AlbumOperation.Save); AlbumEntity mellon = new AlbumEntity { Name = "Mellon Collie and the Infinite Sadness", Year = 1995, Author = smashingPumpkins, Songs = { new SongEntity { Name = "Zero", Duration = TimeSpan.FromSeconds(123) }, new SongEntity { Name = "1976" }, new SongEntity { Name = "Tonight, Tonight", Duration = TimeSpan.FromSeconds(376) } }, BonusTrack = new SongEntity { Name = "Jellybelly" }, Label = virgin }.Execute(AlbumOperation.Save); new NoteWithDateEntity { CreationTime = DateTime.Now.AddDays(-100).AddHours(-8), Text = "The blue one with the angel", Target = mellon } .Execute(NoteWithDateOperation.Save); LabelEntity wea = new LabelEntity { Name = "WEA International", Country = usa, Owner = virgin.ToLite(), Node = virgin.Node.FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Zeitgeist", Year = 2007, Author = smashingPumpkins, Songs = { new SongEntity { Name = "Tarantula" } }, BonusTrack = new SongEntity { Name = "1976" }, Label = wea, }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "American Gothic", Year = 2008, Author = smashingPumpkins, Songs = { new SongEntity { Name = "The Rose March", Duration = TimeSpan.FromSeconds(276) } }, Label = wea, }.Execute(AlbumOperation.Save); var pa = new PersonalAwardEntity { Category = "Best Artist", Year = 1983, Result = AwardResult.Won }.Execute(AwardOperation.Save); ArtistEntity michael = new ArtistEntity { Name = "Michael Jackson", Dead = true, LastAward = pa, Status = Status.Single, Friends = { smashingPumpkins.Members.SingleEx(a=>a.Name.Contains("Billy Corgan")).ToLite() } }.Execute(ArtistOperation.Save); ; new NoteWithDateEntity { CreationTime = new DateTime(2009, 6, 25, 0, 0, 0), Text = "Death on June, 25th", Target = michael } .Execute(NoteWithDateOperation.Save); new NoteWithDateEntity { CreationTime = new DateTime(2000, 1, 1, 0, 0, 0), Text = null, Target = michael } .SetMixin((CorruptMixin c) => c.Corrupt, true) .Do(n => n.Mixin<ColaboratorsMixin>().Colaborators.Add(michael)) .Execute(NoteWithDateOperation.Save); LabelEntity universal = new LabelEntity { Name = "UMG Recordings", Country = usa, Node = virgin.Node.NextSibling() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Ben", Year = 1972, Author = michael, Songs = { new SongEntity { Name = "Ben" } }, BonusTrack = new SongEntity { Name = "Michael" }, Label = universal, }.Execute(AlbumOperation.Save); LabelEntity sony = new LabelEntity { Name = "Sony", Country = japan, Node = universal.Node.NextSibling() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Thriller", Year = 1982, Author = michael, Songs = "Wanna Be Startin' Somethin', Thriller, Beat It" .Split(',').Select(s => new SongEntity { Name = s.Trim() }).ToMList(), BonusTrack = new SongEntity { Name = "Billie Jean" }, Label = sony }.Execute(AlbumOperation.Save); LabelEntity mjj = new LabelEntity { Name = "MJJ", Country = usa, Owner = sony.ToLite(), Node = sony.Node.FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Bad", Year = 1989, Author = michael, Songs = "Bad, Man in the Mirror, Dirty Diana, Smooth Criminal" .Split(',').Select(s => new SongEntity { Name = s.Trim() }).ToMList(), Label = mjj }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "Dangerous", Year = 1991, Author = michael, Songs = "Black or White, Who Is It, Give it to Me" .Split(',').Select(s => new SongEntity { Name = s.Trim() }).ToMList(), Label = mjj }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "HIStory", Year = 1995, Author = michael, Songs = "Billie Jean, Stranger In Moscow" .Split(',').Select(s => new SongEntity { Name = s.Trim() }).ToMList(), BonusTrack = new SongEntity { Name = "Heal The World" }, Label = mjj }.Execute(AlbumOperation.Save); new AlbumEntity { Name = "Blood on the Dance Floor", Year = 1995, Author = michael, Songs = "Blood on the Dance Floor, Morphine" .Split(',').Select(s => new SongEntity { Name = s.Trim() }).ToMList(), Label = mjj }.Execute(AlbumOperation.Save); ; var ga = (GrammyAwardEntity)new GrammyAwardEntity { Category = "Foreing Band", Year = 2001, Result = AwardResult.Won } .Execute(AwardOperation.Save); BandEntity sigurRos = new BandEntity { Name = "Sigur Ros", Members = "Jón Þór Birgisson, Georg Hólm, Orri Páll Dýrason" .Split(',').Select(s => new ArtistEntity { Name = s.Trim() }.Execute(ArtistOperation.Save)).ToMList(), LastAward = ga, }.Execute(BandOperation.Save); LabelEntity fatCat = new LabelEntity { Name = "FatCat Records", Country = usa, Owner = universal.ToLite(), Node = universal.Node.FirstChild() } .Execute(LabelOperation.Save); new AlbumEntity { Name = "Ágaetis byrjun", Year = 1999, Author = sigurRos, Songs = "Scefn-g-englar" .Split(',').Select(s => new SongEntity { Name = s.Trim() }).ToMList(), BonusTrack = new SongEntity { Name = "Intro" }, Label = fatCat, }.Execute(AlbumOperation.Save); LabelEntity emi = new LabelEntity { Name = "EMI", Country = usa, Node = sony.Node.NextSibling() }.Execute(LabelOperation.Save); new AlbumEntity { Name = "Takk...", Year = 2005, Author = sigurRos, Songs = "Hoppípolla, Glósóli, Saeglópur" .Split(',').Select(s => new SongEntity { Name = s.Trim() }).ToMList(), BonusTrack = new SongEntity { Name = "Svo hljótt" }, Label = emi }.Execute(AlbumOperation.Save); new AwardNominationEntity { Author = sigurRos.ToLite(), Award = ga.ToLite() }.Save(); new AwardNominationEntity { Author = michael.ToLite(), Award = ga.ToLite() }.Save(); new AwardNominationEntity { Author = smashingPumpkins.ToLite(), Award = ga.ToLite() }.Save(); new AwardNominationEntity { Author = sigurRos.ToLite(), Award = ama.ToLite() }.Save(); new AwardNominationEntity { Author = michael.ToLite(), Award = ama.ToLite() }.Save(); new AwardNominationEntity { Author = smashingPumpkins.ToLite(), Award = ama.ToLite() }.Save(); new AwardNominationEntity { Author = michael.ToLite(), Award = pa.ToLite() }.Save(); new AwardNominationEntity { Author = michael.ToLite(), Award = null}.Save(); new ConfigEntity { EmbeddedConfig = new EmbeddedConfigEntity { Awards = { ga.ToLite() } } }.Execute(ConfigOperation.Save); }