Skip to content

Instantly share code, notes, and snippets.

@bojanrajkovic
Created November 3, 2010 18:26
Show Gist options
  • Save bojanrajkovic/661474 to your computer and use it in GitHub Desktop.
Save bojanrajkovic/661474 to your computer and use it in GitHub Desktop.
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");
}
}
}
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 ();
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment