public void selectOption() { beginning: string select = ""; select = Console.ReadLine(); switch (select) { case "1": // DISPLAY BLOGS var orderQueryName = db.Blogs.OrderBy(b => b.Name); Console.WriteLine("All blogs in the database:"); foreach (var item in orderQueryName) { Console.WriteLine(item.Name); } startUp(); goto beginning; case "2": // ADD BLOG tryAgain: Console.Write("Enter a name for a new Blog: "); var name = Console.ReadLine(); if (String.IsNullOrEmpty(name)) { goto tryAgain; } var blog = new Blog { Name = name }; db.AddBlog(blog); logger.Info("Blog added - {name}", name); startUp(); goto beginning; case "3": // DISPLAY POSTS int blogIdL = selectBlog(); using (var context = new BloggingContext()) { var blogs = context.Blogs .FromSqlInterpolated($"SELECT * FROM dbo.Blogs Where BlogId = ({blogIdL})").ToList(); Console.ForegroundColor = ConsoleColor.DarkRed; foreach (Blog blogName in blogs) { System.Console.WriteLine($"Blog: " + blogName.Name); } Console.ForegroundColor = ConsoleColor.White; } using (var context = new BloggingContext()) { var posts = context.Posts .FromSqlInterpolated($"SELECT * FROM dbo.Posts Where BlogId = ({blogIdL})").ToList(); foreach (Post post in posts) { System.Console.WriteLine($"Title: " + post.Title + "\tContent: " + post.Content); } } startUp(); goto beginning; case "4": // ADD POST int workingBlogId = selectBlog(); oppsNoTitle: Console.Write("Enter a title for the new Post: "); var title = Console.ReadLine(); if (String.IsNullOrEmpty(title)) { goto oppsNoTitle; } Console.Write("Enter content for the new Post: "); var content = Console.ReadLine(); using (var db = new BloggingContext()) { var post = new Post() { BlogId = workingBlogId, Content = content, Title = title }; db.Posts.Add(post); db.SaveChanges(); } logger.Info("Post added!"); startUp(); goto beginning; case "q": Console.WriteLine("Quit"); db.QuitProgram(); break; default: Console.WriteLine("Wrong input try again"); startUp(); goto beginning; } }