7. Data Access Layer
by Jason Dentler, Alexander Zaytsev, Gunnar Liljas
NHibernate 4.x Cookbook - Second Edition
- NHibernate 4.x Cookbook Second Edition
- Table of Contents
- NHibernate 4.x Cookbook Second Edition
- Credits
- About the Authors
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Preface
- 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
- 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 <subselect>
- 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
- 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
- 6. Testing
- 7. Data Access Layer
- 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
- Index
In this chapter, we will cover the following topics:
- 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
There are two types of data access layers that are common in today's applications: Repositories and Data Access Objects (DAO). In reality, the distinction between these two has become quite blurred; however, in theory, it's as follows:
- A repository should act like an in-memory collection. Entities are added to and removed from the collection and its contents can be enumerated. Queries are typically handled by sending query specifications to the repository.
- A DAO is simply an abstraction of an application's data access. Its purpose is to hide the implementation details of the database access from the consuming code.
The first recipe shows the beginning of a typical data access object. The remaining recipes show how to set up a repository-based data access layer with NHibernate's various APIs.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.