ASP.NET MVC中使用Nhibernate(二)

一,摘要

这是ASP.NET MVC中使用Nhibernate的第二部分,你也可以查看第一部分

一,多对多关联

我们将继续创建我们的Post类的映射文件,相对于Category将增加一点难度,应为我们不得不去呈现一个多对对的关系,为了达到这个目的,我们在映射文件中使用Bagyu元素,下面是Post.hbm.xml 文件的代码:

1: xml version="1.0" encoding="utf-8" ?> 2: <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" 3: namespace="Core.Domain.Model" 4: assembly="Core"> 5: 6: <class name="Post" table="Posts" dynamic-update="true"> 7: <cache usage="read-write"/> 8: <id name="Id" column="Id" type="Guid"> 9: <generator class="guid"/> 10: id> 11: <property name="Title" length="100"/> 12: <property name="Body"/> 13: <property name="CreationDate" type="datetime"/> 14: <property name="IsPublic" type="bool"/> 15: 16: <bag name="Categories" table="PostCategory" lazy="false" > 17: <key column="idPost" > key> 18: <many-to-many class="Category" column="idCategory" > many-to-many> 19: bag> 20: 21: class> 22: hibernate-mapping>

bag元素包含在16-19行代码中,下面解释下上面的代码: 1.name属性是Post类的属性名,我们用来存储categories集合 2.table属性是数据库中的一个表,用来连接Post和Categories表 3.key中的column属性是Post的主键列 4.class属性是category模型的类名 5.many-to-many中的column属性是Categories的主键列 为了更好的理解这个映射文件,下面提供类图表和数据库图标:   

 

从上面看到,我们不需创建PostCategory表的类

二,测试

下面提供完整的单元测试代码:

1: using System; 2: using System.Text; 3: using System.Collections.Generic; 4: using System.Linq; 5: using Microsoft.VisualStudio.TestTools.UnitTesting; 6: using Core.Domain.Model; 7: using Core.Domain.Repositories; 8: using Core; 9: amespace NHibernate101.Tests 10:  11: [TestClass] 12: public class RepositoriesTest 13: { 14: IRepository categoriesRepository; 15: IRepository postsRepository; 16: Post testPost; 17: Category testCategory1; 18: Category testCategory2; 19:  20: public RepositoriesTest() 21: { 22: } 23: private TestContext testContextInstance; 24: public TestContext TestContext 25: { 26: get 27: { 28: return testContextInstance; 29: } 30: set 31: { 32: testContextInstance = value; 33: } 34: } 35: [TestInitialize()] 36: public void CreateRepositories() 37: { 38: categoriesRepository = new CategoryRepository(); 39: postsRepository = new PostRepository(); 40: } 41: [TestMethod] 42: [DeploymentItem("hibernate.cfg.xml")] 43: public void CanCreateCategory() 44: { 45: testCategory1 = new Category() { Name = "ASP.NET" }; 46: categoriesRepository.Save(testCategory1); 47:  48: } 49: [TestMethod] 50: [DeploymentItem("hibernate.cfg.xml")] 51: public void CanCreatePost() 52: { 53: testPost = new Post(); 54: testPost.Title = "ASP.NET MVC and NHibernate"; 55: testPost.Body = "In this article I’m going to cover how to install and configure NHibernate and use it in a ASP.NET MVC application."; 56: testPost.CreationDate = DateTime.Now; 57: testPost.IsPublic = true; 58: testCategory2 = new Category() { Name= "ASP.NET MVC"}; 59: categoriesRepository.Save(testCategory2); 60: testPost.Categories.Add(testCategory2); 61: postsRepository.Save(testPost); 62: } 63: }

如果上面的测试通过,我们将在数据库中看到新的post和categoty 随下的文章中我们将继续探索!