我如何用SQL命令在c#中实现这个计划

我有两个表:

• 表1，列为name_markaz nvarchar(100), code_markaz nchar(20);
• 表2有name_markaz nvarchar(100)、code_markaz nchar(20)列;

我想实现这个计划，从表1中读取所有数据，并以以下条件插入表2:

if table1.code_markaz not found in table 2.code_markaz then
   insert the table1.code_markaz into the table2.code_markaz

INSERT INTO table2 (name_markaz, code_markaz)
   SELECT name_markaz, code_markaz 
   FROM table1
   WHERE NOT EXISTS (SELECT 1
                     FROM table2 ti
                     WHERE ti.code_markaz = table1.code_markaz);