public static void InsertQuestions(List <JeopardyQuestion> questions, List <Category> categories, List <Round> rounds) { Console.WriteLine("Entered InsertQuestions!"); var MyJeopardyQuestions = new List <DbJeopardyQuestion>(); foreach (var question in questions) { MyJeopardyQuestions.Add(new DbJeopardyQuestion() { CategoryId = categories.Where(c => Regex.Unescape(question.Category.ToUpper()) == c.CategoryName).Select(c => c.Id).FirstOrDefault(), AirDate = question.Air_Date, Question = question.Question, DollarValue = question.DollarValue, Answer = question.Answer, RoundId = rounds.Where(r => question.Round == r.RoundName).Select(r => r.Id).FirstOrDefault(), ShowNumber = question.Show_Number, }); } Console.WriteLine("Questions Converted!"); var questionswithoutCategory = MyJeopardyQuestions.Where(q => q.CategoryId > 27916 || q.CategoryId < 1).ToList(); using (var context = new JeopardyContext()) { context.Questions.AddRange(MyJeopardyQuestions); context.SaveChanges(); Console.WriteLine("Questions inserted!"); } }
public static void InsertRounds(List <string> Rounds) { Console.WriteLine("Entered InsertRounds!"); var MyRounds = new List <Round>(); foreach (var r in Rounds) { MyRounds.Add(new Round() { RoundName = r }); } using (var context = new JeopardyContext()) { context.Rounds.AddRange(MyRounds); context.SaveChanges(); } Console.WriteLine("Rounds inserted!"); }
public static void InsertCategories(List <string> Categories) { Console.WriteLine("Entered InsertCategories!"); var MyCategories = new List <Category>(); foreach (var cat in Categories) { MyCategories.Add(new Category() { CategoryName = cat }); } using (var context = new JeopardyContext()) { context.Categories.AddRange(MyCategories); context.SaveChanges(); } Console.WriteLine("Categories inserted!"); }