在 asp.net mvc 中使用 Linq-to-sql 进行 Innerjoin？

Question

我使用 asp.net mvc...如何在 linq-to-sql 中为此 sql 查询编写内部联接

select M.Mat_id,M.Mat_Name,T.Name as Measurement,M.Mat_Type as Description 
 from Material as M inner join MeasurementTypes as T 
  on M.MeasurementTypeId = T.Id where M.Is_Deleted=0

我的存储库类有这个，

    public class ConstructionRepository
    {
        private CRDataContext db = new CRDataContext();
        public IQueryable<Material> FindAllMaterials()
        {
            return db.Materials;
        }
    }

我的结果 db.Materials 是表数据..我不想与另一个表内连接并显示数据....

public class ConstructionRepository
 {
    private CRDataContext db = new CRDataContext();
     public IQueryable<Material> FindAllMaterials()
    {
                //inner join query
     }
    }

任何建议...

Answer 1

这将返回带有您在 SQL 查询中指定的详细信息的匿名类型，但您可能更愿意简单地返回材质对象本身。

from material in db.Materials
from measurementType in material.MeasurementTypes
where material.Is_Deleted = false
select new {
    material..Mat_id,
    material.Mat_Name,
    Measurement = measurementType.Name,
    Description = material.Mat_Type
}