raven_query

gistfile1.cs

public class Get
{
	private readonly IDocumentSession session;
	private readonly ISecurityContext security;

	public Get(IDocumentSession session, ISecurityContext security)
	{
		this.session = session;
		this.security = security;
	}

	public ViewLessonViewModel Handle(ViewLessonRequest request)
	{
		var lesson = session
		    .Query<LifeLesson>()
		    .ForLoggedInUser(security)
		    .Where(l => l.Slug == request.Lesson)
		    .ToList().Single();

		var plan = session
			.Query<RehearsalPlan>()
			.Where(p => p.LessonId == lesson.Id)
			.Customize(x => x.WaitForNonStaleResultsAsOfLastWrite())
			.FirstOrDefault();

		return new ViewLessonViewModel{Lesson = lesson, RehearsalPlan = plan};
	}
}