Billy McCafferty

Generic DAO with NHibernate

4/28/06 Update:  The NHibernate codeproject.com article wins ASP.NET article of the month.  Woohoo!
3/14/06 Update:  See how this is used in a sample application at http://www.codeproject.com/useritems/NHibernateBestPractices.asp.
 
 
Hibernate.org has a great article on creating a generic DAO for Hibernate in Java.  Below is what I use for the C# port.
 
The interface for common CRUD functionality...
 
public interface GenericDAO {
  T GetById(IdDataType id, bool shouldLock);
  List GetAll();
  List GetByExample(T exampleInstance, string[] propertiesToExclude);
  T SaveOrUpdate(T entity);
  void Delete(T entity);
}
 
The generic DAO implementation...
 
public abstract class GenericNHibernateDAO : GenericDAO
{
  /// Could be set using contruction injection IoC
  public GenericNHibernateDAO(ISessionManager sessionManager) {
    this.sessionManager = sessionManager;
  }
 
  public T GetById(IdDataType id, bool shouldLock) {
    ISession session = GetSession();
    T entity;
 
    if (shouldLock) {
      entity = (T) session.Load(persitentType, id, LockMode.Upgrade);
    }
    else {
      entity = (T) session.Load(persitentType, id);
    }
 
    return entity;
  }
 
  public List GetAll() {
    return GetByCriteria();
  }
 
  protected List GetByCriteria(params ICriterion[] criterion) {
    ISession session = GetSession();
    ICriteria criteria = session.CreateCriteria(persitentType);
    
    foreach (ICriterion criterium in criterion) {
      criteria.Add(criterium);
    }
    
    GenericUtils genericUtils = new GenericUtils();
    return genericUtils.ConvertToGenericList(criteria.List());
  }
 
  public List GetByExample(T exampleInstance, string[] propertiesToExclude) {
    ISession session = GetSession();
    ICriteria criteria = session.CreateCriteria(persitentType);
    Example example = Example.Create(exampleInstance);
 
    foreach (string propertyToExclude in propertiesToExclude) {
      example.ExcludeProperty(propertyToExclude);
    }
 
    criteria.Add(example);
 
    GenericUtils genericUtils = new GenericUtils();
    return genericUtils.ConvertToGenericList(criteria.List());
  }
 
  public T SaveOrUpdate(T entity) {
    ISession session = GetSession();
    session.SaveOrUpdate(entity);
 
    return entity;
  }
 
  public void Delete(T entity) {
    ISession session = GetSession();
    session.Delete(entity);
  }
 
  private ISession GetSession() {
    Check.Require(sessionManager != null, "sessionManager was not set");
    return sessionManager.OpenSession();
  }
 
  private Type persitentType = typeof(T);
  private ISessionManager sessionManager;
}
 
And for using this within your code...
 
public class ProjectDAONHibernate : GenericNHibernateDAO<Project, int> {
  public ProjectDAONHibernate(ISessionManager sessionManager) : base(sessionManager) {}
}
 

Notes:

Print posted @ Wednesday, February 15, 2006 7:32 AM