How do I select data from a table with lambda?

See more:

lambda

I want to use entity lambda query and insert table.But I dont choose same area.How to select and where condition this area.

SCHOOL TABLE

SCHOOL ID  // CLASS ID   // CLASS NAME    
1             1A           1
1             1B           1
1             1C           1
1             1D           1
2             2A           1
2             2B           1
2             2C           1
3             3A           1
4             4A           1

SCHOOLS INFORMATION TABLE (SCHOOLID,CLASSID,CLASSNAME)


ı want to school table insert to school information.

FOR EXAMPLE THIS SQL QUERY

 INSERT INTO SCHOOLID,CLASSID,CLASSNAME FROM SCHOOLINFORMATION(SELECT SCHOOLID,CLASSID,CLASSNAME FROM SCHOOL WHERE CLASSID NOT IN (3A))

What I have tried:

I want to SCHOOL INFORMATION TABLE

SCHOOL ID CLASS ID CLASS NAME
1 1A 1
1 1B 1
1 1C 1
1 1D 1
2 2A 1
2 2B 1
2 2C 1