private static async Task PopulateDatabase(QuotableContext context) { var dataset1 = new QuoteAuthor() { Quote = new Quote("To be or not to be.", "William Shakespeare"), Author = new Author("William", "Shakespeare") }; var dataset2 = new QuoteAuthor() { Quote = new Quote("So many books, so little time.", "Frank Zappa"), Author = new Author("Frank", "Zappa") }; var dataset3 = new QuoteAuthor() { Quote = new Quote("Be the change you wish in the world.", "Mahatma Gandhi"), Author = new Author("Mahatma", "Gandhi") }; var dataset4 = new QuoteAuthor() { Quote = new Quote("If you tell the truth, you don't have to remember anything.", "Mark Twain"), Author = new Author("Mark", "Twain") }; var dataset5 = new QuoteAuthor() { Quote = new Quote("Without music, life would be a mistake.", "Friedrich Nietzsche"), Author = new Author("Friedrich", "Nietzsche") }; var dataset6 = new QuoteAuthor() { Quote = new Quote("We accept the love we think we deserve.", "Stephen Chbosky"), Author = new Author("Stephen", "Chbosky") }; var dataset7 = new QuoteAuthor() { Quote = new Quote("The man who does not read has no advantage over the man who cannot read.", "Mark Twain"), Author = new Author("Mark", "Twain") }; context.AddRange(dataset1, dataset2, dataset3, dataset4, dataset5, dataset6, dataset7); await context.SaveChangesAsync(); }
/// <summary> /// Creating database table /// </summary> /// <param name="context"></param> private static void PopulateDatabase(QuoteContext context) { var author1 = new Author() { name = "Danny Pham" }; var author2 = new Author() { name = "Turtle Kid" }; var author3 = new Author() { name = "Robert Frost" }; var author4 = new Author() { name = "Marylin Monroe" }; var quote1 = new Quote() { quote = "I'm selfish, impatient and a little insecure. I make mistakes, I am out of control and at times hard to handle. But if you can't handle me at my worst, then you sure as hell don't deserve me at my best." }; var quote2 = new Quote() { quote = "What Am I doing?" }; var quote3 = new Quote() { quote = "I like Turtles." }; var quote4 = new Quote() { quote = "In three words I can sum up everything I've learned about life: it goes on." }; var qa1 = new QuoteAuthor() { Quote = quote1, Author = author4 }; var qa2 = new QuoteAuthor() { Quote = quote2, Author = author1 }; var qa3 = new QuoteAuthor() { Quote = quote3, Author = author2 }; var qa4 = new QuoteAuthor() { Quote = quote4, Author = author3 }; context.AddRange(qa1, qa2, qa3, qa4); context.SaveChanges(); }
private static async Task PopulateDatabase(QuotableContext context) { var author1 = new Author() { FirstName = "Dr", LastName = "Seuss" }; var author2 = new Author() { FirstName = "Mr", LastName = "Spock" }; var author3 = new Author() { FirstName = "Mr", LastName = "Tuvok" }; var quote1 = new Quote(); quote1.Body = "quote one body"; var quote2 = new Quote(); quote2.Body = "quote 2 body"; var quote3 = new Quote(); quote3.Body = "quote 3 body"; var qa1 = new QuoteAuthor() { Quote = quote1, Author = author1 }; var qa2 = new QuoteAuthor() { Quote = quote2, Author = author2 }; var qa3 = new QuoteAuthor() { Quote = quote3, Author = author1 }; var qa4 = new QuoteAuthor() { Quote = quote3, Author = author2 }; var qa5 = new QuoteAuthor() { Quote = quote3, Author = author3 }; context.AddRange(qa1, qa2, qa3, qa4, qa5); await context.SaveChangesAsync(); }
private static async Task PopulateDatabase(QuotableContext context) { var author1 = new Author() { FirstName = "Dr", LastName = "Seuss" }; var author2 = new Author() { FirstName = "Mahatma", LastName = "Gandhi" }; var author3 = new Author() { FirstName = "J.K.", LastName = "Rowling" }; var quote1 = new Quote(); quote1.QuoteContent = "You’re off to great to places. Today is your day. Your mountain is waiting. So get on your way"; var quote2 = new Quote(); quote2.QuoteContent = "Be the change that you wish to see in the world"; var quote3 = new Quote(); quote3.QuoteContent = "It does not do to dwell on dreams and forget to live"; var da1 = new QuoteAuthor() { Quote = quote1, Author = author1 }; var da2 = new QuoteAuthor() { Quote = quote2, Author = author2 }; var da5 = new QuoteAuthor() { Quote = quote3, Author = author3 }; context.AddRange(da1, da2, da5); await context.SaveChangesAsync(); }
/// <summary> /// In the intrest of completing this assignment, I decided to hard code the quotes instead of reading from file. /// </summary> /// <param name="context"></param> /// <returns></returns> private static async Task PopulateDatabase(quotableContext context) { var author1 = new Author() { FirstName = "Walker", LastName = "Percy" }; var author2 = new Author() { FirstName = "Mark", LastName = "Twain" }; var author3 = new Author() { FirstName = "Michel", LastName = "Houellebecq" }; var quote1 = new Quote(); quote1.Title = "You can get straight A's and still flunk life"; var quote2 = new Quote(); quote2.Title = "Never regret anything that made you smile"; var quote3 = new Quote(); quote3.Title = "Anything can happen in life, especially nothing"; var da1 = new QuoteAuthor() { Quote = quote1, Author = author1 }; var da2 = new QuoteAuthor() { Quote = quote2, Author = author2 }; var da3 = new QuoteAuthor() { Quote = quote3, Author = author3 }; context.AddRange(da1, da2, da3); await context.SaveChangesAsync(); }
private static void PopulateDatabase(QuotableContext c) { IEnumerable <string> lines = System.IO.File.ReadAllLines(@"..\..\quotes.txt"); DefaultRandomQuoteGenerator d = new DefaultRandomQuoteGenerator(lines); var count = 0; foreach (string s in lines) { var author = new Author() { FirstName = d.FindAuthorFirstName(count), LastName = d.FindAuthorLastName(count) }; var quote = new Quote(); quote.quote = d.FindQuoteById(count); var qa = new QuoteAuthor() { quote = quote, Author = author }; c.AddRange(qa); count++; } c.SaveChanges(); }
private static async Task PopulateDatabase(QuotableContext context) { var author1 = new Author() { FirstName = "Last Of Us", LastName = "NaughtyDog" }; var author2 = new Author() { FirstName = "Hunt Showdown", LastName = "Crytek" }; var author3 = new Author() { FirstName = "Fallout", LastName = "Bethesda/Obsidean" }; var author4 = new Author() { FirstName = "Oregon Trail", LastName = "MECC" }; var quote1 = new Quote(); quote1.Saying = "endure and survive"; var quote2 = new Quote(); quote2.Saying = "You Live to Hunt Another Day"; var quote3 = new Quote(); quote3.Saying = "Rise Up Damned Soul"; var quote4 = new Quote(); quote4.Saying = "War, War Never Changes"; var quote5 = new Quote(); quote5.Saying = "You have died of dysentery"; var qa1 = new QuoteAuthor() { Quote = quote1, Author = author1 }; var qa2 = new QuoteAuthor() { Quote = quote2, Author = author2 }; var qa3 = new QuoteAuthor() { Quote = quote3, Author = author2 }; var qa4 = new QuoteAuthor() { Quote = quote4, Author = author3 }; var qa5 = new QuoteAuthor() { Quote = quote5, Author = author4 }; context.AddRange(qa1, qa2, qa3, qa4, qa5); await context.SaveChangesAsync(); }