static readonly Func<DatabaseApp, Guid, IEnumerable<gip.mes.webservices.MaterialStock>> s_cQry_GetMaterialStock =
EF.CompileQuery<DatabaseApp, Guid, IEnumerable<gip.mes.webservices.MaterialStock>>(
(dbApp, MaterialID) =>
dbApp.MaterialStock
.Where(c => c.MaterialID == MaterialID)
.Select(c => new gip.mes.webservices.MaterialStock()
{
MaterialStockID = c.MaterialStockID,
StockQuantity = c.StockQuantity,
DayInward = c.DayInward,
DayOutward = c.DayOutward,
MonthInward = c.MonthInward,
MonthOutward = c.MonthOutward,
MDReleaseState = new gip.mes.webservices.MDReleaseState()
{
MDReleaseStateID = c.MDReleaseStateID.HasValue ? c.MDReleaseStateID.Value : Guid.Empty,
MDNameTrans = c.MDReleaseState != null ? c.MDReleaseState.MDNameTrans : ""
},
})
);
public MaterialStock ExamplePrecompiled(Guid materialID)
{
using (DatabaseApp dbApp = new DatabaseApp())
{
return s_cQry_GetMaterialStock(dbApp, materialID).FirstOrDefault();
}
}