Skip to content

Instantly share code, notes, and snippets.

@lnickers2004
Last active January 3, 2016 12:39
Show Gist options
  • Save lnickers2004/8464658 to your computer and use it in GitHub Desktop.
Save lnickers2004/8464658 to your computer and use it in GitHub Desktop.
LINQ: sample queries collected over time...
//001: RAVEN DB LINQ QUERY
var results = session.Query<Car>()
.Statistics(out stats)
.Skip(0*10) // retrieve results for the first page
.Take(20) // page size is 20
.Where(x => x.Make == "Ford")
.Distinct().ToList();
//002: descending orderby
var query = this._unit.Homes.GetAll().OrderByDescending(s => s.Price);
vm.Homes = query.ToList();
//003: repository all method query NOTE: repo returned an IQueryable
// var allEvents = eventdataRepository.All.ToList();//Store.GetAll();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment