Castle ActiveRecord实现one–one关系的映射

一．编写实体类代码为了实现多对多的关系，我们要在Customer 、CustomerAddress

类中分别使用OneToOne特性。示例代码：

Customer 类：

1. [ActiveRecord("Customer")]
2.     public class Customer : ActiveRecordBase<Customer>
3.     {
4.         private Guid custID;
5.         private string name;
6.         private CustomerAddress addr;
8.         [PrimaryKey]
9.         public Guid CustomerID
10.         {
11.             get { return custID; }
12.             set { custID = value; }
13.         }
15.         [OneToOne(Cascade=CascadeEnum.All)]
16.         public CustomerAddress CustomerAddress
17.         {
18.             get { return addr; }
19.             set { addr = value; }
20.         }
22.         [Property]
23.         public string Name
24.         {
25.             get { return name; }
26.             set { name = value; }
27.         }
28.     }

复制代码

CustomerAddress 类:

1. [ActiveRecord("CustomerAddress")]
2.     public class CustomerAddress : ActiveRecordBase<CustomerAddress>
3.     {
4.         private Guid custID;
5.         private string address;
6.         private Customer cust;
8.         [PrimaryKey(PrimaryKeyType.Foreign)]
9.         public Guid CustomerID
10.         {
11.             get { return custID; }
12.             set { custID = value; }
13.         }
15.         [OneToOne]
16.         public Customer Customer
17.         {
18.             get { return cust; }
19.             set { cust = value; }
20.         }
22.         [Property]
23.         public string Address
24.         {
25.             get { return address; }
26.             set { address = value; }
27.         }
28.     }

复制代码

二．初始化数据库
根据实体类来逆向的创建数据库的表(数据库要是已存在的)

1. IConfigurationSource source = System.Configuration.ConfigurationManager.GetSection("activerecord") as IConfigurationSource;
2.             ActiveRecordStarter.Initialize(source, typeof(Customer), typeof(CustomerAddress));
3.             ActiveRecordStarter.CreateSchema();//初始化数据库

复制代码

三．编写测试代码
1．级联增加

1. /// <summary>
2.         /// 添加数据
3.         /// </summary>
4.         private static void AddSouces()
5.         {
6.             //使用事务处理
7.             using (TransactionScope tran = new TransactionScope())
8.             {
9.                 try
10.                 {
11.                     Customer cust = new Customer();
12.                     cust.CustomerID = new Guid();
13.                     cust.Name = "张三";
15.                     CustomerAddress custAddress = new CustomerAddress();
16.                     custAddress.Address = "address";
18.                     //支出对应关系
19.                     cust.CustomerAddress = custAddress;
20.                     custAddress.Customer = cust;
21.                     custAddress.Save(); //保存Customer对象
23.                     tran.VoteCommit();  //执行事务
24.                 }
25.                 catch (Exception)
26.                 {
27.                     tran.VoteRollBack();    //若出现异常，回滚事务
28.                     
29.                 }
30.             }
31.         }

复制代码

2级联删除：因为我们有设置Cascade=CascadeEnum.All，删除一个Customer，对应的CustomerAddress 记录也会删除

1. SimpleQuery<Customer> query = new SimpleQuery<Customer>(typeof(Customer), "From Customer as n where n.Name = ?", "李四");
2.             Customer cust = query.Execute().FirstOrDefault();
3.             cust.Delete();//级联删除，CustomerAddress表的相应数据也会删除

复制代码