public static void Initializate(dvdCollectionContext context) { context.Database.EnsureCreated(); // crea bd si no existe if (context.FilmGeneres.Any()) { return; // la bd ya tiene datos } // arreglo del tipo FilmGeneres var FilmGeneres = new FilmGeneres[] { new FilmGeneres { GenreDesc = "Action" }, new FilmGeneres { GenreDesc = "Aventure" }, new FilmGeneres { GenreDesc = "Animation" }, new FilmGeneres { GenreDesc = "Biography" }, new FilmGeneres { GenreDesc = "Comedy" }, new FilmGeneres { GenreDesc = "Crime" }, new FilmGeneres { GenreDesc = "Drama" }, new FilmGeneres { GenreDesc = "Family" }, new FilmGeneres { GenreDesc = "Fantasy" }, new FilmGeneres { GenreDesc = "History" } }; // pasar el arreglo a la tabla de FilmGeneres en el modelo foreach (FilmGeneres g in FilmGeneres) { context.FilmGeneres.Add(g); } //grabar los datos en la bd fisica context.SaveChanges(); }
public static void Initializate(dvdCollectionContext context) { context.Database.EnsureCreated(); //c rea un Bd si no exite if (context.FilmGeneres.Any()) { return; //la base de dats ya tiene datos } // arreglo de tipo film generes var FilmGeneres = new FilmGeneres[] { new FilmGeneres { GenreDesc = "Action" }, new FilmGeneres { GenreDesc = "Aventure" }, new FilmGeneres { GenreDesc = "Animation" }, new FilmGeneres { GenreDesc = "biograpy" }, new FilmGeneres { GenreDesc = "Comedy" }, new FilmGeneres { GenreDesc = "Crime" }, new FilmGeneres { GenreDesc = "Drama" }, new FilmGeneres { GenreDesc = "Family" }, new FilmGeneres { GenreDesc = "Fantasy" }, new FilmGeneres { GenreDesc = "History" } }; foreach (FilmGeneres g in FilmGeneres) { context.FilmGeneres.Add(g); } context.SaveChanges(); }
public static void Initializate(dvdCollectionContext context) { context.Database.EnsureCreated(); // crea bd si no existe if (context.FilmGeneres.Any()) { return; // la bd ya tiene datos } // arreglo del tipo FilmGeneres var FilmGeneres = new FilmGeneres[] { new FilmGeneres { GenreDesc = "Action" }, new FilmGeneres { GenreDesc = "Aventure" }, new FilmGeneres { GenreDesc = "Animation" }, new FilmGeneres { GenreDesc = "Biography" }, new FilmGeneres { GenreDesc = "Comedy" }, new FilmGeneres { GenreDesc = "Crime" }, new FilmGeneres { GenreDesc = "Drama" }, new FilmGeneres { GenreDesc = "Family" }, new FilmGeneres { GenreDesc = "Fantasy" }, new FilmGeneres { GenreDesc = "History" } }; // pasar el arreglo a la tabla de FilmGeneres en el modelo foreach (FilmGeneres g in FilmGeneres) { context.FilmGeneres.Add(g); } //grabar los datos en la bd fisica context.SaveChanges(); // FilmCertificates var FilmCertificates = new FilmCertificates[] { new FilmCertificates { FilmCertificate = "G" }, new FilmCertificates { FilmCertificate = "PG" }, new FilmCertificates { FilmCertificate = "PG-13" }, new FilmCertificates { FilmCertificate = "R" }, new FilmCertificates { FilmCertificate = "NC-17" } }; foreach (FilmCertificates f in FilmCertificates) { context.FilmCertificates.Add(f); } context.SaveChanges(); // Actors var Actors = new Actors[] { new Actors { ActorFullName = "Linda Blair", ActorNotes = "Es una actriz de cine estadounidense internacionalmente conocida por su papel de Regan MacNeil, la niña poseída por un demonio, en la película de terror" }, new Actors { ActorFullName = "Scarlett Johansson", ActorNotes = "es una actriz de cine, cantante y modelo estadounidense que alcanzó la fama con su papel en la película The Horse Whisperer" }, new Actors { ActorFullName = "Keshia Knight Pulliam", ActorNotes = "es una actriz estadounidense. Es conocida por su papel de infancia como Rudy Huxtabl" } }; foreach (Actors a in Actors) { context.Actors.Add(a); } context.SaveChanges(); // RoleTypes var RoleTypes = new RoleTypes[] { new RoleTypes { RoleDesc = "Lead" }, new RoleTypes { RoleDesc = "Principal" }, new RoleTypes { RoleDesc = "Supporting" }, new RoleTypes { RoleDesc = "Featured" }, new RoleTypes { RoleDesc = "Extra" }, }; foreach (RoleTypes r in RoleTypes) { context.RoleTypes.Add(r); } context.SaveChanges(); // Producers var Producers = new Producers[] { new Producers { ProducerName = "Alejandro González Iñárritu", ContactEmailAddress = "*****@*****.**", WebSite = "http://alegon.com" }, new Producers { ProducerName = "Alfonso Cuarón", ContactEmailAddress = "*****@*****.**", WebSite = "http://cuaron.tv " }, new Producers { ProducerName = "Guillermo del Toro", ContactEmailAddress = "*****@*****.**", WebSite = "http://deltoro.com" }, }; foreach (Producers p in Producers) { context.Producers.Add(p); } context.SaveChanges(); // FilmTitles var FilmTitles = new FilmTitles[] { new FilmTitles { FilmTitle = "El laberinto del fauno", FilmCertificateID = 1, FilmGenereID = 1, FilmRelaseDate = DateTime.Parse("1/1/2010"), FilmDuration = 120, FilmStory = "El fauno asusta la niña" } }; foreach (FilmTitles t in FilmTitles) { context.FilmTitles.Add(t); } context.SaveChanges(); }
public static void Initializate(dvdCollectionContext context) { context.Database.EnsureCreated(); // crea bd si no existe if (context.FilmGeneres.Any()) { return; // la bd ya tiene datos } // arreglo del tipo FilmGeneres var FilmGeneres = new FilmGeneres[] { new FilmGeneres { GenereDesc = "Action" }, new FilmGeneres { GenereDesc = "Aventure" }, new FilmGeneres { GenereDesc = "Animation" }, new FilmGeneres { GenereDesc = "Biography" }, new FilmGeneres { GenereDesc = "Comedy" }, new FilmGeneres { GenereDesc = "Crime" }, new FilmGeneres { GenereDesc = "Drama" }, new FilmGeneres { GenereDesc = "Family" }, new FilmGeneres { GenereDesc = "Fantasy" }, new FilmGeneres { GenereDesc = "History" } }; // pasar el arreglo a la tabla de FilmGeneres en el modelo foreach (FilmGeneres g in FilmGeneres) { context.FilmGeneres.Add(g); } //grabar los datos en la bd fisica context.SaveChanges(); // FilmCertificates var FilmCertificates = new FilmCertificates[] { new FilmCertificates { FilmCertificate = "G" }, new FilmCertificates { FilmCertificate = "PG" }, new FilmCertificates { FilmCertificate = "PG-13" }, new FilmCertificates { FilmCertificate = "R" }, new FilmCertificates { FilmCertificate = "NC-17" } }; foreach (FilmCertificates f in FilmCertificates) { context.FilmCertificates.Add(f); } context.SaveChanges(); //actores var Actors = new Actors[] { new Actors { ActorFullName = "Linda Blair", ActorNotes = "algoskdjfkjdkfjklasj;kldjf" }, new Actors { ActorFullName = "Scarlett Johansson", ActorNotes = "dfoskdjfkjdkfjklasj;kldjf" }, new Actors { ActorFullName = "Kesia ", ActorNotes = "dhsjfkasoskdjfkjdkfjklasj;kldjf" } }; foreach (Actors a in Actors) { context.Actors.Add(a); } context.SaveChanges(); //RoleTypes var RoleTypes = new RoleTypes[] { new RoleTypes { RoleDesc = "Lead" }, new RoleTypes { RoleDesc = "Principal " }, new RoleTypes { RoleDesc = "Supportin" }, new RoleTypes { RoleDesc = "Featured" }, new RoleTypes { RoleDesc = "Extra" } }; foreach (RoleTypes r in RoleTypes) { context.RoleTypes.Add(r); } context.SaveChanges(); // Producers var Producers = new Producers[] { new Producers { ProducerName = "Alejandro González Iñárritu", ContactEmailAddress = "*****@*****.**", WebSite = "http://alegon.com" }, new Producers { ProducerName = "Alfonso Cuarón", ContactEmailAddress = "*****@*****.**", WebSite = "http://cuaron.tv " }, new Producers { ProducerName = "Guillermo del Toro", ContactEmailAddress = "*****@*****.**", WebSite = "http://deltoro.com" }, }; foreach (Producers p in Producers) { context.Producers.Add(p); } context.SaveChanges(); // FilmTitles var FilmTitles = new FilmTitles[] { new FilmTitles { FilmTitle = "El laberinto del fauno", FilmCertificateID = 1, FilmGenereID = 1, FilmRelaseDate = DateTime.Parse("1/1/2010"), FilmDuration = 120, FilmStory = "El fauno asusta la niña" } }; foreach (FilmTitles t in FilmTitles) { context.FilmTitles.Add(t); } context.SaveChanges(); }
public static void Initializate(dvdCollectionContext context) { context.Database.EnsureCreated(); // crea bd si no existe if (context.FilmGeneres.Any()) { // la bd ya tiene datos } // arreglo del tipo FilmGeneres var FilmGeneres = new FilmGeneres[] { new FilmGeneres { GenreDesc = "Action" }, new FilmGeneres { GenreDesc = "Aventure" }, new FilmGeneres { GenreDesc = "Animation" }, new FilmGeneres { GenreDesc = "Biography" }, new FilmGeneres { GenreDesc = "Comedy" }, new FilmGeneres { GenreDesc = "Crime" }, new FilmGeneres { GenreDesc = "Drama" }, new FilmGeneres { GenreDesc = "Family" }, new FilmGeneres { GenreDesc = "Fantasy" }, new FilmGeneres { GenreDesc = "History" } }; // pasar el arreglo a la tabla de FilmGeneres en el modelo foreach (FilmGeneres g in FilmGeneres) { context.FilmGeneres.Add(g); } //grabar los datos en la bd fisica context.SaveChanges(); var FilmCertificates = new FilmCertificates[] { new FilmCertificates { FilmCertificate = "G" }, new FilmCertificates { FilmCertificate = "PG" }, new FilmCertificates { FilmCertificate = "R" }, new FilmCertificates { FilmCertificate = "PG-13" } }; foreach (FilmCertificates g in FilmCertificates) { context.FilmCertificates.Add(g); } //grabar los datos en la bd fisica context.SaveChanges(); var Actors = new Actors[] { new Actors { ActorFullName = "Lianda Blair", ActorNotes = "Actriz" }, new Actors { ActorFullName = "Scarlett johansson", ActorNotes = "Actriz" }, new Actors { ActorFullName = "Pam", ActorNotes = "Actriz" } }; foreach (Actors g in Actors) { context.Actors.Add(g); } //grabar los datos en la bd fisica context.SaveChanges(); var RoleTypes = new RoleTypes[] { new RoleTypes { RoleDesc = "Lead" }, new RoleTypes { RoleDesc = "Principal" }, new RoleTypes { RoleDesc = "Supporting" }, new RoleTypes { RoleDesc = "Featured" }, new RoleTypes { RoleDesc = "Extra" }, }; foreach (RoleTypes r in RoleTypes) { context.RoleTypes.Add(r); } context.SaveChanges(); }
public static void Initializate(dvdCollectionContext context) { context.Database.EnsureCreated(); //c rea un Bd si no exite if (context.FilmGeneres.Any()) { return; //la base de dats ya tiene datos } // arreglo de tipo film generes var FilmGeneres = new FilmGeneres[] { new FilmGeneres { GenreDesc = "Action" }, new FilmGeneres { GenreDesc = "Aventure" }, new FilmGeneres { GenreDesc = "Animation" }, new FilmGeneres { GenreDesc = "biograpy" }, new FilmGeneres { GenreDesc = "Comedy" }, new FilmGeneres { GenreDesc = "Crime" }, new FilmGeneres { GenreDesc = "Drama" }, new FilmGeneres { GenreDesc = "Family" }, new FilmGeneres { GenreDesc = "Fantasy" }, new FilmGeneres { GenreDesc = "History" } }; foreach (FilmGeneres g in FilmGeneres) { context.FilmGeneres.Add(g); } context.SaveChanges(); //FilmCertificates var FilmCertificates = new FilmCertificates[] { new FilmCertificates { FilmCertificate = "G" }, new FilmCertificates { FilmCertificate = "PG" }, new FilmCertificates { FilmCertificate = "PG-13" }, new FilmCertificates { FilmCertificate = "R" }, new FilmCertificates { FilmCertificate = "NC-17" } }; foreach (FilmCertificates f in FilmCertificates) { context.FilmCertificates.Add(f); } context.SaveChanges(); //actors var Actors = new Actors[] { new Actors { ActorFullName = "Linda Blair", ActorNotes = "From the age of five, Linda Blair had to get used to the spotlight, first as a child model and then as an actress, when out of 600 applicants she was picked for the role of Regan, the possessed child, in El exorcista (1973)." }, new Actors { ActorFullName = "Scarlett Johansson", ActorNotes = "Scarlett Ingrid Johansson (Nueva York, 22 de noviembre de 1984)4 es una actriz de cine, cantante y modelo estadounidense que alcanzó la fama con su papel en la película The Horse Whisperer (1998) y posteriormente obtuvo la aclamación por parte de los críticos de cine debido a su participación en Ghost World" }, new Actors { ActorFullName = "Keshia Knight Pulliam", ActorNotes = "eshia Knight Pulliam es una actriz estadounidense. Es conocida por su papel de infancia como Rudy Huxtable, el hijo más joven de Cliff y Clair Huxtable con solo 5 a 13 años, en la comedia de la NBC The Cosby Show y como Miranda Lucas-Payne en la comedia dramática de TBS Tyler Perry's House de Payne" } }; foreach (Actors a in Actors) { context.Actors.Add(a); } context.SaveChanges(); //RoleTypes var RolesTypes = new RolesTypes[] { new RolesTypes { RolDesc = "Lead" }, new RolesTypes { RolDesc = "Principal" }, new RolesTypes { RolDesc = "Supporting" }, new RolesTypes { RolDesc = "Fetured" }, new RolesTypes { RolDesc = "Extra" } }; foreach (RolesTypes r in RolesTypes) { context.RoleTypes.Add(r); } context.SaveChanges(); //Producers var Producers = new Producers[] { new Producers { ProducerName = "Alejandro González Iñárritu", ContactEmailAddress = "*****@*****.**", WebSite = "iñarittu.com" }, new Producers { ProducerName = "Alfonso Cuarón", ContactEmailAddress = "*****@*****.**", WebSite = "Cuaron.com" }, new Producers { ProducerName = "Guillermo del Toro Gómez", ContactEmailAddress = "*****@*****.**", WebSite = "gullermito.com" } }; foreach (Producers pr in Producers) { context.Producers.Add(pr); } context.SaveChanges(); //FilmTitles var FilmTitles = new FilmTitles[] { new FilmTitles { FilmTitle = "El laberinto del faulno", FilmCertificateID = 1, FilmGenereID = 1, FilmRelaseDate = DateTime.Parse("1/1/2018"), FilmDuration = 120, FilmStory = "El fauno asusta la niña" } }; foreach (FilmTitles t in FilmTitles) { context.FilmTitles.Add(t); } context.SaveChanges(); }