如何从多个表访问数据

这样就可以了。

var q = from u in db.user
        from e in db.employee
        where u.Name == "smith" && e.company == "xyz"
        select new
        {
           User = u,
           Employee = e
        };

这取决于您使用的LINQ提供者。例如,假设您正确定义了外键,实体框架将创建它们所称的“导航属性”。因此,您可以用这种方式轻松地编写一个类似上面所述的LINQ查询:

var query = data.Where(employee => employee.Name == "Smith" && employee.Company.Name == "xyz");

var result = from u in context.User
             from e in context.Employee
             where (u.Name == "smith" && e.company == "xyz")