关于我的 DAL 层的建议，有什么明显的问题吗？

发布于 2024-08-13 22:30:36 字数 804 浏览 2 评论 0原文

我正在使用 nHibernate。我的类是 POCO，它与我的数据库表 1:1 映射。我创建了一个 IGenericDAO -> GenericDAO 可以完成我所有的基本 CRUD。（存储库）每个表都有一个 DAO 类，因此：

public class UserDAO : GenericDAO

任何特定于表的查询都将进入 tableDAO 类。

然后我就有了一个工厂，IDAOFactory。

public class NHibernateDAOFactory : IDAOFactory
{
   public static UserDAO GetUserDAO()
   {
        return new UserDAO();
   }
}

可能的改进： 1. 为了让我的 Web 应用程序不乱七八糟：

IDAOFactory dbFactory = new NHibernateDAOFactory();

我正在考虑创建：

public class DAOFactoryFactory
{
      public static IDAOFactory Load()
      {
         return new NHibernateDAOFactory();
      }
}

这样我就可以有一个单点更改，以防我需要交换数据库层。（即在 linq2sql 和 nhibernate 之间切换，但不确定这实际上是否可能）

有关如何改进这一点的任何建议/指针，或者这是否非常可靠？

原文

I am using nHibernate.
My classes are POCO, that map 1:1 with my database tables.
I created a IGenericDAO -> GenericDAO that does all my basic CRUD. (repository)
Each table has a DAO class, so:

public class UserDAO : GenericDAO

Any table specific queries will go in the tableDAO class.

I then have a factory, IDAOFactory.

public class NHibernateDAOFactory : IDAOFactory
{
   public static UserDAO GetUserDAO()
   {
        return new UserDAO();
   }
}

Possible improvement:
1. Just so my web application isn't littered with:

IDAOFactory dbFactory = new NHibernateDAOFactory();

I was thinking of creating:

public class DAOFactoryFactory
{
      public static IDAOFactory Load()
      {
         return new NHibernateDAOFactory();
      }
}

This way I have a single point of change in case I need to swap database layers. (i.e. switch between linq2sql and nhibernate, but not sure that is possible in reality)

Any suggestions/pointers on how to improve this, or is this pretty much solid?

分享到QQ

分享到微博