Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

NHibernate 4.x Cookbook - Second Edition

By : Liljas, Darshan Joshi, Zaytsev, Jason Dentler

5 (1)

NHibernate 4.x Cookbook

5 (1)

By: Liljas, Darshan Joshi, Zaytsev, Jason Dentler

Overview of this book

NHibernate is a mature, flexible, scalable, and feature-complete open source project for data access. Although it sounds like an easy task to build and maintain database applications, it can be challenging to get beyond the basics and develop applications that meet your needs perfectly. NHibernate allows you to use plain SQL and stored procedures less and keep focus on your application logic instead. Learning the best practices for a NHibernate-based application will help you avoid problems and ensure that your project is a success. The book will take you from the absolute basics of NHibernate through to its most advanced features, showing you how to take full advantage of each concept to quickly create amazing database applications. You will learn several techniques for each of the four core NHibernate tasks—configuration, mapping, session and transaction management, and querying—and which techniques fit best with various types of applications. In short, you will be able to build an application using NHibernate by the end of the book. You will also learn how to best implement enterprise application architecture patterns using NHibernate, leading to clean, easy-to-understand code and increased productivity. In addition to new features, you will learn creative ways to extend the NHibernate core, as well as gaining techniques to work with the NHibernate search, shards, spatial, envers, and validation projects.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Sections

Conventions

Reader feedback

Customer support

Free Chapter

1. The Configuration and Schema

1. The Configuration and Schema

Introduction

Installing NHibernate

Configuring NHibernate with hibernate.cfg.xml

Configuring NHibernate with App.config or Web.config

Configuring NHibernate with code

Configuring NHibernate with Fluent NHibernate

Configuring NHibernate logging

Generating the database

Scripting the database

Updating the database

Using NHibernate schema tool

2. Models and Mappings

2. Models and Mappings

Mapping a class with XML

Creating class hierarchy mappings

Creating class components

Mapping a one-to-many relationship

Mapping a many-to-many relationship

Mapping collections of elements and components

Setting up a base entity class

Handling versioning and concurrency

Mapping by code

Mapping by convention

Creating mappings fluently

Bidirectional one-to-many class relationships

Mapping enumerations

Immutable entities

Mapping relations to non-primary keys

Using lazy properties

Mapping joins

Using calculated properties

Using serializable values

Dynamic components

Mapping

3. Sessions and Transactions

3. Sessions and Transactions

Introduction

Setting up session-per-web request

Setting up session-per-presenter

Creating a session ASP.NET MVC action filter

Creating a transaction ASP.NET MVC action filter

Save entities to the database

Using session.Merge

Using session.Refresh

Handle concurrency using session.Lock

There's more…

Using dictionaries as entities

Using NHibernate with transaction scope

4. Queries

4. Queries

Introduction

Query entities by ID

Using LINQ to NHibernate

Using CriteriaQueries

Using QueryOver

Using QueryOver projections and aggregates

Using the Hibernate Query Language

Using native SQL

Eager loading with LINQ

Eager loading with Criteria

Eager loading with QueryOver

Eager loading with HQL

Eager loading with SQL

Using named queries

Using detached queries

Using HQL for bulk data changes

Filtering collections

Using result transformers

Extra lazy collections

5. Improving Performance

5. Improving Performance

Reducing application startup time

Using MultiCriteria

Using MultiQuery

Using Futures

Eager loading child collections

Using stateless sessions

Using read-only entities

Use the second-level cache

Configuring the second-level cache with code

Sharding databases for performance

6. Testing

6. Testing

Introduction

Using NHibernate Profiler

Profiling NHibernate with Glimpse

Fast testing with the SQLite in-memory database

Preloading data with SQLite

Using Fluent NHibernate persistence testing

Using the Ghostbusters test

7. Data Access Layer

7. Data Access Layer

Introduction

Transaction auto-wrapping for the data access layer

Setting up an NHibernate repository

Using named queries in the data access layer

Using ICriteria in the data access layer

Using paged queries in the data access layer

Using LINQ specifications in the data access layer

8. Extending NHibernate

8. Extending NHibernate

Introduction

Creating an encrypted string type

Creating a money type

Using well-known instance types

Using dependency injection with entities

Creating an audit-event listener

Creation and change stamping of entities

Generating trigger-based auditing

Implementing a soft-delete pattern

Setting Microsoft SQL's Context_Info

Using dynamic connection strings

Using custom dialect functions

Using custom functions in LINQ

Extending the LINQ provider

9. NHibernate Contribution Projects

9. NHibernate Contribution Projects

Introduction

Property validation with attributes

Creating validator classes

Setting up full-text searches

Auditing data with Envers

Using NHibernate Spatial

Index

Index

Customer Reviews

5 (1)

5 star

100%

4 star

0%

3 star

0%

2 star

0%

1 star

0%

Configuring NHibernate with Fluent NHibernate

The third-party Fluent NHibernate library has its own syntax to configure NHibernate. In this recipe, we'll show you how to configure NHibernate using this syntax.

Getting ready

Complete the steps in Installing NHibernate recipe.
Add a console application project to your solution called ConfigByFNH.
Set it as the Startup project for your solution.
Install NHibernate to the ConfigByFNH project using NuGet Package Manager Console.
Install the package FluentNHibernate to ConfigByFNH project using NuGet Package Manager Console.
In ConfigByFNH, add a reference to the Eg.Core project.

How to do it…

Add an App.config file with this configuration:

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="db" connectionString="Server=.\SQLEXPRESS; Database=NHCookbook; Trusted_Connection=SSPI" />
  </connectionStrings>
</configuration>

In Program.cs, add the following using statements:

using FluentNHibernate.Cfg;
using FluentNHibernate.Cfg.Db;

In the Main method, add this code:

var config = MsSqlConfiguration.MsSql2012
  .ConnectionString(connstr => connstr.FromConnectionStringWithKey("db"))
  .AdoNetBatchSize(100);
var nhConfig = Fluently.Configure()
  .Database(config)
  .BuildConfiguration();
var sessionFactory = nhConfig.BuildSessionFactory();
Console.WriteLine("NHibernate configured fluently!");
Console.ReadKey();

Build and run your application. You should see the text NHibernate configured fluently!

How it works…

Our fluent configuration can be broken down into three parts. First, we configure these properties:

We set the dialect property to MsSql2012Dialect when we use the MsSql2012 static property of MsSqlConfiguration.
The connection.connection_string_name object is set to db with a call to FromConnectionStringWithKey.
We set adonet.batch_size to 100 with a call to AdoNetBatchSize.

Next, from the fluent configuration, we build a standard NHibernate configuration. Finally, we build a session factory using the BuildSessionFactory method.

See also

Configuring NHibernate with App.config or Web.config
Configuring NHibernate with XML
Configuring NHibernate with code

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

NHibernate 4.x Cookbook

Search

Your notes and bookmarks