NHibernate - Lesson 2. Common Mapping Gotchas

[netcat-na-diary]

Common Mapping Gotchas

Program.cs (выводи данные о пользователе до сохранения его в бд и присвоения ему id и после)

using System;
using System.Linq;
using System.Reflection;
using HibernatingRhinos.Profiler.Appender.NHibernate;
using NHibernate.Cfg;
using NHibernate.Dialect;
using NHibernate.Driver;
using NHibernate.Linq;

namespace NHibernateDemo
{
	internal class Program
	{
		static void Main(string[] args)
		{
			NHibernateProfiler.Initialize();

			var cfg = new Configuration();
			cfg.DataBaseIntegration(x =>
				{
					//x.LogSqlInConsole = true;
					x.ConnectionString = "Server=.; Database=NHibernateDemo; Integrated Security = SSPI;";
					x.Driver<SqlClientDriver>();
					x.Dialect<MsSql2008Dialect>();
				});
			cfg.AddAssembly(Assembly.GetExecutingAssembly());
			var sessionFactory = cfg.BuildSessionFactory();

			int newId;
			
			using (var session = sessionFactory.OpenSession())
			using (var tx = session.BeginTransaction())
			{
				var newCustomer = CreateCustomer();
				Console.WriteLine("Before saving:");
				Console.WriteLine(newCustomer);
				session.Save(newCustomer);
				newId = newCustomer.Id;
				tx.Commit();
			}

			using (var session = sessionFactory.OpenSession())
			using (var tx = session.BeginTransaction())
			{
				var newCustomer = session.Load<Customer>(newId);
				Console.WriteLine("After saving:");
				Console.WriteLine(newCustomer);
				session.Save(newCustomer);
				tx.Commit();
			}

			Console.WriteLine("Enter any key to exit...");
			Console.ReadKey();
		}

		private static Customer CreateCustomer()
		{
			return new Customer
			{
				FirstName = "Jonh",
				LastName = "Doe",
				Points = 100,
				HasGoldStatus = true,
				MemberSince = new DateTime(2012, 1, 1),
				CreditRating = CustomerCreditRating.Terrible
			};
		}
	}
}

Закомментируем строку MemberSince = new DateTime(2012, 1, 1), в Program.cs

using System;
using System.Linq;
using System.Reflection;
using HibernatingRhinos.Profiler.Appender.NHibernate;
using NHibernate.Cfg;
using NHibernate.Dialect;
using NHibernate.Driver;
using NHibernate.Linq;

namespace NHibernateDemo
{
	internal class Program
	{
		static void Main(string[] args)
		{
			NHibernateProfiler.Initialize();

			var cfg = new Configuration();
			cfg.DataBaseIntegration(x =>
				{
					//x.LogSqlInConsole = true;
					x.ConnectionString = "Server=.; Database=NHibernateDemo; Integrated Security = SSPI;";
					x.Driver<SqlClientDriver>();
					x.Dialect<MsSql2008Dialect>();
				});
			cfg.AddAssembly(Assembly.GetExecutingAssembly());
			var sessionFactory = cfg.BuildSessionFactory();

			int newId;
			
			using (var session = sessionFactory.OpenSession())
			using (var tx = session.BeginTransaction())
			{
				var newCustomer = CreateCustomer();
				Console.WriteLine("Before saving:");
				Console.WriteLine(newCustomer);
				session.Save(newCustomer);
				newId = newCustomer.Id;
				tx.Commit();
			}

			using (var session = sessionFactory.OpenSession())
			using (var tx = session.BeginTransaction())
			{
				var newCustomer = session.Load<Customer>(newId);
				Console.WriteLine("After saving:");
				Console.WriteLine(newCustomer);
				session.Save(newCustomer);
				tx.Commit();
			}

			Console.WriteLine("Enter any key to exit...");
			Console.ReadKey();
		}

		private static Customer CreateCustomer()
		{
			return new Customer
			{
				FirstName = "Jonh",
				LastName = "Doe",
				Points = 100,
				HasGoldStatus = true,
//				MemberSince = new DateTime(2012, 1, 1),
				CreditRating = CustomerCreditRating.Terrible
			};
		}
	}
}

и зададим значение по умолчанию в конструкторе

using System;

namespace NHibernateDemo
{
	public class Customer
	{
		public Customer()
		{
			MemberSince = new DateTime(2012, 1, 1);
		}
		
		public virtual int Id { get; set; }
		public virtual string FirstName { get; set; }
		public virtual string LastName { get; set; }
		public virtual int Points { get; set; }
		public virtual bool HasGoldStatus { get; set; }
		public virtual DateTime MemberSince { get; set; }
		public virtual CustomerCreditRating CreditRating { get; set; }

		public override string ToString()
		{

			return string.Format("Id: {0}, \nFirstName: {1}, \nLastName: {2}, " +
								 "\nPoints {3}, \nHasGoldStatus: {4}, \nMemberSince: {5}," +
								 "\nCreditRating: {6}",
								 Id, FirstName, LastName, Points, HasGoldStatus, MemberSince, CreditRating);
		}
	}

	public enum CustomerCreditRating
	{
		Excellent, Good, Neutral, Poor, Terrible
	}
}

и изменим файл Customer.hbm.xml
<property name="MemberSince" type="LocalDateTime"/>
или
<property name="MemberSince" type="UtcDateTime"/>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
				  assembly="NHibernateDemo"
				  namespace="NHibernateDemo">
	<class name="Customer">
		<id name="Id">
			<generator class="native" />
		</id>
		<property name="FirstName"/>
		<property name="LastName"/>
		<property name="Points"/>
		<property name="HasGoldStatus"/>
		<property name="MemberSince" type="LocalDateTime"/>
		<property name="CreditRating" type="CustomerCreditRatingType"/>
	</class>
</hibernate-mapping>

Добавим к классу еще одно свойство Customer.cs
public virtual double AverageRating { get; set; }

using System;

namespace NHibernateDemo
{
	public class Customer
	{
		public Customer()
		{
			MemberSince = DateTime.UtcNow;
		}
		
		public virtual int Id { get; set; }
		public virtual string FirstName { get; set; }
		public virtual string LastName { get; set; }
		public virtual double AverageRating { get; set; }
		public virtual int Points { get; set; }
		public virtual bool HasGoldStatus { get; set; }
		public virtual DateTime MemberSince { get; set; }
		public virtual CustomerCreditRating CreditRating { get; set; }

		public override string ToString()
		{

			return string.Format("Id: {0}, \nFirstName: {1}, \nLastName: {2}, " +
								 "\nPoints {3}, \nHasGoldStatus: {4}, \nMemberSince: {5}," +
								 "\nCreditRating: {6}",
								 Id, FirstName, LastName, Points, HasGoldStatus, MemberSince, CreditRating);
		}
	}

	public enum CustomerCreditRating
	{
		Excellent, Good, Neutral, Poor, Terrible
	}
}

внесем изменения в xml-файл

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
				  assembly="NHibernateDemo"
				  namespace="NHibernateDemo">
	<class name="Customer">
		<id name="Id">
			<generator class="native" />
		</id>
		<property name="FirstName"/>
		<property name="LastName"/>
		<property name="AverageRating"/>
		<property name="Points"/>
		<property name="HasGoldStatus"/>
		<property name="MemberSince" type="UtcDateTime"/>
		<property name="CreditRating" type="CustomerCreditRatingType"/>
	</class>
</hibernate-mapping>

Добавим поле в таблицу в БД
AverageRating --- decimal(18, 4) (4 знака после запятой)