Basic `ISessionFactory` setup and class mapping using Loquacious Mappings for NHibernate.

NHibernateConfig.cs

using System.Reflection;
using NHibernate;
using NHibernate.Cfg;
using NHibernate.Cfg.MappingSchema;
using NHibernate.Mapping.ByCode;

namespace ManhattanProject
{
    public class NHibernateConfig
    {
        public static ISessionFactory SessionFactory()
        {
            Configuration cfg = new Configuration();
            //cfg.Proxy(p => p.ProxyFactoryFactory<ProxyFactoryFactory>());
            cfg.DataBaseIntegration(db =>
            {
                db.Dialect<NHibernate.Dialect.PostgreSQL82Dialect>();
                db.Driver<NHibernate.Driver.NpgsqlDriver>();
                db.ConnectionStringName = "Postgres";
                db.BatchSize = 200;
                db.LogFormattedSql = true;
                db.LogSqlInConsole = true;
                db.HqlToSqlSubstitutions = "true 1, false 0, yes 'Y', no 'N'";
            });
            cfg.SessionFactory().GenerateStatistics();

            var mapper = new ModelMapper();
            mapper.AddMappings(Assembly.GetExecutingAssembly().GetExportedTypes());
            HbmMapping domainMapping = mapper.CompileMappingForAllExplicitlyAddedEntities();
            cfg.AddMapping(domainMapping);

            return cfg.BuildSessionFactory();
        }
    }
}

User.cs

using System;

namespace ManhattanProject.Entities
{
    public class User
    {
        public virtual Guid Id { get; set; }
        public virtual string Username { get; set; }
        public virtual string Password { get; set; }
        public virtual string Email { get; set; }
        public virtual DateTime CreatedAt { get; set; }
        public virtual string Bio { get; set; }
        public virtual Address Address { get; set; }
    }
}

UserMap.cs

using BlogNET.Core.Entities;
using NHibernate.Mapping.ByCode;
using NHibernate.Mapping.ByCode.Conformist;

namespace ManhattanProject.Mappings
{
    public class UserMap : ClassMapping<User>
    {
        public UserMap()
        {
            Schema("public");
            Table("users");
            Id(p => p.Id, map => map.Generator(Generators.GuidComb));
            Property(p => p.Username, map => { map.Length(128); map.NotNullable(true); });
            Property(p => p.Password, map => { map.Length(255); map.NotNullable(true); });
            Property(p => p.Email, map => { map.Length(255); map.NotNullable(true); });
            Property(p => p.CreatedAt, map => { map.Column("created_at"); map.NotNullable(true); map.Generated(PropertyGeneration.Insert); });
            Property(p => p.Bio);
        }
    }
}