public static List <LU_Material> GetAllMaterials(int MaterialTypeID) { using (var context = new SpectrumDBContext()) { return((from m in context.LU_Material where m.MaterialTypeID == MaterialTypeID select m).ToList()); } }
public static List <LU_MaterialType> GetAllMaterialTypes() { using (var context = new SpectrumDBContext()) { return(context.LU_MaterialType.ToList()); } }
public static LU_Material GetAllMaterialProperies(int MaterialID) { using (var context = new SpectrumDBContext()) { return((from m in context.LU_Material where m.MaterialID == MaterialID select m).SingleOrDefault()); } }