NHibernate 3.0 Cookbook

NHibernate 3.0 Cookbook

By : Jason Dentler

Buy this Book

NHibernate 3.0 Cookbook

By: Jason Dentler

Buy this Book

Overview of this book

NHibernate is an innovative, 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. The NHibernate Cookbook explains each feature of NHibernate 3.0 in detail through example recipes that you can quickly apply to your applications. Set yourself free from stored procedures and inline SQL. Quite simply, if you build .NET applications that use databases, this book is for you. The book will take you from the absolute basics of NHibernate through its most advanced features and beyond, showing you how to take full advantage of each concept to quickly create amazing database applications. Beginners will learn several techniques for each of the 4 core NHibernate tasks – mapping, configuration, session & 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. Intermediate level readers will 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 v3.0 features, advanced readers will learn creative ways to extend NHibernate core, as well as techniques using the NHibernate search, shards, spatial, and validation projects.

NHibernate 3.0 Cookbook

Credits

About the Author

About the Reviewers

Preface

Free Chapter

Models and Mappings

Introduction

Mapping a class with XML

Creating class hierarchy mappings

Mapping a one-to-many relationship

Setting up a base entity class

Handling versioning and concurrency

Creating mappings fluently

Mapping with ConfORM

Bidirectional one-to-many class relationships

Mappings enumerations

Creating class components

Configuration and Schema

Introduction

Configuring NHibernate with App.config

Configuring NHibernate with hibernate.cfg.xml

Configuring NHibernate with code

Configuring NHibernate with Fluent NHibernate

Configuring NHibernate using ConfORM Mappings

Configuring NHibernate logging

Reducing application startup time

Generating the database

Scripting the database

Using NHibernate Schema Tool

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

Using the Conversation per Business Transaction pattern

Using session.Merge

Using session.Refresh

Using stateless sessions

Using dictionaries as entities

Using NHibernate with TransactionScope

Queries

Introduction

Using Criteria Queries

Using QueryOver

Using QueryOver projections and aggregates

Using MultiCriteria

Using the Hibernate Query Language

Using MultiQuery

Using Named Queries

Using Futures

Eager loading child collections

Using LINQ to NHibernate

Using Detached Queries

Using HQL for bulk data changes

Testing

Introduction

Using NHibernate Profiler

Fast testing with SQLite in-memory database

Preloading data with SQLite

Using the Fluent NHibernate Persistence Tester

Using the Ghostbusters test

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

Extending NHibernate

Introduction

Creating an encrypted string type

Using well-known instance type

Using dependency injection with entities

Creating an audit-event listener

Creating and changing stamping entities

Generating trigger-based auditing

Setting MS Sql's Context Info

Using dynamic connection strings

NHibernate Contribution Projects

Introduction

Configuring the cache

Configuring the cache with code

Property validation with attributes

Creating validator classes

Using the Burrows framework

Setting up full-text search

Sharding databases for performance

Using NHibernate Spatial

ASP.NET MVC web applications

ASP.NET Web Forms applications

WPF and WinForms applications

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Preloading data with SQLite

It is often desirable to preload the database with test data before running tests. In this recipe, I will show you how to quickly load the in-memory database with data from a SQLite file database.

Getting ready

Complete the previous recipe, Fast testing with SQLite in-memory database.

Create a SQLite file database with identical schema, containing test data. This can be accomplished in a number of ways. Perhaps the easiest is to export an in-memory database using SQLiteLoader.ExportData from this recipe.

How to do it...

Add a new class named SQLiteLoader using the following code:

private static ILog log = LogManager.GetLogger(typeof(SQLiteLoader));

private const string ATTACHED_DB = "asdfgaqwernb";

public void ImportData(
  SQLiteConnection conn,
  string sourceDataFile)
{
  
  var tables = GetTableNames(conn);
  AttachDatabase(conn, sourceDataFile);

  foreach (var table in tables)
  {
    var sourceTable = string.Format("{0}.{1}", 
      ATTACHED_DB, table);

...

NHibernate 3.0 Cookbook

By : Jason Dentler

NHibernate 3.0 Cookbook

By: Jason Dentler

Overview of this book

Related Content you might be interested in

Current Title:

NHibernate 3.0 Cookbook

Preloading data with SQLite

Getting ready

How to do it...