public IEnumerable <Product> GetProducts() { using (var session = _nhibernate.OpenSession()) { var products = (from p in session.Query <Product>() orderby p select p).ToList(); return(products); } }
public IEnumerable <Category> GetCategories() { using (var session = _nhibernate.OpenSession()) { var categories = (from c in session.Query <Category>() orderby c.CategoryName select c).ToList(); // Log call _loggingService.Trace("AppArch.Infrastructure.Data: CategoryRepository.GetCategories"); return(categories); } }