Guest User

Untitled

a guest
Jun 20th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. IQuery query = session.CreateQuery("from OfflineShipmentLineItem as line join fetch line.Shipment as shipment join fetch line.Extension where shipment.ShipmentDate = :date");
  2. query.SetParameter("date", date);
  3.  
  4. return query.List<OfflineShipmentLineItem>();
  5.  
  6. ICriteria criteria = session.CreateCriteria(typeof(OfflineShipmentLineItem));
  7.  
  8. criteria.SetFetchMode("Shipment", FetchMode.Eager);
  9. criteria.SetFetchMode("Extension", FetchMode.Eager);
  10.  
  11. criteria.CreateAlias("Shipment", "shipment");
  12.  
  13. criteria.Add(Expression.Eq("shipment.ShipmentDate", date));
  14.  
  15. return criteria.List<OfflineShipmentLineItem>();
Add Comment
Please, Sign In to add comment