INDEX

Symbols

. (dot)

IntelliSense, 26

joins, 55

= (equals sign), Restrictions, 121

> (greater than sign), Restrictions, 121

< (less than sign), Restrictions, 121

A

AbstractQueryImpl, 54

Add(), 70, 95, 107

Add Reference, 10

AddOrder, 32

ADODB.Connection, 1

ADODB.Recordset, 1

ADO.NET, 1–2

adonet.batch_size, 199

aggregate database functions

GetNamedQuery(), 76–80

ICriteria, 126–131

LINQ, 164–168

AggregateResults, 164–165

ALL, 39, 40

AND, 121

And, 121

app.config, 40, 42

batch processes, 199–200

log4net, 37–38

appender-ref, 39

AppendToFile, 38

Application_BeginRequest(), 207

Application_EndRequest(), 207

Application_Start(), 206

appSetting, 42

app/web.config, 24–26

ASP.NET MVC3, 203–212

Controller, 208–212

installation, 204

session-per-web-request, 207

View, 208–212

Assembly, 43

assembly, 15

Assigned, 184

AuditDeleteEvent(), 52

AutoGenerateColumns, 55

AVG, 76, 78, 127, 167

B

<bag>, 17

BaseUserType, 175–176

batch processes

ConfigureNHibernate(), 200

data insertion, 198–202

IStatelessSession, 199

QueryImpl, 201

UPDATE, 199

BeginTransaction(), 172

BETWEEN, 121

Between, 136

binaries, 205

BinaryFormatter, 43–44, 45

/bin/Debug, 40

/bin/release, 40

Build Action, 17

BuildDataTable(), 57, 98, 99, 106

CreateMultiCriteria(), 105

IList, 58

BuildSessionFactory(), 23

Button, 64, 73, 181

DetachedQuery, 81

LINQ, 167

MainWindow.xaml, 49, 51, 89

buttonCount_Click(), 130

buttonMaximum_Click(), 79

buttonMinimum_Click(), 167

buttonNext_Click(), 64–65

buttonPrevious_Click(), 64–65

buttonSearch_Click(), 84, 160

DetachedSearch(), 109

MainWindow.xaml.cs, 81, 109, 137

buttonSubmit_Click(), 182–183, 196

buttonSUM_Click(), 75–76

buttonTotalValue_Click, 89

C

cache, 23

data insertion, 187–194

DataAccess, 191

Evict(), 194–195

ExecuteUpdate(), 202

first-level, 188–189

foreign keys, 189

Get(), 189

IStatelessSession, 202

Load(), 189

second-level, 190–194

strategies, 193

cache.provider_class, 190

cache.use_second_level_cache, 192, 193–194

calculated fields, 66–69

CheckBox, 138

class, 15

<class>, 15

class files, 11–13

Class1.cs, 6

ClassMapping, 17c

Click, 49, 79, 127

LINQ, 167

MainWindow.xaml, 51–52

collections, 16–17

column, 15–16

ComboBox, 33, 51

DataGrid, 34–35, 101, 151

Id, 56, 101

MainWindow.xaml.cs, 121

Common, 6, 186

Common, 6

concurrency control, 172

concurrency strategy

isolation levels, 171–172

optimistic control, 172

pessimistic control, 172

state, 170–175

versioning, 173–175

<configSections>, 25

configuration, 10–29

ASP.NET MVC3, 204–212

class files, 11–13

FetchMode, 123–126

log4net, 37–40

mapping by code, 18–19

mapping files, 13–18

property-ref, 19

serialization, 42–45

techniques, 19–28

Configuration, 20–21, 44, 47

GetNamedQuery(), 73

SessionFactory, 24

<configuration>, 25

ConfigurationManager, 42

ConfigureNHibernate(), 23, 27, 44, 200

Interceptor, 47

ConnectionProvider, 19–20

ConnectionString, 19–20, 25

connectionString, 204, 205–207

console application

creating, 6–7, 28–29

lambda expressions, 160

Contains(), 151–152

Controller, 208–212

COUNT, 76

Count, 127, 130

CountDistinct, 127

CreateCriteria, 98–105, 132

CreateCriteria(), 95, 98, 107, 120

CreateCriteria<T>(), 98

CreateMultiCriteria(), 105–108, 119

CreateMultiQuery(), 69–73, 86

CreateQuery, 53, 63

CreateQuery(), 57–69

CriteriaImpl, 92, 112, 119

CurrentSessionContext, 206

CustomIdGenerator, 185

D

DAL. See data access layer

data access layer (DAL), 8

data insertion, 180–194

batch processes, 198–202

cache, 187–194

parent/child, 185–187

data transfer object (DTO), 139–143

DataAccess, 6, 179, 191

DataAccess, 6

database management systems (DBMSs)

CreateMultiQuery(), 72

DriverClass, 19–20

DataGrid, 30, 31, 51, 72

BuildDataTable(), 57, 98, 106

ComboBox, 34–35, 101, 151

detached objects, 170

ExecuteDetachedQuery(), 81

GetNamedQuery(), 73

PopulateDataGrid(), 61

WPF, 56

DataTable, 57, 98

DateTime, 11–12

DBMSs. See database management systems

DEBUG, 39, 40

DefaultProxyFactory, 20

DELETE, 199

Deserialize(), 43–44

detached objects, 170

DetachedCriteria, 92, 109–111, 132

DetachedNamedQuery, 83–85

DetachedQuery, 80–83, 84

DetachedSearch(), 109

Dialect, 19–20, 25

Distinct, 127

DriverClass, 19–20

Driver_Class, 25

DriverConnectionProvider, 20

DTO. See data transfer object

E

Embedded Resource, 17, 141

entity, 11

Eq, 121

ERROR, 39

Event, 48–52

Evict(), 194–195

ExecuteCriteria<T>(), 208, 209

ExecuteDetachedQuery(), 81

ExecuteHQL<T>(), 208

ExecuteICriteriaOrderBy(), 32

ExecuteICriteria<T>(), 32

ExecuteNamedQuery(), 75–76

ExecuteUpdate(), 201, 202

Expression, 131–139

F

FATAL, 39

fetch, 36, 95

FetchMode, 123–126

FetchMode.Default, 125

FetchMode.Eager, 125

FetchMode.Join, 125

FetchMode.Lazy, 125

FetchMode.Select, 125

FileInfo, 43

FileStream, 41

first-level cache, 188–189

Flush(), 170

foreach, 199

Foreign, 184

foreign keys, 3, 9, 19, 189

Future(), 47

CreateCriteria(), 120

CriteriaImpl, 119

HQL, 85–89

ICriteria, 119–122

QueryOver, 116

Future<T>(), 85

FutureValue<T>(), 85, 86

G

Get(), 189

{get: set:}, 12

GetCountByTypeHQL, 79

GetCurrentSession(), 206, 209, 210

GetExecutableQuery(), 83, 84

GetInventoryPaging(), 86

GetLogger, 40

GetNamedQuery, 53

GetNamedQuery()

aggregate database functions, 76–80

HQL, 73–80

GetResult(), 70

Global.asax.cs, 204

Group, 127

Gt, 121

GUID, 10, 184

Guid, 184

guid.comb, 10, 183–184

H

.hbm.xml, 40–41, 45, 125

Embedded Resource, 141

IUserType, 178–179

versioning, 174

*.hbm.xml, 13

HI, 184

Hibernate Query Language (HQL), 3, 23, 29, 53–90. See also specific HQL elements

calculated fields, 66–69

CreateMultiQuery(), 69–73

CreateQuery(), 57–69

DetachedNamedQuery, 83–85

DetachedQuery, 80–83

Future(), 85–89

GetNamedQuery(), 73–80

paging, 61–65

PopulateDataGrid(), 88–89

round-trip database counter, 65–66

strongly typed configuration, 55, 57

hibernate-mapping, 15

<hibernate-mapping>, 15

Hilo, 184

HLO, 184

HQL. See Hibernate Query Language

HttpContext, 206

I

ICriteria, 23, 29, 55, 91–144

AddOrder, 32

aggregate database functions, 126–131

data transfer object (DTO), 139–143

Expression, 131–139

fetch, 95

FetchMode, 123–126

Future(), 85, 119–122

Interceptor, 46

joins, 93

lambda expressions, 118–119

lazy loading, 36

LINQ, 147

Nhibernate.Criterion, 32

paging, 102–105

QueryOver, 112–118

Restrictions, 93–94, 131–139

SetFirstResult(), 102

SetMaxResults(), 102

SQL queries, 93

ID, 3, 9, 19

Id, 56, 101, 209

id, 15

id generators, 184–185

<idbag>, 17

IDENTITY, 184

Identity, 184

IInterceptor, 46

IList, 58, 152

IList<T>, 208

ILMerge, 146

Image, 50

IMultiCriteria, 23, 107

IMultiQuery, 23, 70

IN, 121

In, 121

Index.aspx, 211

INFO, 39

Initialize(), 23

InnerException.Message, 29

INSERT, 186, 199

Insert(), 199

insert="false", 186

installation, 10

ASP.NET MVC3, 204

XML schema templates, 13–14

int, 86

IntelliSense, 13, 26

Interceptor, 46–48

Event, 48

implementing, 49–52

OnPrepareStatement(), 47

OpenSession(), 48

INVERSE, 187

IQuery, 3, 23, 29, 53, 54

aggregate database functions, 130

Future(), 85

GetExecutableQuery(), 83

Interceptor, 46

LINQ, 147

SetFirstResult(), 61

SetMaxResults(), 61

IQueryOver, 23

ISerializable, 41

ISession, 97, 98, 208, 209

IsNotNull, 121

IsNull, 121

isolation levels, 171–172

IStatelessSession, 97–98, 106, 199, 202

IUserType

BaseUserType, 175–176

.hbm.xml, 178–179

state, 175–180

J

JBoss, 2

JOIN, 93

join, 36

joins, 55, 93

jpGrid, 212

jQuery, 211

Json, 209

L

Label, 181

lambda expressions

console application, 160

ICriteria, 118–119

LINQ, 157–164

LastWriteTime, 43

lazy loading, 11, 35–36

private field value, 12

Session, 23

Le, 121

LIKE, 111, 121

Like, 121

LINQ, 29, 145–168

aggregate database functions, 164–168

AggregateResults, 164–165

buttonMinimum_Click(), 167

Contains(), 151–152

ICriteria, 147

IList, 152

IQuery, 147

Json, 209

lambda expressions, 157–164

operators, 145–146

paging, 153–157

QueryOver, 147

Query<T>(), 148

Skip(), 153–157

SUM, 165

Take(), 153–157

ToFuture(), 155–156, 162–163

List(), 53, 56, 84

<list>, 17

List<T>, 170

List<T>(), 53, 56, 84

Load(), 121, 189

LoadConfigurationFromFile(), 44

log4net, 37–40

log4net.dll, 40

LogManager, 40

long, 86

lost update problem, 172

LOW, 184

Lt, 121

M

Main(), 25, 117, 134

MainWindow, 30, 181

MainWindow.xaml, 30–31

Between, 136

Button, 49, 51, 89

CheckBox, 138

Click, 51–52

ComboBox, 33

Image, 50

MainWindow.xaml.cs, 64–65

buttonMaximum_Click(), 79

buttonSearch_Click(), 81, 84, 109, 137, 160

buttonSubmit_Click(), 196

buttonSUM_Click(), 75–76

ComboBox, 121

PopulateDataGrid(), 104, 113, 149, 163

SetDataBaseRoundTripImage(), 50

MainWindow.xml.cs, 99

ManagedWebSessionContext, 206

many-to-one, 185–186

Mapping, 6, 192

Mapping, 6

mapping by code, 18–19

mapping files

configuration, 13–18

deploying, 17–18

FetchMode, 123–124

SessionFactory, 73

SQL queries, 14

mapping/class.hbm.xml, 14–17

MappingException, 174

MAX, 76, 127, 166–167

maxResult, 117

maxSizeRollBackups, 38

MemCache, 190

Merge(), 170, 195–197

metadata, 16

MIN, 76, 127, 165–166, 168

Model, 56

MouseDoubleClick, 195–196

MoveFirst(), 1

MoveLast(), 1

MoveNext(), 1

MovePrevious(), 1

MultiCriteria, 47

MultiQuery, 47

N

name, 15–16

name="hibernate-configuration", 25

namespace.class, 185

Native, 184

NHErrorLog, 39

NHibernate.AdoNet.Util.BasicFormatter.Format(), 47

NHibernateBase, 10

NHibernateBase.ConfigureNHibernate(), 41

NHibernateBase.cs, 21–24, 27

NHibernate.Cfg.Configuration, 19, 23

NHibernate.Cfg.Environment.cs, 19

NHibernate.Criterion, 92

DetachedCriteria, 109

ICriteria, 32

Projection, 126

NHibernate.Driver, 9

SupportMultipleQueries(), 108

NHibernate.EmptyInterceptor.cs, 46

NHibernate.Event, 48

NHibernate.FetchMode, 125

NHibernate.Impl, 54, 81, 119

NHibernate.ISession.cs, 23

NHibernate.ISessionFactory, 19

NHibernate.ITransaction, 23

NHibernate.Mapping.ByCode.Conformist, 17

NHibernate.NonUniqueObjectException, 197

NHibernate.Proxy, 20

NHLog, 40

NHLog.txt, 38

NhQueryProvider, 148

nonstrict-read-write, 193

NOT, 121

Not, 121

NullSafeGet(), 176–177

NullSafeSet(), 176–177

O

object-relational mapping (ORM), 3–4

ODP.NET, 20

OID, 19

OnDelete(), 46

OnLoad(), 46

OnPrepareStatement(), 46, 47

OnSave(), 46

OPD.NET, 78

OpenSession(), 23, 48

OpenStatelessSession(), 98

optimistic control, 172

OR, 121

Or, 121, 136

Oracle

CreateMultiQuery(), 73

OPD.NET, 78

rownum, 19

OracleDataClientDriver, 20

OrderBy(), 161–162

orderBy, 30

ORM. See object-relational mapping

P

paging

HQL, 61–65

ICriteria, 102–105

LINQ, 153–157

PopulateDataGrid(), 63–64

parent/child, 185–187

Persist(), 170, 198

persistent objects, 170, 195–197

pessimistic control, 172

PopulateComboBox(), 33

PopulateDataGrid(), 99

CreateMultiCriteria(), 107–108

CreateMultiQuery(), 71

DataGrid, 61

HQL, 88–89

Load(), 121

MainWindow.xaml.cs, 104, 113, 149, 163

paging, 63–64

QueryOver, 113–114, 117

SetDataBaseRoundTripImage(), 66

strongly typed configuration, 69

Prevalence, 190

Price, 56

primary keys, 9, 10

private field value, 12

Program, 25, 134

Program.cs, 117

Projection, 126

property, 15

PropertyNotFoundException, 15

property-ref, 19

PropertyValueException, 12

proxy, 11

ProxyFactory, 19–20

pseudo-foreign keys, 19

Q

QOH, 56

QueryableBase<T>(), 146

QueryCounter, 47, 105

query.hbm.xml, 73–74

QueryImpl, 54, 201

QueryOver

CriteriaImpl, 112

Future(), 116

ICriteria, 112–118

LINQ, 147

PopulateDataGrid(), 113–114, 117

Take(), 117

Query<T>(), 148

R

read-only, 193

ReadUncommitted, 171

read-write, 193

Received, 11–12

RedCommitted, 171

Reference, 205

References, 10

reflection, 16

regsrv32.exe, 1

Relationships, 8

Remotion.Data.Linq.dll, 146

RepeatableRead, 171

Restrictions, 35

DetachedCriteria, 132

ICriteria, 93–94, 131–139

Rollback(), 23

ROUND, 78

round-trip database counter, 49–51, 65–66

RowCount, 127

rownum, 19

S

Save(), 183, 184, 186–187

IStatelessSession, 199

SaveOrUpdate(), 170, 197

second-level cache, 190–194

SELECT, 97, 189

select count(*), 72

SelectionChanged(), 34–35, 150–151

lazy loading, 36

Seqhillo, 184

SEQUENCE, 184

Sequence, 184

Serializable, 171

serialization, 41

configuration, 42–45

ConfigureNHibernate(), 44

Serialize(), 45

SerializedConfiguration, 41–42

Server.CreateObject, 1

Session

batch processes, 198–201

cache, 188

detached objects, 170

DetachedQuery, 80

GetCurrentSession(), 210

Interceptor, 47

lazy loading, 23

Session.CreateQuery(), 54

SessionFactory, 10, 20–21

batch processes, 200

Configuration, 24

GetCurrentSession(), 206, 209

Global.asax.cs, 205–206

mapping files, 73

OpenSession(), 23, 48

OpenStatelessSession(), 98

session-factory, 200

SessionImpl, 201

session-per-web-request, 207

Sessions, 19

<set>, 17

SetDataBaseRoundTripImage(), 50, 66

SetFirstResult(), 61, 102

SetInterceptor(), 47

SetMaxResults(), 61, 102

SetParameter(), 148

SharedCache, 190

showDetails, 212

show_sql, 29, 117

Skip(), 153–157

Snapshot, 171

SQL queries

DAL, 8

Future(), 119

GetNamedQuery(), 73–80

ICriteria, 93

mapping files, 14

ORM, 3–4

View SQL, 108

SQL Server, 7

CreateMultiQuery(), 72

SqlClientDriver, 20

SqlClientDriver, 20

sql-query, 74

SqlQueryImpl, 74, 201

StaleObjectException, 23

batch processes, 201

versioning, 175

state, 169–180

concurrency strategy, 170–175

detached objects, 170

IUserType, 175–180

persistent objects, 170, 195–197

StatelessSession, 199

Stopwatch, 45

strongly typed configuration, 19, 26–28

DetachedQuery, 84

FutureValue<T>(), 86

HQL, 55, 57

PopulateDataGrid(), 69

second-level cache, 191–192

SubGridRowExpanded, 212

SUM, 76, 127, 165

SupportMultipleQueries(), 108

SysCache, 190

SysCache2, 190

System.Configuration, 41

System.DateTime, 11

System.Diagnostics, 45

System.IO, 43

System.Linq.Expression, 119

System.Linq.IQueryProvider, 148

System.Reflection, 43

T

TabControl, 181–182, 196

table, 15

Table Designer, 8

Take()

LINQ, 153–157

QueryOver, 117

TextBox, 181, 196

ThenByDescending(), 161–162

ThreadStaticSessionContext, 207

ToFuture(), 155–156, 162–163

transactional, 193

Transformers, 139–140

transient objects, 197

Persist(), 198

state, 170

try…catch, 23, 29

TYPE, 9

type, 15

TYPEID, 3, 186

U

uniqueidentifier, 9

UPDATE, 186, 199

Update(), 170

Utils, 46–47, 105

V

validation

.hbm.xml, 45

serialized configuration, 42–43

value comparison logic, 131

value types, 11–12

varchar(), 9

Velocity, 190

VERSION, 174

<version …>, 174

versioning, 173–175

View

ASP.NET MVC3, 208–212

Index.aspx, 211

View SQL, 72, 108, 183

Visual Studio, 5

XML schema templates, 13

W

WARN, 39

WcfOperationSessionContext, 206

Web.config, 204, 205–207

WebSessionContext, 207

WHERE, 55, 121, 174

Where, 121

Window_Loaded(), 30, 51

CreateQuery, 63

PopulateComboBox(), 33

Windows Presentation Foundation (WPF), 3, 56

X

XML schema templates, 13–14