NHibernate - Lesson 1. Getting Started

[netcat-na-diary]

из курса pluralsight
Класс (модель)

public class Customer
        {
            public virtual int Id { get; set; }
            public virtual string FirstName { get; set; }
            public virtual string LastName { get; set; }
        }

Запрос к БД

CREATE TABLE [dbo].[Customer] (
        [Id][int] IDENTITY (1,1) NOT NULL,
        [FirstName] [nvarchar](50) NOT NULL,
        [LastName] [nvarchar](50) NOT NULL,
        CONSTRAIN [PK_Customer] PRIMARY KEY CLUSTERED ([Id])
)

Маппинг

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mappin 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"/>
</class>
</hibernate-mappin>	

Добавление в проект
Package Manager Console
PM> install-package nhibernate

using System.Reflection;
using NHibernate.Cfg;
using NHibernate.Dialect;
using NHibernate.Driver;

namespace NHibernateDemo
{
	internal class Program
	{
		static void Main(string[] args)
		{
			var cfg = new Configuration();
			cfg.DataBaseIntegration(x =>
				{
					x.ConnectionString = "Server=localhost; 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())
			{
				tx.Commit();
			}
		}
	}
}

Затем создаем модель (см. выше)
Затем создаем XML-файл Customer.hbm.xml (см. выше)

Далее открыть свойства файла Customer.nbm.xml и изменить свойство Build Action на Embedded Resource

Querying Using Criteria

using System;
using System.Reflection;
using NHibernate.Cfg;
using NHibernate.Dialect;
using NHibernate.Driver;

namespace NHibernateDemo
{
	internal class Program
	{
		static void Main(string[] args)
		{
			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 customers = session.CreateCriteria<Customer>()
					                       .List<Customer>();
					foreach (var customer in customers)
					{
						Console.WriteLine("{0} {1}", customer.FirstName, customer.LastName);
					}
					tx.Commit();
					Console.WriteLine("Enter any key to exit...");
					Console.ReadKey();
				}
		}
	}
}

NB. Код нужно разбить на 4 отдельных метода: конфигурация, работа с session factory, собственно выборка, выдача результата.

Querying Using LINQ

using System;
using System.Linq;
using System.Reflection;
using NHibernate.Cfg;
using NHibernate.Dialect;
using NHibernate.Driver;
using NHibernate.Linq;

namespace NHibernateDemo
{
	internal class Program
	{
		static void Main(string[] args)
		{
			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 customers = from customer in session.Query<Customer>()
					                select customer;
					foreach (var customer in customers)
					{
						Console.WriteLine("{0} {1}", customer.FirstName, customer.LastName);
					}
					tx.Commit();
					Console.WriteLine("Enter any key to exit...");
					Console.ReadKey();
				}
		}
	}
}

С сортировкой по LastName

var customers = from customer in session.Query<Customer>()
									orderby customer.LastName
					                select customer;

Выборка с условием

var customers = from customer in session.Query<Customer>()
									where customer.LastName.Length > 5
									orderby customer.LastName
					                select customer;

или

var customers = from customer in session.Query<Customer>()
									where customer.LastName.StartsWith("A")
									orderby customer.LastName
					                select customer;

nhprof
References -- Manage NuGet Package -- задать в поиске nhprof -- NHibernate Profiler

Saving Data

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 = new Customer { FirstName = "James", LastName = "Kovacs" };
				session.Save(customer);
				tx.Commit();
			}

			using (var session = sessionFactory.OpenSession())
			using (var tx = session.BeginTransaction())
			{
				var query = from customer in session.Query<Customer>()
				where customer.LastName == "Kovacs"
				select customer;

				var retrieved = query.Single();
				Console.WriteLine("{0} {1} {2}", retrieved.FirstName, retrieved.LastName, retrieved.Id);
			}
			Console.WriteLine("Enter any key to exit...");
			Console.ReadKey();

		}
	}
}

//Добавили новую строку в таблицу, вывели её.

Обновить данные Update

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 query = from customer in session.Query<Customer>()
				            where customer.LastName == "Morozov"
				            select customer;
				var c = query.First();
				c.FirstName = "Evgeniy";
				session.Update(c);
				tx.Commit();
			}
			Console.WriteLine("Enter any key to exit...");
			Console.ReadKey();

		}
	}
}

Удалить данные Delete

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 query = from customer in session.Query<Customer>()
				            where customer.LastName == "Morozov"
				            select customer;
				var c = query.First();
				c.FirstName = "Evgeniy";
				session.Delete(c);
				tx.Commit();
			}
		}
	}
}