tbf/SharedDatabase/Mappings/ProcessMap.cs

using FluentNHibernate.Mapping;

namespace SharedDatabase.Mappings
{
    class ProcessMap : ClassMap<Entities.Process>
    {
        public ProcessMap()
        {
            Id(x => x.Id);

            Map(x => x.ItemNr);
            Map(x => x.Name);
            Map(x => x.Description);
            Map(x => x.ReleaseNotes)
                .CustomType("StringClob")
                .CustomSqlType("varchar(8000)");
            Map(x => x.CreatedBy)
                .Column("UserName");
            Map(x => x.TimeStamp);
            Map(x => x.ApprovedBy);
            Map(x => x.TimeStamp2);
            Map(x => x.ReleaseStatus);

			HasMany(x => x.Parts)
                .OrderBy("StepNumber")
				.Cascade.All();

			HasMany(x => x.Worksteps)
				.OrderBy("WorkstepNr")
				.Cascade.All();
		}
    }
}