c# - Linq to entities hard code list -
this view model
public class procurementdisplaydata { public string key { get; set;} public string value { get; set;} }
how can hard code list. syntax inside query
var query = (from u in context.jobs join q in context.quotations on u.quotationid equals q.quotationid join v in context.vessels on q.vesselid equals v.vesselid join c in context.customers on q.customerid equals c.customerid u.jobno == jobno select new list<procurementdisplaydata> { new { key = "a" ,value=u.jobno}, new { key = "b" ,value=u.vessel} }).tolist(); return query;
get jobno
, vessel
database. create lists in memory:
var query = u in context.jobs join q in context.quotations on u.quotationid equals q.quotationid join c in context.customers on q.customerid equals c.customerid u.jobno == jobno select new { u.jobno, u.vessel }; return query.asenumerable() // moves further processing memory .select(x => new list<procurementdisplaydata> { new { key = "a", value = x.jobno }, new { key = "b", value = x.vessel } }).tolist();
Comments
Post a Comment