using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using Microsoft.EntityFrameworkCore;

​

namespace ORM

{

    [Table("Users")]

    public class User

    {

        [Key]

        public int Id { get; set; }

        public string Name { get; set; }

        public int Age { get; set; }

    }

   public class AppDBContext : DbContext

    {

        public DbSet<User> Users { get; set; }

         protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

        {

            optionsBuilder.UseSqlServer("Data Source=(localdb)\\MSSQLLocalDB;" +

                "Initial Catalog=Users;Integrated Security=True");

        }

    }

    internal class Program

    {

        static void Main(string[] args)

        {

           using (var db = new AppDBContext()) 

            {

                while (true)

                {

                    Console.WriteLine("Enter data for user. - Name , Age");

                    string input = Console.ReadLine();

                    string[] data = input.Split();

                    if (input == "End")

                    {

                        break;

                    }

                    var user = new User();

                    user.Name = data[0];

                    int age;

                    int.TryParse(data[1], out age);

                    user.Age = age;

                    db.Users.Add(user);

                    db.Database.EnsureCreated();

                    db.SaveChanges();

                    var users = db.Users.ToList();

                    foreach (var item in users)

                    {

                        Console.WriteLine($"| {item.Id} | {item.Name} | {item.Age} |");

                    }   

                }  

            }

        }

    }

}