试试这个:

     var data =(from t1 in dataContext.Table1 join 
                 t2 in dataContext.Table2 on 
                 t1.field equals t2.field 
                 orderby t1.Id select t1).ToList(); 

从d1在dealercontract中加入d2在dealercontract中d1.dealearid = d2.dealerid select new {dealercontract.*}

试试这个吧，

var dealer = from d in Dealer
             join dc in DealerContact on d.DealerID equals dc.DealerID
             select d;

基本上LINQ连接操作符对SQL没有好处。例如，下面的查询

var r = from dealer in db.Dealers
   from contact in db.DealerContact
   where dealer.DealerID == contact.DealerID
   select dealerContact;

将导致内部连接在SQL

join对IEnumerable<>有用，因为它更有效:

from contact in db.DealerContact  

条款将对每个经销商重新执行 但对于IQueryable<>则不是这样。另外，连接也不太灵活。

OperationDataContext odDataContext = new OperationDataContext();    
        var studentInfo = from student in odDataContext.STUDENTs
                          join course in odDataContext.COURSEs
                          on student.course_id equals course.course_id
                          select new { student.student_name, student.student_city, course.course_name, course.course_desc };

学生和课程表在哪里有主键和外键的关系

var data=(from t in db.your tableName(t1) 
          join s in db.yourothertablename(t2) on t1.fieldname equals t2.feldname
          (where condtion)).tolist();