public ActionResult Search(string q) { var items = RavenSession.Query<Item, Search_Items>() .Where(i => i.Owner == UserId) //.OrderByDescending(p => p.Created) .ToList(); var vm = new ItemsViewModel() { Items = items, }; return View("Index", vm); }
public ActionResult ByCategory(string id) { var items = RavenSession.Query<Item>() .Where(i => i.Owner == UserId) // .Where(i => i.Categories.Contains(id)) // Fails! .OrderByDescending(p => p.Created) .ToList(); items = items.Where(i => i.Categories.Contains(id)).ToList(); var vm = new ItemsViewModel() { Items = items, }; return View("Index", vm); }
// // GET: /Items/Category id public ActionResult Index(string id = "") { RavenQueryStatistics stats; var items = RavenSession.Query<Item>() .Statistics(out stats) .Where(i => i.Owner == UserId) .OrderByDescending(p => p.Created) //.Customize(q => q.WaitForNonStaleResultsAsOfLastWrite()) .ToList(); if (id != "") { items = items.Where(i => i.Categories.Contains(id)).ToList(); } var vm = new ItemsViewModel() { Items = items, }; return View(vm); }