Как вставить таблицы use entitiy в C#?

NEW DATABASE NAME: NEWSTUDENT_1 
TABLENAME : Teacher
        
    
        ID    NAME   BRANCHCODE   NUMBER    COUNTRYCODE    COURSECODE
        012   Emily    01          123         0101              20
        104   Alex     02          124          021              23
        109   Toms     02          245          015              54
        145   Michael  06          458          053              26

    
NEW DATABASE NAME: NEWSTUDENT_2 
TABLENAME : STUDENT
    
    ID    NAME    BRANCHCODE    NUMBER    COUNTRYCODE    COURSECODE
    002   Hill        036        1225         0101           20
    109   Toms        02         245          0217           29
    
NEW DATABASE NAME:  NEWSTUDENT_2 
TABLENAME : STUDENTINFORMATION
    
    COUNTRYCODE  COURSECODE    COURSENAME    COURSEADDRESS
     0101            20           ASD         4.Ave B.APT
     0217            29           TYA         5.Ave T.APT
    
    
   **I WANT TO EXCEPT AND INSERT TABLE RESULT EXAMPLE:**

  

DATABASE NAME: NEWSTUDENT_1
TABLENAME : Country
        
        
        COUNTRYCODE   COURSECODE    COURSENAME   COURSEADDRESS    STATUS
          0101           20            ASD       4.Ave B.APT       0
          0217           29            TYA       5.Ave T.APT       0

TRY QUERY:

 
      public static void Compare()
    {
         var Teacher=DbContext.Entities.Teacher.Select(p=>new {p.CountryCode,p.BranchID}
         var Student=DbContext.Entities.Teacher.Select(p=>new {p.CountryCode,p.BranchID}
         var common=Country.Except(Teacher);
    
    List<Country> t=new List<Country>();
    
    foreach(var p in common)
    {
         var ıtem=teacher.SingleOrDefault(s=>s.CountryCode==p.CountryCode && s.BranchCode==p.BranchCode);
    if(ıtem==null)
    {
         Country  ctable= new Country
    {
         BranchID=ıtem.BranchID,
         CountryCode=ıtem.BranchID,
         CountryInf=ıtem.CountryInf,
         Status=0
    };
    t.Add(ctable);
    }
    }
    DbContext.Entities.Country.AddRange(t);
    DbContext.Entities.SaveChanges();
    }

Can you help me with this?How to write except and insert query?