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();
}
