5. Let's Store Some Data into the 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%

Saving entities

As with previous chapter, we will begin by going through a piece of code we had used in Chapter 3, Let's Tell NHibernate About Our Database. If you can remember, we had used the following code to save an instance of the Employee class in the database:

object id = 0;
using (var transaction = Session.BeginTransaction())
{
  id = Session.Save(new Employee
  {
    EmployeeNumber = "5987123",
    Firstname = "Hillary",
    Lastname = "Gamble",
    EmailAddress = "[email protected]",
    DateOfBirth = new DateTime(1980, 4, 23),
    DateOfJoining = new DateTime(2010, 7, 12),
    IsAdmin = true,
    Password = "Password"
  });
  transaction.Commit();
}

We started with call to Session.BeginTransaction which signaled NHibernate to begin a fresh transaction for us. We then created a new instance of the Employee class, set required properties on it, and passed it into the Save method on session. The Save method on the ISession interface is one of the persistence APIs offered...

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