class Program
{
    private static ISessionFactory CreateSessionFactory()
    {
        return Fluently.Configure()
            .Database(
                OracleClientConfiguration
                    .Oracle10
                    .ConnectionString(Properties.Settings.Default.TWTest)
                    .ProxyFactoryFactory(typeof(NHibernate.ByteCode.LinFu.ProxyFactoryFactory)))
            .Mappings(m => m.FluentMappings.AddFromAssembly(Assembly.GetExecutingAssembly()))
            .BuildSessionFactory();
    }
 
    static void Main()
    {
        var allUsers = new List<User>();
 
        var sessionFactory = CreateSessionFactory();
 
        using (var session = sessionFactory.OpenSession())
        {
            using (var xact = session.BeginTransaction())
            {
                allUsers.AddRange(from u in session.Linq<User>() select u);
 
                xact.Commit();
            }
        }
 
        foreach (User u in allUsers)
            Console.WriteLine(u);
    }
}