/// <summary> /// Fetches the individual element /// </summary> /// <param name="key">The key of the element to fetch.</param> /// <returns>The fetched element, or null if not found</returns> public override L2S.Bencher.EntityClasses.SalesOrderHeader FetchIndividual(int key) { using (var ctx = new L2SBencherDataContext()) { return(ctx.SalesOrderHeaders.FirstOrDefault(e => e.SalesOrderId == key)); } }
/// <summary> /// Fetches the complete set of elements and returns this set as an IEnumerable. /// </summary> /// <returns>the set fetched</returns> public override IEnumerable <L2S.Bencher.EntityClasses.SalesOrderHeader> FetchSet() { using (var ctx = new L2SBencherDataContext()) { return(ctx.SalesOrderHeaders.ToList()); } }
/// <summary> /// Fetches the complete graph using eager loading and returns this as an IEnumerable. /// </summary> /// <returns>the graph fetched</returns> public override IEnumerable <L2S.Bencher.EntityClasses.SalesOrderHeader> FetchGraph() { using (var ctx = new L2SBencherDataContext()) { var loadOptions = new DataLoadOptions(); loadOptions.LoadWith <L2S.Bencher.EntityClasses.SalesOrderHeader>(soh => soh.SalesOrderDetails); loadOptions.LoadWith <L2S.Bencher.EntityClasses.SalesOrderHeader>(soh => soh.Customer); ctx.LoadOptions = loadOptions; return((from soh in ctx.SalesOrderHeaders where soh.SalesOrderId > 50000 && soh.SalesOrderId <= 51000 select soh).ToList()); } }