这条sql语句 转成 linq to sql 怎么写?
这是我写的,不对 ,该如何写呢
var temp = from a in autor join r in ris on a.InstituteID equals r.InstituteID select a;
我有张的表,里面的内容来源于Author 、ResearchInstitute 这两张表,条件是Author .InstituteID等于ResearchInstitute.InstituteIDselect a.AuthorID,a.AuthorName,r.InstituteNameCN from Author as a left join ResearchInstitute as r on a.InstituteID=r.InstituteID