static void Main(string[] args) { // use database using (var db = new UserDatabaseContext()) { users = db.Users.ToList(); categories = db.Categories.ToList(); } users.ForEach(u => Console.WriteLine($"{u.UserId,-10}")); }
static void Main(string[] args) { //use database using (var db = new UserDatabaseContext()) { db.Database.EnsureDeleted(); db.Database.EnsureCreated(); var category1 = new Category() { CategoryName = "Admin" }; var category2 = new Category() { CategoryName = "User" }; var category3 = new Category() { CategoryName = "Personal" }; var user1 = new User() { UserName = "******", CategoryId = 1 }; var user2 = new User() { UserName = "******", CategoryId = 2 }; var user3 = new User() { UserName = "******", CategoryId = 3 }; db.Categories.AddRange(category1, category2, category3); db.Users.AddRange(user1, user2, user3); db.SaveChanges(); users = db.Users.ToList(); categories = db.Categories.ToList(); } foreach (var item in users) { //pointer to category Console.WriteLine($"{item.UserId,-15} {item.UserName,-15} {item.Category.CategoryName} \n"); } //users.ForEach(u => Console.WriteLine(u.UserName)); //categories.ForEach(u => Console.WriteLine(u.CategoryName)); }