关系：关系型数据库。
对象：实体对象类
映射：XML文件，指定实体类与表的对应关系。
在这里需要我们操作的就有两点：编写实体对象类，配置映射文件。这两部份一般不需要我们手动编写，我们可以使用CodeSmith的模板来生成。
一、R-关系部份
以下面的数据库为例：
create database mydb
go
use mydb
go
--水果表
create table Fruit
(
Ids varchar(50) primary key,
[Name] varchar(50) not null,
Price decimal(8,2),
Source varchar(50),
Stack varchar(50),
Numbers int, --库存数量
[Image] varchar(50)
)
go
insert into fruit values('k001','苹果',2.4,'烟台','2',100,'image/0.gif')
insert into fruit values('k002','菠萝',1.4,'广东','3',100,'image/1.gif')
insert into fruit values('k003','桔子',2.4,'福州','3',100,'image/2.gif')
insert into fruit values('k004','葡萄',2.4,'新缰','2',100,'image/3.gif')
insert into fruit values('k005','樱桃',2.4,'青岛','4',100,'image/4.gif')
insert into fruit values('k006','桃子',2.4,'花果山','5',100,'image/5.gif')
insert into fruit values('k007','香蕉',2.4,'济南','5',100,'image/6.gif')
Fruit表是一个独立的单一表，我们以此表为例，研究如何配置ORM框架，并实现增、删、改、查功能
二、O-对象部份
第一步：新建一个类库Common
第二步：向Common项目中添加NHibernate.dll引用
第三步：使用CodeSmith执行NHibernate.cst文件生成实体类和映射文件
《图1》
Fruit.cs的文件代码如下：
using System;
using System.Collections;
using System.Web.UI.WebControls;
![]( "一、NHibernate <wbr alt=")
使用配置与实现简单查询" alt="一、NHibernate
使用配置与实现简单查询" src="http://hiphotos.baidu.com/grayworm/pic/item/3be3a1f8273c4211d8f9fd52.jpg" border=0 real_src="http://hiphotos.baidu.com/grayworm/pic/item/3be3a1f8273c4211d8f9fd52.jpg" SMALL="0">
namespace Common
{
public class Fruit : System.IComparable
{
//成员变量
protected string _id;
protected string _name;
protected decimal _price;
protected string _source;
protected string _stack;
protected int _numbers;
protected string _image;
protected static String _sortexpression_r = "Id";
protected static SortDirection _sortDirection = SortDirection.Ascending;
//构造函数
public Fruit() { }
public Fruit( string name, decimal price, string source, string stack, int numbers, string image )
{
this._name = name;
this._price = price;
this._source = source;
this._stack = stack;
this._numbers = numbers;
this._image = image;
}
//属性
public virtual string Id
{
get {return _id;}
set
{
if ( value != null && value.Length > 50)
throw new ArgumentOutOfRangeException("Invalid value for Id", value, value.ToString());
_id = value;
}
}
public virtual string Name
{
get { return _name; }
set
{
if ( value != null && value.Length > 50)
throw new ArgumentOutOfRangeException("Invalid value for Name", value, value.ToString());
_name = value;
}
}
public virtual decimal Price
{
get { return _price; }
set { _price = value; }
}
public virtual string Source
{
get { return _source; }
set
{
if ( value != null && value.Length > 50)
throw new ArgumentOutOfRangeException("Invalid value for Source", value, value.ToString());
_source = value;
}
}
public virtual string Stack
{
get { return _stack; }
set
{
if ( value != null && value.Length > 50)
throw new ArgumentOutOfRangeException("Invalid value for Stack", value, value.ToString());
_stack = value;
}
}
public virtual int Numbers
{
get { return _numbers; }
set { _numbers = value; }
}
public virtual string Image
{
get { return _image; }
set
{
if ( value != null && value.Length > 50)
throw new ArgumentOutOfRangeException("Invalid value for Image", value, value.ToString());
_image = value;
}
}
public static String Sortexpression_r
{
get { return _sortexpression_r; }
set { _sortexpression_r = value; }
}
public static SortDirection SortDirection
{
get { return _sortDirection; }
set { _sortDirection = value; }
}
//实现IComparable接口的排序方法
public virtual int CompareTo(object obj)
{
if (!(obj is Fruit))
throw new InvalidCastException("This object is not of type Fruit");
int relativue;
switch (Sortexpression_r)
{
case "Id":
relativue = this.Id.CompareTo(((Fruit)obj).Id);
break;
case "Name":
relativue = this.Name.CompareTo(((Fruit)obj).Name);
break;
case "Price":
relativue = (this.Price != null) ? this.Price.CompareTo(((Fruit)obj).Price) : -1;
break;
case "Source":
relativue = (this.Source != null) ? this.Source.CompareTo(((Fruit)obj).Source) : -1;
break;
case "Stack":
relativue = (this.Stack != null) ? this.Stack.CompareTo(((Fruit)obj).Stack) : -1;
break;
case "Numbers":
relativue = (this.Numbers != null) ? this.Numbers.CompareTo(((Fruit)obj).Numbers) : -1;
break;
case "Image":
relativue = (this.Image != null) ? this.Image.CompareTo(((Fruit)obj).Image) : -1;
break;
default:
goto case "Id";
}
if (Fruit.SortDirection == SortDirection.Ascending)
relativue *= -1;
return relativue;
}
