使用NHibernate 3.2实现Repository（ORuM）（五）MVCQuick.Framework.Repository

MVCQuick的Repository实现特点：
　　1、实体类与仓储类真正实现分离；
　　2、可以支持多种数据库；
　　3、通过.Net反射技术，每个实体对象自动产生映射文件；
　　4、单元测试实现简单。

MVCQuick.Framework.Repository的IRepository接口

void Save<TEntity>(TEntity entity) where TEntity : EntityBase;
void Update<TEntity>(TEntity entity) where TEntity : EntityBase;
void SaveOrUpdate<TEntity>(TEntity entity) where TEntity : EntityBase;
void Delete<TEntity>(TEntity entity) where TEntity : EntityBase;
TEntity Get<TKey, TEntity>(TKey id) where TEntity : EntityBase;
bool Exists<TEntity>();
long Count<TEntity>();
IList<TEntity> FindAll<TEntity>() where TEntity : EntityBase;
TEntity FindOne<TEntity>(string propertyName, object value) where TEntity : EntityBase;
TEntity FindOne<TEntity>(IDictionary<String, Object> properties) where TEntity : EntityBase;
TEntity FindOne<TEntity>(string propertyName1, object value1, string propertyName2, object value2) where TEntity : EntityBase;
IList<TEntity> Find<TEntity>(string propertyName, object value) where TEntity : EntityBase;
IList<TEntity> Find<TEntity>(string propertyName1, object value1, string propertyName2, object value2) where TEntity : EntityBase;
IList<TEntity> Find<TEntity>(IDictionary<String, Object> properties) where TEntity : EntityBase;
ITransaction BeginTransaction();

使用方法
1、添加引用"MVCQuick.Framework.dll"

2、创建实体类

public class Album : EntityBase
    {
        public virtual string Title { get; set; }
        public virtual decimal Price { get; set; }        
        public virtual string AlbumArtUrl { get; set; }
        public virtual Genre Genre { get; set; }
        public virtual Artist Artist { get; set; }
    }

    public class Genre : EntityBase
    {
        public virtual string Name { get; set; }
        public virtual string Description { get; set; }
        public virtual IEnumerable<Album> Albums { get; set; }

    }

    public class Artist : EntityBase
    {
        public virtual string Name { get; set; }
        public virtual Address Address { get; set; }
        public virtual IEnumerable<Album> Albums { get; set; }
    }

    public class User : EntityBase
    {
        public virtual string Username { get; set; }
        public virtual string Email { get; set; }
        public virtual string Password { get; set; }
        public virtual IEnumerable<Role> Roles { get; set; }
    }

    public class Role : EntityBase
    {
        public virtual string Name { get; set; }
        public virtual string Description { get; set; }
        public virtual IEnumerable<User> Users { get; set; }
    }

    public class Address : IValueObject
    {
        public virtual string City { get; set; }
        public virtual string Country { get; set; }
        public virtual string State { get; set; }
        public virtual string Street { get; set; }
        public virtual string Zip { get; set; }
    }

3、web.config配置数据库

<connectionStrings>   
    <clear />
    <!--
    providerName:DB2,DB2400,Firebird,MsSql2000,MsSql2005,MsSql2008,
                 MsSqlCe,MySQL,MySQL5,Oracle8i,Oracle9i,Oracle10g,
                 PostgreSQL,PostgreSQL81,PostgreSQL82,SQLite
    -->
    <add name="MVCQuickRepository" 
        connectionString="Data Source=|DataDirectory|test1.db;Version=3;New=True;"
        providerName="SQLite"/>

</connectionStrings>

4、初始化repository

NHibernateManager.Configuration();
NHibernateManager.AddMapping("MVCQuick",
    typeof(EntityBase).Assembly,
    typeof(Album).Assembly);         
NHibernateManager.UpdateSchema();

5、CRUD

IRepository repository = new NHibernateRepository();
User user1 = new User { Username = "admin", Email = "admin@163.com", Password = "admin123" };
repository.Save(user1);
User user2 = new User { Username = "guest", Email = "guest@163.com", Password = "guest123" };
repository.Save(user2);

User user3 = repository.Get<int, User>(1);

IList<User> users1 = repository.FindAll<User>();
IList<User> users2 = repository.Find<User>("Username", "admin");

User user4 = repository.FindOne<User>("Username", "admin");
User user5 = repository.FindOne<User>("Username", "admin", "Password", "admin123");

User user6 = repository.FindOne<User>("Username", "guest");
user6.Password = "guest1234";
repository.Update(user6);

User user7 = repository.FindOne<User>("Username", "guest", "Password", "guest1234");               
repository.Delete(user7);