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