using System;

//using System.Data.SqlClient;

using NMemory;

using NMemory.Tables;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

        Console.WriteLine("Hello World");

        HospitalDB aims = new HospitalDB();

        InsertPatients(aims, 100);

        var list = aims.Patients.ToList();

        FiddleHelper.WriteTable("Patients",list);

        //SqlConnection connection = new SqlConnection()

    }

    public static void InsertPatients(HospitalDB hospital, int patientCount){

        int i = 1;

        bool hasCorona = false;

        while(i<=patientCount){

            hospital.Patients.Insert(new Patient(){Id = i, FName="FName-"+i, LName="LName"+i, Symptoms="Headache, cough", HasCorona=hasCorona});

            hasCorona=!hasCorona;

            i++;

        }

    }

    public class HospitalDB : Database{

        public HospitalDB(){

        //create database

        Database db = new Database();

        //create table

        var patients = db.Tables.Create<Patient, int>(x=> x.Id);

        this.Patients = patients;

        }

        public ITable<Patient> Patients { get; private set;}

    }

    public class Patient{

        public int Id { get; set; }

        public string FName{ get; set;}

        public string LName {get; set;}

        public string Symptoms  { get; set; }

        public bool HasCorona {get; set;}

    }

}