Repository Factory介绍

      Repository Factory是的Micrsoft Patterns and practies Team在前几年出的一个代码生成组件，主要生成基于Enlib DAAB的DataAccessLayer和Business Entity. 主要适用于VS2005,VS2008。从官方下载RepositoryFactoryForVS2008.msi,安装后，在Tools菜单将有一个选项Guidance Package Manager，看下面的图片：

打开后，Check Repository Factory

在Solution Explorer中通过右键选择各自的Project的Responsibilites:

 

打开DataBase

选择你要生成Tables:

 

可以选择并EDIT需要映射的SP

最后生成的Enity class:

    [Serializable]
    public partial class Categories
    {
        public Categories()
        {
        }

        public Categories(System.Int32 categoryID, System.String categoryName, System.String description, System.Byte[] picture)
        {
            this.categoryIDField = categoryID;
            this.categoryNameField = categoryName;
            this.descriptionField = description;
            this.pictureField = picture;
        }

        private System.Int32 categoryIDField;

        public System.Int32 CategoryID
        {
            get { return this.categoryIDField; }
            set { this.categoryIDField = value; }
        }

        private System.String categoryNameField;

        public System.String CategoryName
        {
            get { return this.categoryNameField; }
            set { this.categoryNameField = value; }
        }

        private System.String descriptionField;

        public System.String Description
        {
            get { return this.descriptionField; }
            set { this.descriptionField = value; }
        }

        private System.Byte[] pictureField;

        public System.Byte[] Picture
        {
            get { return this.pictureField; }
            set { this.pictureField = value; }
        }

    }

Interface:

    /// <summary>
    /// Repository that lets you find Categories in the database.
    /// </summary>
    public interface ICategoriesRepository
    {

        List<Categories> GetAllFromCategories();

        void Add(Categories categories);

        void Remove(System.Int32 categoryIDField);

        void Save(Categories categories);

    }

具体的Repository factory class:

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using RepositoryFactoryTest;
using RepositoryFactoryTest.BusinessEntities;
using RepositoryFactoryTest.Interfaces;
using System.Data.SqlClient;
using System.Diagnostics;
using Microsoft.Practices.Repository;
using Microsoft.Practices.Repository.SQLServer;

namespace RepositoryFactoryTest.CategoriesRepositoryArtifacts
{
    /// <summary>
    /// Repository that lets you find Categories in the database.
    /// </summary>
    public sealed class CategoriesRepository : Repository<Categories>, ICategoriesRepository
    {
        public CategoriesRepository(string databaseName)
            : base(databaseName)
        {
        }

        public CategoriesRepository()
            : base()
        {
        }


        public List<Categories> GetAllFromCategories()
        {
            ISelectionFactory<NullableIdentity> selectionFactory = new GetAllFromCategoriesSelectionFactory();

            try
            {
                NullableIdentity nullableIdentity = new NullableIdentity();
                return base.Find(selectionFactory, new GetAllFromCategoriesFactory(), nullableIdentity);
            }
            catch (SqlException ex)
            {
                HandleSqlException(ex, selectionFactory);
            }

            return new List<Categories>();
        }

        public void Add(Categories categories)
        {
            CategoriesInsertFactory insertFactory = new CategoriesInsertFactory();
            try
            {
                base.Add(insertFactory, categories);
            }
            catch (SqlException ex)
            {
                HandleSqlException(ex, insertFactory);
            }
        }

        public void Remove(System.Int32 categoryID)
        {
            IDeleteFactory<System.Int32> deleteFactory = new CategoriesDeleteFactory();

            try
            {
                base.Remove(deleteFactory, categoryID);
            }
            catch (SqlException ex)
            {
                HandleSqlException(ex, deleteFactory);
            }
        }


        public void Save(Categories categories)
        {
            CategoriesUpdateFactory updateFactory = new CategoriesUpdateFactory();
            try
            {
                base.Save(updateFactory, categories);
            }
            catch (SqlException ex)
            {
                HandleSqlException(ex, updateFactory);
            }
        }
        private void HandleSqlException(SqlException ex, IDbToBusinessEntityNameMapper mapper)
        {
            if (ex.Number == ErrorCodes.SqlUserRaisedError)
            {
                switch (ex.State)
                {
                    case ErrorCodes.ValidationError:
                        string[] messageParts = ex.Errors[0].Message.Split(':');
                        throw new RepositoryValidationException(
                            mapper.MapDbParameterToBusinessEntityProperty(messageParts[0]),
                            messageParts[1], ex);

                    case ErrorCodes.ConcurrencyViolationError:
                        throw new ConcurrencyViolationException(ex.Message, ex);

                }
            }

            throw new RepositoryFailureException(ex);
        }


    }
}

来看下关键的Interface:

namespace Microsoft.Practices.Repository
{
    public class Repository<TDomainObject>
    {
        public Repository();
        public Repository(string databaseName);

        protected Database Database { get; set; }

        public void Add(IInsertFactory<TDomainObject> insertFactory, TDomainObject domainObj);
        public List<TDomainObject> Find<TIdentity>(ISelectionFactory<TIdentity> selectionFactory, IDomainObjectsFactory<TDomainObject> domainObjectFactory, TIdentity identity);
        public TDomainObject FindOne<TIdentity>(ISelectionFactory<TIdentity> selectionFactory, ISimpleDomainObjectFactory<TDomainObject> domainObjectFactory, TIdentity identity);
        public TDomainObject FindOneComplex<TIdentity>(ISelectionFactory<TIdentity> selectionFactory, IComplexDomainObjectFactory<TDomainObject> domainObjectFactory, TIdentity identity);
        public TDomainObject FindOneWithSqlCache<TIdentity>(ISelectionFactory<TIdentity> selectionFactory, IDomainObjectFactory<TDomainObject> domainObjectFactory, TIdentity identity, string cacheKey, TimeSpan expiry);
        public List<TDomainObject> FindWithSqlCache<TIdentity>(ISelectionFactory<TIdentity> selectionFactory, IDomainObjectFactory<TDomainObject> domainObjectFactory, TIdentity identity, string cacheKey, TimeSpan expiry);
        public void Remove<TIdentityObject>(IDeleteFactory<TIdentityObject> deleteFactory, TIdentityObject identityObj);
        public void Save(IUpdateFactory<TDomainObject> updateFactory, TDomainObject domainObj);
    }
}

这一套工具目前生成的Code是基于Data Access Application Block 3.1的。不过还好有SourceCode,你可以按照你的需要修改。

感觉有点像CodeSmith的，但其中n-tiers template生成的代码要比这个复杂。这个只需要VisualStudio，下一代的代码生成应该是基于T4 template了。

有时间我将介绍基于EF4的DAL的Repository的代码生成。

希望对您的开发有帮助。

作者：Petter Liu
出处：http://www.cnblogs.com/wintersun/
本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。
该文章也同时发布在我的独立博客中-Petter Liu Blog。