摘要:多对多的关系在日常开发中也会经常遇到,在ActiveRecord中我们用HasAndBelongsToMany特性来实现Many-Many的关联,本文将通过一个具体的实例来介绍这一用法。
主要内容
1.准备数据库表
2.编写实体类
3.编写测试代码
一.准备数据库表
接着在上篇文章中的例子,为了实现多对多的关系,我们引入Community,即每个Blog可以属于多个社区,每个社区也可以有多个Blog。
CREATE
TABLE
Blogs (
![None.gif](/Images/OutliningIndicators/None.gif)
blog_id
int
IDENTITY
(
1
,
1
)
PRIMARY
KEY
,
![None.gif](/Images/OutliningIndicators/None.gif)
blog_name
varchar
(
50
),
![None.gif](/Images/OutliningIndicators/None.gif)
blog_author
varchar
(
50
)
![None.gif](/Images/OutliningIndicators/None.gif)
)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
CREATE
TABLE
Blog_Community (
![None.gif](/Images/OutliningIndicators/None.gif)
blog_Id
int
NOT
NULL
,
![None.gif](/Images/OutliningIndicators/None.gif)
community_Id
int
NOT
NULL
![None.gif](/Images/OutliningIndicators/None.gif)
)
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
CREATE
TABLE
Communities (
![None.gif](/Images/OutliningIndicators/None.gif)
community_Id
int
IDENTITY
(
1
,
1
)
PRIMARY
KEY
,
![None.gif](/Images/OutliningIndicators/None.gif)
community_Name
varchar
(
50
) ,
![None.gif](/Images/OutliningIndicators/None.gif)
community_Intro
varchar
(
500
)
![None.gif](/Images/OutliningIndicators/None.gif)
)
二.编写实体类代码
为了实现多对多的关系,我们要在Blog、Community类中分别使用HasAndBelongsToMany特性,不需要编写Blog_Community类。示例代码:
//
![dot.gif](/Images/dot.gif)
Blog
[HasAndBelongsToMany(
typeof
(Community),
![None.gif](/Images/OutliningIndicators/None.gif)
Table
=
"
Blog_Community
"
,
![None.gif](/Images/OutliningIndicators/None.gif)
ColumnRef
=
"
community_id
"
,
![None.gif](/Images/OutliningIndicators/None.gif)
ColumnKey
=
"
blog_id
"
)]
![None.gif](/Images/OutliningIndicators/None.gif)
public
IList Communitys
![None.gif](/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _community; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _ community = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![None.gif](/Images/OutliningIndicators/None.gif)
![None.gif](/Images/OutliningIndicators/None.gif)
//
![dot.gif](/Images/dot.gif)
Community
[HasAndBelongsToMany(
typeof
(Blog),
![None.gif](/Images/OutliningIndicators/None.gif)
Table
=
"
Blog_Community
"
,
![None.gif](/Images/OutliningIndicators/None.gif)
ColumnRef
=
"
blog_id
"
,
![None.gif](/Images/OutliningIndicators/None.gif)
ColumnKey
=
"
community_id
"
)]
![None.gif](/Images/OutliningIndicators/None.gif)
public
IList Blogs
![None.gif](/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _blog; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _ blog = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
HasAndBelongsToMany的参数相信大家都能够看明白,指定关联表名和关联的外键就可以了。
注意:这三个参数必须指定,不可以省略!
HasManyAttribute说明
属性 | 说明 | 示例 |
Cascade | 指明哪些操作会从父对象级联到关联的对象,相关的操作见后面,如果不指定,则为None | Cascade=ManyRelationCascadeEnum.All |
Inverse | 指定是否级联操作 | Inverse =true|false |
Schema | 指定Schema的名字 | Schema="ARDemo" |
Table | 指定持久化类所关联的数据库表名,如果表名与类名相同,可以省略 | Table="posts" |
ColumnKey | 本实体类于另一个实体类关联的外键 | ColumnKey="community_id" |
ColumnRef | 另一实体类的外键 | ColumnRef="blog_id" |
Where | 指定一个附加SQL的Where子句 | Where="IsPost = 0" |
Lazy | 指定是否延迟加载关联对象 | Lazy=true|false |
Cascade的类型值有如下几种
类型 | 说明 |
None | 不进行级联操作 |
SaveUpdate | 进行级联Save/Update操作 |
Delete | 进行级联Delete操作 |
All | 进行级联Save/Update/Delete操作 |
AllDeleteOrphan | 进行级联Save/Update/Delete操作,并删除无相关父对象的子对象 |
最后完整的实体类如下:
/**/
/// <summary>
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
/// Blog 的摘要说明。
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
/// </summary>
[ActiveRecord(
"
Blogs
"
)]
![None.gif](/Images/OutliningIndicators/None.gif)
public
class
Blog : ActiveRecordBase
![None.gif](/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
private int _id;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
private String _name;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
private String _author;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
private IList _community;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
[PrimaryKey(PrimaryKeyType.Identity, "blog_id")]
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public int Id
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _id; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _id = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
[Property("blog_name")]
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public String Name
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _name; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _name = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
[Property("blog_author")]
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public String Author
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _author; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _author = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
[HasAndBelongsToMany(typeof(Community),
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
Table="Blog_Community",
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
ColumnRef=" community_id ",
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
ColumnKey=" blog_id " )]
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public IList Communities
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _community; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _community = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public static void DeleteAll()
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
DeleteAll( typeof(Blog) );
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public static Blog[] FindAll()
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
return (Blog[]) FindAll( typeof(Blog) );
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public static Blog Find(int id)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
return (Blog) FindByPrimaryKey( typeof(Blog), id );
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
/**/
/// <summary>
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
/// Community 的摘要说明。
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
/// </summary>
[ActiveRecord(
"
Communities
"
)]
![None.gif](/Images/OutliningIndicators/None.gif)
public
class
Community : ActiveRecordBase
![None.gif](/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
private int _id;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
private String _name;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
private String _intro;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
private IList _blog;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
[PrimaryKey(PrimaryKeyType.Identity, "Community_Id")]
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public int Id
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _id; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _id = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
[Property("Community_Name")]
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public String Name
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _name; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _name = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
[Property("Community_Intro")]
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public String Author
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _intro; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _intro = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
[HasAndBelongsToMany(typeof(Blog),
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
Table="Blog_Community",
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
ColumnRef="blog_id",
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
ColumnKey="community_id" )]
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public IList Blogs
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return _blog; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ _blog = value; }
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public static void DeleteAll()
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
DeleteAll( typeof(Community) );
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public static Community[] FindAll()
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
return (Community[]) FindAll( typeof(Community) );
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
public static Community Find(int id)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
return (Community) FindByPrimaryKey( typeof(Community), id );
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
三.编写测试代码
下面是我写的一些简单的测试代码,有兴趣的可以看一下。
1.级联增加:新增一个Blog,让它同时属于好几个社区
[Test]
![None.gif](/Images/OutliningIndicators/None.gif)
public
void
TestCascadingSave()
![None.gif](/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
//新建一个Blog
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
Blog blog = new Blog();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
blog.Name = "Tech Space";
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
blog.Author = "Terrylee";
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
//属于ID为1,2社区
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
ArrayList list = new ArrayList();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
list.Add(Community.Find(1));
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
list.Add(Community.Find(2));
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
blog.Communities = list;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
//保存
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
blog.Save();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
2.级联更新:对一个已经存在Blog,更改它属于更多的社区
[Test]
![None.gif](/Images/OutliningIndicators/None.gif)
public
void
TestCascadingUpdate()
![None.gif](/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
//测试1:查找一个Blog
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
Blog blog = Blog.Find(10);
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
IList clist = blog.Communities;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
clist.Add(Community.Find(4));
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
clist.Add(Community.Find(3));
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
blog.Save();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
//测试2:查找一个Community
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
Community community = Community.Find(3);
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
IList blist = community.Blogs;
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
blist.Add(Blog.Find(8));
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
community.Save();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
3.级联删除:删除一个Blog,级联表中对应的记录应该删除,但Community不能删除,因为还有别的Blog和它关联
[Test]
![None.gif](/Images/OutliningIndicators/None.gif)
public
void
TestCascadingDelete()
![None.gif](/Images/OutliningIndicators/None.gif)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
//测试1:删除Blog
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
Blog blog = Blog.Find(10);
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
using(TransactionScope btran = new TransactionScope())
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
try
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
blog.Delete();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
btran.VoteCommit();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
catch
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
btran.VoteRollBack();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
//测试2:删除Community
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
Community community = Community.Find(3);
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
using(TransactionScope ctran = new TransactionScope())
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
try
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
community.Delete();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
ctran.VoteCommit();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
catch
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
ctran.VoteRollBack();
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
![InBlock.gif](/Images/OutliningIndicators/InBlock.gif)
}
好了,关于Many-Many关联映射就写这么多了,内容比较简单。下篇文章我会介绍在ActiveRecord中实现延迟加载和使用Where子句。
参考资料
Castle的官方网站http://www.castleproject.org