这是我写的,不对 ,该如何写呢
var temp = from a in autor join r in ris on a.InstituteID equals r.InstituteID select a;
- SQL code
我有张的表,里面的内容来源于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
------解决方案--------------------
消息给我,加我Q,远程帮你看看。