I got some good answers from Diego and genonist about using NHibernate future here: Getting count with NHibernate + Linq + Future
It works fine in SQL Server. But with SQL Server Compact Edition I get this error:
System.Data.SqlServerCe.SqlCeException : There was an error parsing the query. [ Token line number = 2,Token line offset = 1,Token in error = SELECT ]
Isn't it possible to use future with SQL Server Compact Edition (4)?