blog post - Compiled Queries

CompiledQuery_NoParam.cs

public class Repository {
	private gReadieModelContext _Ctx = gReadieModelContext.Create(gReadieModelContext.ConnectionString);

	public Func<gReadieModelContext, IEnumerable<Folder>> Query_FoldersWithUnreadPosts = 
		CompiledQuery.Compile((gReadieModelContext db) => db.Folders.Where(d => d.UnreadCount != 0).AsEnumerable());
	
	public IEnumerable<Folder> GetFoldersWithUnreadPosts() {
		return 	Query_FoldersWithUnread(_Ctx);
	}
}

CompiledQuery_Params.cs

public class Repository {
	private gReadieModelContext _Ctx = gReadieModelContext.Create(gReadieModelContext.ConnectionString);

	public Func<gReadieModelContext, string, IEnumerable<Folder>> Query_FoldersContainingPost = 
		CompiledQuery.Compile((gReadieModelContext db, string postId) => db.Folders.Where(d => d.Posts.Any(e => e.PostId == postId)).AsEnumerable());
	
	public IEnumerable<Folder> GetFoldersContainingPost(string postId) {
		return 	Query_FoldersContainingPost(_Ctx, postId);
	}
}