NHibernate - Lesson 2. Basic Mapping and Persistence

[netcat-na-diary]

Mapping Metadata

• XML-based
  hbm.xml files in NHibernate core


• Code-based
  ClassMap<T> in Fluent NHibernate http://www.fluentnhibernate.org/


• Convention-based
  Automapping in Fluent NHibernate http://www.fluentnhibernate.org/
  ConfORM https://code.google.com/p/codeconform/

Mapping Data Types

Customer.cs

using System;

namespace NHibernateDemo
{
	public class Customer
	{
		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}, FirstName: {1}, LastName: {2}, " +
								 "Points {3}, HasGoldStatus: {4}, MemberSince: {5}," +
								 "CreditRating: {6}",
								 Id, FirstName, LastName, Points, HasGoldStatus, MemberSince, CreditRating);
		}
	}

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

Customer.hbm.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="Points"/>
		<property name="HasGoldStatus"/>
		<property name="MemberSince"/>
		<property name="CreditRating"/>
	</class>
</hibernate-mapping>

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();

			using (var session = sessionFactory.OpenSession())
			using (var tx = session.BeginTransaction())
			{
				var newCustomers = CreateCustomer();
				session.Save(newCustomers);
				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.Good
			};
		}
	}
}

Таблица в БД


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();

			using (var session = sessionFactory.OpenSession())
			using (var tx = session.BeginTransaction())
			{
				var customer = session.QueryOver<Customer>().List<Customer>().First();
				Console.WriteLine(customer);
				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
			};
		}
	}
}

В случае перечислений enum
Customer.hbm.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="Points"/>
		<property name="HasGoldStatus"/>
		<property name="MemberSince"/>
		<property name="CreditRating" type="CustomerCreditRatingType"/>
	</class>
</hibernate-mapping>

и создаем класс CustomerCreditRatingType.cs

using NHibernate.Type;

namespace NHibernateDemo
{
	public class CustomerCreditRatingType : EnumStringType<CustomerCreditRating>
	{
	}
}