10. Working with Legacy Database | Learning NHibernate 4

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Learning NHibernate 4

By : Suhas H Chatekar

3.6 (9)

Learning NHibernate 4

3.6 (9)

By: Suhas H Chatekar

Overview of this book

This book targets .NET developers who have never used an ORM before, developers who have used an ORM before but are new to NHibernate, or have used NHibernate sparingly and want to learn more about NHibernate.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Introduction to NHibernate

1. Introduction to NHibernate

What is ORM?

What is NHibernate?

What is new in NHibernate 4.0?

NHibernate for users of Entity Framework

Is using ORM a bad idea?

Building blocks of NHibernate

Summary

2. Let's Build a Simple Application

2. Let's Build a Simple Application

Explaining the approach used in learning NHibernate

The problem statement

The development setup

The domain model

Adding some code

Summary

3. Let's Tell NHibernate About Our Database

3. Let's Tell NHibernate About Our Database

Important NHibernate terminology

Mapping the prerequisites

Different mechanisms to write the mappings

XML mappings for the Employee class

Identifier generation

Mapping associations

Mapping inheritance

Mapping components

Mapping by code

Fluent mapping a.k.a. Fluent NHibernate

Choosing the right mapping method

Summary

4. NHibernate Warm-up

4. NHibernate Warm-up

Warming up NHibernate succinctly

The NHibernate session architecture

XML configuration

Programmatic configuration

Loquacious configuration

Fluent configuration

Configuration options

Generating the database scripts from mappings

Summary

5. Let's Store Some Data into the Database

5. Let's Store Some Data into the Database

Entity states

Transactions and unit of work

Saving entities

Transitive persistence using cascade styles

Transitive persistence/cascading in action

Bidirectional associations and ownership

Order of operations

Entity equality

The architecture diagram

Summary

6. Let's Retrieve Some Data from the Database

6. Let's Retrieve Some Data from the Database

Querying the workflow

Different querying methods

Joins

Lazy loading

Eager fetching

Pagination and ordering of results

Retrieving entities by identifiers

Polymorphic queries

Summary

7. Optimizing the Data Access Layer

7. Optimizing the Data Access Layer

Baseline and optimize

Organization of the chapter

Batching

Fetching strategies

Avoiding the select N+1 problem

Avoiding eager fetching

Using extra-lazy for lazy collections

Summary

8. Using NHibernate in a Real-world Application

8. Using NHibernate in a Real-world Application

What kind of application are we building?

Architectural principles we will follow

Feature 1 – onboarding an employee

Unit of work

Feature 2 – updating the details of an employee

Feature 3 – searching employees

Summary

9. Advanced Data Access Patterns

9. Advanced Data Access Patterns

Problems with the repository pattern

Specification pattern

Query object pattern

Summary

10. Working with Legacy Database

10. Working with Legacy Database

Composite IDs

Components

Join-mapping to load data from multiple tables

Working with database views

Using subselect instead of views

Working with stored procedures

Using custom DTOs

Summary

11. A Whirlwind Tour of Other NHibernate Features

11. A Whirlwind Tour of Other NHibernate Features

Concurrency control

Event system

Caching

Stateless sessions

User-defined types

Summary

Index

Index

Customer Reviews

3.6 (9)

5 star

33.3%

4 star

33.3%

3 star

0%

2 star

22.2%

1 star

11.1%

Using subselect instead of views

Views cater to the situation where we want to read data from multiple legacy tables and map it to a single domain entity. But under the hood, view is just a SELECT query. NHibernate offers another way to deal with the SELECT query directly, so that there is no need to have a view created in the database. This can be useful when you are not able to create views in the database for some reason. Some RDMBS have limited support for views, in which case we could use a subselect feature.

In a subselect feature, we would use the same query that we used to create the view, but this time, we will map to the entity directly. The following mapping definition demonstrates this:

public class EmployeeSubselectMapping : ClassMapping<Employee>
{
  public EmployeeSubselectMapping()
  {
    Subselect(@"SELECT dbo.Employee.Id, dbo.Employee.Firstname,
    dbo.Employee.Lastname, dbo.Employee.DateOfJoining,
    dbo.Address.AddressLine1, dbo.Address.AddressLine2
    FROM dbo...

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.

Learning NHibernate 4

Search

Your notes and bookmarks