Справочник по языку C++

[Heidel]

http://msdn.microsoft.com/ru-ru/library/3bstk3k5.aspx

@темы: C++, Справочник по языку C++, Ссылки

---

NHibernate - Lesson 3. Configuration

[Heidel]

NHibernate. Configuration

2 способа конфигурации

• XML


• Code-based

Один из способов

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

Либо

var cfg = new Configuration();
cfg.Configure("hibernate.cfg.xml");
var sessionFactory = cfg.BuildSessionFactory();

Файл hibernate.cfg.xml

<?xml version="1.0" encoding="utf-8" ?> 
<hibernate-configuration xmlns ="urn:nhibernate-configuration-2.2">
	<session-factory>
		<property name="connection.connection_string_name">default</property>
		<property name="connection.driver_class">Nhibernate.Driver.SqlClientDriver</property>
		<property name="dialect">Nhibernate.Dialect.MsSql2008Dialect</property>
		<mapping assembly ="NHibernateDemo" />
	</session-factory>
</hibernate-configuration>

Свойство xml-файла Copy to Оutput Directory установить как Copy if newer

запись создана: 30.07.2013 в 11:44

@темы: БД, NHibernate, NHibernate Pluralsight Training

---

NHibernate - Lesson 2. Primary Key Generation

[netcat-na-diary]

@темы: БД, NHibernate, NHibernate Pluralsight Training

---

NHibernate - Lesson 2. Mapping Components

[Heidel]

Класс Customer.cs

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 virtual Location Adress { get; set; }

		public override string ToString()
		{

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

	public class Location
	{
		public virtual string Street { get; set; }
		public virtual string City { get; set; }
		public virtual string Province { get; set; }
		public virtual string Country { get; set; }
	}

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

XML-файл 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="AverageRating"/>
		<property name="Points"/>
		<property name="HasGoldStatus"/>
		<property name="MemberSince" type="UtcDateTime"/>
		<property name="CreditRating" type="CustomerCreditRatingType"/>

		<component name="Adress">
			<property name="Street"/>
			<property name="City"/>
			<property name="Province"/>
			<property name="Country"/>
		</component>
	</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();

			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("\nAfter 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.Good,
				AverageRating = 42.44454647,
				Adress = new Location()
				{
					Street = "123 Somewhere Avenue",
					City = "Nowhere",
					Province = "Alberta",
					Country = "Canada"
				}
			};
		}
	}
}

БД

@темы: БД, NHibernate, NHibernate Pluralsight Training

---

Типы данных (Transact-SQL)

[Heidel]

http://msdn.microsoft.com/ru-ru/library/ms187752.aspx

@темы: БД, SQL, MSSQL, Ссылки

---

NHibernate - Lesson 2. Common Mapping Gotchas

[Heidel]

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 знака после запятой)

@темы: БД, NHibernate, NHibernate Pluralsight Training

---

NHibernate - Lesson 2. Basic Mapping and Persistence

[Heidel]

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>
	{
	}
}

@темы: БД, NHibernate, NHibernate Pluralsight Training, Ссылки

---

Сортировка в .NET

[Heidel]

http://habrahabr.ru/post/188012/

@темы: Алгоритмы, С#, Сортировка в .NET, .NET

---

Сложности алгоритмов

[Heidel]

http://habrahabr.ru/post/188010/

@темы: Алгоритмы, Сложности алгоритмов

---

Learn How to Program with C++

[Heidel]

http://rutracker.org/forum/viewtopic.php?t=4495019

@темы: C++

---

C++/CLI

[Heidel]

C++/CLI — привязка языка программирования С++ к среде программирования .NET фирмы Microsoft.

wiki

http://habrahabr.ru/post/47732/

@темы: С#, C++/CLI, .NET, ASP.NET

---

NHibernate - Lesson 1. Getting Started

[Heidel]

из курса 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();
			}
		}
	}
}

@темы: NHibernate, NHibernate Pluralsight Training

---

NHibernate

[Heidel]

NHibernate Fundamentals (pluralsight-training.net) http://rutracker.org/forum/viewtopic.php?t=4004950

Summer of NHibernate Screencast Series
http://www.summerofnhibernate.com/

@темы: NHibernate, Ссылки

---

С# в задачах и примерах

[Heidel]

http://www.ozon.ru/context/detail/id/18569531/

@темы: С#, Ссылки

---

Алгоритмы

[Heidel]

http://algolist.ru/

@темы: Алгоритмы, Математика, Ссылки

---

Дискретная Математика для Программистов

[Heidel]

Ф.А. Новиков: Дискретная Математика для Программистов
http://masandilov.ru/books/other/

@темы: Математика, Дискретная Математика для Программистов, Ссылки

---

Нейронные сети

[Heidel]

Обучающий курс Основы теории нейронных сетей
http://www.intuit.ru/studies/courses/88/88/info

Искусственные нейронные сети
http://bigor.bmstu.ru/?cnt/?doc=NN/base.cou

Нейронные сети, нейроинформатика
http://algolist.ru/ai/neuro/

@темы: Нейронные сети, Нейроинформатика, Основы теории нейронных сетей, Искусственные нейронные сети, Ссылки

---

Исключить деление на нуль, используя тернарный оператор

[Heidel]

// Исключить деление на нуль, используя оператор ?. 

using System;

namespace Test2
{
	class Program
	{
		static void Main(string[] args)
		{
			int result; 
			for(int i = -5; i < 6; i++) 
			{ 
				result = i != 0 ? 100 / i : 0; 
				if (i != 0) 
				Console.WriteLine ("100 / " + i + " равно " + result);
				Console.ReadKey();
			} 
		}
	}
}

@темы: С#, Исключить деление на нуль, используя тернарный оператор

---

Применение поразрядного оператора И

[Heidel]

// Применить поразрядный оператор И, чтобы определить, 
// является ли число нечетным. 
  using System; 
    class IsOdd { 
      static void Main() { 
         ushort num; 
 
         num = 10;        
         if((num & 1) == 1) 
         Console.WriteLine("He выводится."); 
        
         num = 11; 
         if((num & 1) == 1) 
         Console.WriteLine(num + " — нечетное число."); 
      } 
  } 

@темы: С#, Применение поразрядного оператора И

---

Сортировка выбором

[Heidel]

Сортировка выбором Wiki

Задан массив действительных чисел a1, a2 ,... an. Упорядочить данный
массив по возрастанию, используя сортировку линейным выбором с обменом.

C#

using System;
 
//Задан массив действительных чисел a1 ,a2,... an. Упорядочить данный
//массив по возрастанию, используя сортировку линейным выбором с обменом.
 
namespace Massiv4
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.Write("Введите размерность массива n = ");
            int n = Convert.ToInt32(Console.ReadLine());
            double[] mas = new double[n];
            Random rand = new Random();
            for (int i = 0; i < mas.Length; ++i)
            {
                mas[i] = rand.NextDouble() * 100;
            }
            
            ShowMassiv(mas, "Исходный массив:");
            SortMassiv(ref mas);
            ShowMassiv(mas, "Отсортированный массив:");
 
            Console.ReadKey();
        }
 
        //Вывод массива
        static void ShowMassiv(double[] mas, string str)
        {
            Console.WriteLine(str);
            for (int i = 0; i < mas.Length; ++i)
            {
                Console.Write("{0:#.##} ", mas[i]);
            }
            Console.WriteLine();
        }
 
        //Сортировка массива
        static void SortMassiv(ref double[] mas)
        {
            for (int i = 0; i < mas.Length - 1; i++)
            {
                int min = i;
                for (int j = i + 1; j < mas.Length; j++)
                {
                    if (mas[j] < mas[min])
                    {
                        min = j;
                    }
                }
                if (min != i)
                {
                    double temp = mas[i];
                    mas[i] = mas[min];
                    mas[min] = temp;
                }
            }
        }
    }
}

C++

for (int i = 0; i < n - 1; ++i)
	{
		int min = i;
		for (int j = i + 1; j < n; ++j)
		{
			if(mas[min] < mas[j]) continue;
			min = j;
		}
		if (min != i)
		{
			double temp = mas[i];
			mas[i] = mas[min];
			mas[min] = temp;
		}
	}

@темы: Алгоритмы, C++, Сортировка, С#, Сортировка выбором