BadMapping.cs

using FluentNHibernate.Mapping;

namespace APAAdminUI.Maps
{
	public class CAGIData : ClassMap<Models.CAGIData>
	{
		public CAGIData ()
		{
			Table ("cagi_data_sheet");
			LazyLoad ();
			Id (x => x.CAGINumber).GeneratedBy.Assigned ().Column ("cagi_nbr");
			References (x => x.Manufacturer).Not.Nullable ().LazyLoad ().NotFound.Exception ().Column ("manuf_nbr");
			Map (x => x.Model).Not.Nullable ().Length (100).Column ("model");
			Map (x => x.CompressorType).Nullable ().Length (100).Column ("comp_type");
			Map (x => x.LastUpdate).Nullable ().Column ("last_update");
			Map (x => x.Stages).Nullable ().Column ("nbr_of_stages");
			Map (x => x.IsAirCooledInternal).Nullable ().Length (1).Column ("is_air_cooled");
			Map (x => x.IsWaterCooledInternal).Nullable ().Length (1).Column ("is_water_cooled");
			Map (x => x.IsOilInjectedInternal).Nullable ().Length (1).Column ("is_oil_injected");
			Map (x => x.IsOilFreeInternal).Nullable ().Length (1).Column ("is_oil_free");
			Map (x => x.RatedCapacity).Nullable ().Column ("rated_capacity_cfm");
			Map (x => x.OperatingPressure).Nullable ().Column ("oper_pressure_psi");
			Map (x => x.MaximumPressure).Nullable ().Column ("max_pressure_psi");
			Map (x => x.DriveMotorHP).Nullable ().Column ("drive_motor_hp");
			Map (x => x.DriveMotorEfficiencyPercentage).Nullable ().Column ("drive_motor_eff_pct");
			Map (x => x.FanMotorHP).Nullable ().Column ("fan_motor_hp");
			Map (x => x.FanMotorEfficiencyPercentage).Nullable ().Column ("fan_motor_eff_pct");
			Map (x => x.ZeroFlowPower).Nullable ().Column ("zero_flow_power_kw");
			Map (x => x.FullLoadPower).Nullable ().Column ("full_load_power_kw");
			Map (x => x.PowerFlowRate).Nullable ().Column ("power_flow_rate");
		}
	}
}

GoodMapping.cs

using FluentNHibernate.Mapping;

namespace APAAdminUI.Maps
{
	public class Compressor : ClassMap<Models.Compressor>
	{
		public Compressor ()
		{
			Table ("compressor");
			LazyLoad ();
			Id (x => x.Number).GeneratedBy.Sequence ("compressor_nbr").Column ("compressor_nbr");
			Map (x => x.Name).Length (100).Nullable ().Column ("compressor_name");
			References (x => x.Supply).Nullable ().LazyLoad ().NotFound.Exception ().Column ("supply_nbr");
			References (x => x.Proposal).Nullable ().LazyLoad ().NotFound.Exception ().Column ("proposal_nbr");
			References (x => x.Manufacturer).Nullable ().LazyLoad ().NotFound.Exception ().Column ("manuf_nbr");
			Map (x => x.Model).Length (100).Nullable ().Column ("model");
			Map (x => x.CompressorControlInternal).Length (1).Nullable ().Column ("compressor_control");
			Map (x => x.Type).Length (100).Nullable ().Column ("comp_type");
			Map (x => x.RatedCapacityCFM).Nullable ().Column ("rated_capacity_cfm");
			Map (x => x.OperatingPressurePSI).Nullable ().Column ("oper_pressure_psi");
			Map (x => x.MaximumPressurePSI).Nullable ().Column ("max_pressure_psi");
			Map (x => x.DriveMotorHP).Nullable ().Column ("drive_motor_hp");
			Map (x => x.DriveMotorEfficiencyPercentage).Nullable ().Column ("drive_motor_eff_pct");
			Map (x => x.DriveLoadKW).Nullable ().Column ("drive_load_kw");
			Map (x => x.FanMotorHP).Nullable ().Column ("fan_motor_hp");
			Map (x => x.FanMotorEfficiencyPercentage).Nullable ().Column ("fan_motor_eff_pct");
			Map (x => x.FanLoadKW).Nullable ().Column ("fan_load_kw");
			Map (x => x.TargetPressure).Nullable ().Column ("target_pressure");
			Map (x => x.LoadPSI).Nullable ().Column ("load_psi");
			Map (x => x.UnloadPSI).Nullable ().Column ("unload_psi");
			Map (x => x.MeterID).Nullable ().Column ("meter_id");
			Map (x => x.IsTrimmingCompressorInternal).Length (1).Nullable ().Column ("trimming_comp");
			Map (x => x.CAGINumber).Nullable ().Column ("cagi_nbr");
			HasMany (x => x.Dryers).Inverse ().Cascade.All ();
		}
	}
}