NHibernate blog : linq

Dynamic LINQ to NHibernate

felicepollano — Thu, 17 Nov 2011 13:18:00 GMT

Even if Linq To NHibernate provider allow us to write query in a strongly type manner, it is sometimes needed to works with property names literally. For example in a RIA application a service can receive a column as a string containing the name of the property to order by. Since Linq to NHibernate is a standard Linq provider, we can leverage a standard dynamic linq parser. This is achieved by using an old code by MS, known as System.Linq.Dynamic. By following the link you will find a download location that point to an almost just a sample project that eventually contains the file Dynamic.cs that contains some extension method allowing to merge literal parts in a type safe linq query.

Let’see an example:

var elist = session.Query<MyEntity>()
              .OrderBy(“Name descending”)
              .Skip(first)
              .Take(count)
              .ToList();

I supposed we have a property called Name on the class MyEntity. The OrderBy taking a string as a parameter is an extension method provided by Dynamic.cs, and in order to have it working you just need to merge the file dynamic.cs in your project and import System.Linq.Dynamic. Of course you will have extension for Where and for other linq operators too.

( cross post from my blog )

NHibernate Bootstrapper: Unit Tests and Project References

John Davidson — Sun, 05 Dec 2010 15:59:00 GMT

This post is the second one about the NHibernate Bootstrapper. The first is located here. The first post set up the project structure, introduced the generic DAO, and demonstrated the SessionPerRequest implementation in an IHttpModule. This post will factor the reference to NHibernate out of the web application project and cover some unit testing techniques. Programmers that are not familiar with SOLID should review the Wikipedia page and the references there. The first post noted that the version of NHibernate Bootstrapper presented there was not suitable for use in anything other than a demonstration program. The version of the solution discussed in this post is suitable for use in a small-scale system where there no more than 15 classes involved. The version following this post should be suitable for even the largest deployments, though there will be at least one additional post that refines the capabilities of an enterprise ready solution. The project sources are in a zip file located here and are updated to use the NHibernate 3.0.0 GA release.

PresentationManager

The solution in the first post used NHibernate references in the web application project. In this version of the solution those references have been moved to the presenter project. Now the solution is taken on the characteristics of the Model-View-Presenter (MVP) , discussed by Martin Fowler here, and later refined into a Supervising Presenter and Passive View. The solution employed here follows the Passive View pattern, where the view has no direct interaction with the model. The solution builds on 2 Code Project articles, originally released in Jul 2006. The first reference used is Model View Presenter with ASP.Net by Bill McCafferty and the second is Advancing the Model-View-Presenter Pattern – Fixing the Common Problems by Acoustic. There are a number of reasons for using the MVP pattern, but the most important of them is the enabling of testing. The second half of this post will show how it becomes possible to test the code behind of an aspx page.

In the first post the BusinessServices project, that would hold the presenters, was empty. Now there is a Presentation Manager and a Presenter classes. The PresentationManager is able to register the view of the ASP.Net page and associate it with the correct presenter. It is also remarkable in that it automatically instantiates the correct presenter for use by the ASP.Net page. This is done in the LoadPresenter method. The auto-instantiation is how ASP.Net pages are able to function with only a reference to the PresenterTypeAttribute in the web application project.

PresentationManager.cs
 using System;
using Infrastructure;
 
namespace BusinessServices
{
    public static class PresentationManager
    {
        public static T RegisterView<T>(Type presenterType, IView myView) where T : Presenter
        {
            return RegisterView<T>(presenterType, myView, null);
        }
 
        public static T RegisterView<T>(Type presenterType, IView view, IHttpSessionProvider httpSession) where T : Presenter
        {
            return (LoadPresenter(presenterType, view, httpSession)) as T;
        }
 
        public static void RegisterView(Type presenterType, IView view)
        {
            RegisterView(presenterType, view, null);
        }
 
        public static void RegisterView(Type presenterType, IView view, IHttpSessionProvider httpSession)
        {
            LoadPresenter(presenterType, view, httpSession);
        }
 
        private static Object LoadPresenter(Type presenterType, IView view, IHttpSessionProvider httpSession)
        {
            int arraySize = ((httpSession == null) ? 1 : 2);
            Object[] constructorParams = new Object[arraySize];
 
            constructorParams[0] = view;
 
            if (arraySize.Equals(2))
            {
                constructorParams[1] = httpSession;
            }
            return Activator.CreateInstance(presenterType, constructorParams);
        }
 
    }
}
 

The PresenterTypeAttribute is what each page uses to drive SelfRegister. This is the mechanism that ties the individual web pages to the appropriate presenter in an automated fashion. This is one aspect of a poor man’s Inversion of Control without requiring a separate container to hold the various dependencies.

PresenterTypeAttribute.cs
 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
 
namespace BusinessServices
{
    //[AttributeUsage(AttributeTargets.All, Inherited = true)]
    public class PresenterTypeAttribute : Attribute
    {
        private Type _presenterType;
 
        public PresenterTypeAttribute(Type presenterType)
        {
            _presenterType = presenterType;
        }
 
        public Type PresenterType
        {
            get { return _presenterType; }
            set { _presenterType = value; }
        }
    }
}
 

Revised Web Application Project

The code behind for the web page has been revised to work with a presenter. You will note that a large amount of code that was in the original code behind file has now been commented out, as it has been revised slightly and moved to the the PersonPresenter class. The code behind file is now left with just event declarations, a number of properties and the occasional method for working with gridview or dropdown controls and the Page_Load event. All that remains in the code behind are methods and properties that are referencing System.Web, while the various presenter classes have no reference to System.Web. It is important to note that the removal of the reference to System.Web in the presenter classes is what enables a high degree of code coverage in the Unit Tests.

Default.aspx.cs (Part 1)
 using System;
using System.Collections.Generic;
using System.Web.UI;
using System.Web.UI.WebControls;
using BusinessServices;
using BusinessServices.Interfaces;
using BusinessServices.Presenters;
using DataServices.Person;
 
namespace WebNHibernate
{
    [PresenterType(typeof(PersonPresenter))]
    public partial class _Default : BasePage, IPersonView
    {
 
        public event GridViewBtnEvent OnEditCommand;
        public event GridViewBtnEvent OnDeleteCommand;
        public event EmptyBtnEvent OnRefreshPersonGrid;
        public event EmptyBtnEvent OnSaveEditPerson;
        public event EmptyBtnEvent OnClearEditPerson;
        //added event for presenter
        public event EmptyEvent OnPageLoadNoPostback;
 
        //private ISession m_session = null;
 
        protected void Page_Load(object sender, EventArgs e)
        {
            //added for the presenter
            base.SelfRegister(this);
 
            //OnEditCommand += new GridViewBtnEvent(_view_OnEditCommand);
            //OnDeleteCommand += new GridViewBtnEvent(_view_OnDeleteCommand);
            //OnRefreshPersonGrid += new EmptyBtnEvent(_view_OnRefreshPersonGrid);
            //OnSaveEditPerson += new EmptyBtnEvent(_view_OnSaveEditPerson);
            //OnClearEditPerson += new EmptyBtnEvent(_view_OnClearEditPerson);
 
            //if (m_session == null)
            //    m_session = SessionManager.SessionFactory.GetCurrentSession();
 
            if (!Page.IsPostBack)
            {
                //added line below for presenter
                OnPageLoadNoPostback();
                //IList<PersonDto> gvData = Get_PersonData();
                //Fill_gvPerson(gvData);
            }
           
        }
 

Default.aspx.cs (Part 2)
 protected void gvPerson_OnRowCommand(object sender, GridViewCommandEventArgs e)
{
    Guid id = new Guid(gvPerson.DataKeys[Convert.ToInt32(e.CommandArgument)].Value.ToString());
    if (e.CommandName == "EditRow")
        OnEditCommand(id);
    else if (e.CommandName == "DeleteRow")
        OnDeleteCommand(id);
}
 
//public void _view_OnEditCommand(Guid id)
//{
//    if (m_session == null)
//        m_session = SessionManager.SessionFactory.GetCurrentSession();
 
//    PersonDAOImpl dao = new PersonDAOImpl(m_session);
//    Person pers = dao.GetByID(id);
 
//    txtPersonIdValue = pers.Id.ToString();
//    txtFirstNameValue = pers.FirstName;
//    txtLastNameValue = pers.LastName;
//    txtEmailValue = pers.Email;
//    txtUserIdValue = pers.UserID;
 
//    pers = null;
//    dao = null;
//}
 
//public void _view_OnDeleteCommand(Guid id)
//{
//    if (m_session == null)
//        m_session = SessionManager.SessionFactory.GetCurrentSession();
 
//    PersonDAOImpl dao = new PersonDAOImpl(m_session);
//    using (var tx = m_session.BeginTransaction())
//    {
//        dao.Delete(id);
//        tx.Commit();
//    }
 
//    dao = null;
//    _view_OnRefreshPersonGrid();
//}
 

Default.aspx.cs (Part 3)
 //public void _view_OnRefreshPersonGrid()
//{
//    IList<PersonDto> gvData = Get_PersonData();
//    Fill_gvPerson(gvData);
//}
 
//public void _view_OnSaveEditPerson()
//{
 
//    if (m_session == null)
//        m_session = SessionManager.SessionFactory.GetCurrentSession();
 
//    Guid editId = new Guid();
//    Person editPers = new Person();
 
//    if (!string.IsNullOrEmpty(txtPersonIdValue))
//        editId = new Guid(txtPersonIdValue);
 
//    PersonDAOImpl dao = new PersonDAOImpl(m_session);
//    using (var tx = m_session.BeginTransaction())
//    {
//        if (editId.ToString().Length == 36)
//            editPers = dao.GetByID(editId);
//        editPers.FirstName = txtFirstNameValue;
//        editPers.LastName = txtLastNameValue;
//        editPers.Email = txtEmailValue;
//        editPers.UserID = txtUserIdValue;
 
//        editPers = dao.Save(editPers);
//        tx.Commit();
//    }
 
//    editPers = null;
//    dao = null;
//    _view_OnRefreshPersonGrid();
//    _view_OnClearEditPerson();
//}
 
//public void _view_OnClearEditPerson()
//{
//    txtPersonIdValue = null;
//    txtFirstNameValue = null;
//    txtLastNameValue = null;
//    txtEmailValue = null;
//    txtUserIdValue = null;
//}
 

Default.aspx.cs (Part 4)
 protected void btnRefresh_Click(object sender, EventArgs e)
{
    OnRefreshPersonGrid();
}
 
protected void btnSave_Click(object sender, EventArgs e)
{
    OnSaveEditPerson();
}
 
protected void btnClear_Click(object sender, EventArgs e)
{
    OnClearEditPerson();
}
 
public void Fill_gvPerson(IList<PersonDto> data)
{
    gvPerson.DataSource = data;
    gvPerson.DataBind();
}
 
//public IList<PersonDto> Get_PersonData()
//{
//    IList<PersonDto> retVal = null;
 
//    if (m_session == null)
//        m_session = SessionManager.SessionFactory.GetCurrentSession();
 
//    ICriteria crit = m_session.CreateCriteria(typeof(Person));
//    PersonDAOImpl dao = new PersonDAOImpl(m_session);
 
//    IList<Person> people = dao.GetByCriteria(crit);
//    retVal = (from person in people
//              select new PersonDto
//                  {
//                      PersonID = person.Id,
//                      FirstName = person.FirstName,
//                      LastName = person.LastName,
//                      Email = person.Email,
//                      UserID = person.UserID
//                  }).ToList<PersonDto>();
//    crit = null;
//    dao = null;
//    people = null;
 
//    return retVal;
//}
 

Default.aspx.cs (Part 5)
         public string txtPersonIdValue
        {
            get { return txtPersonID.Text; }
            set { txtPersonID.Text = value; }
        }
 
        public string txtFirstNameValue
        {
            get { return txtFirstName.Text; }
            set { txtFirstName.Text = value; }
        }
 
        public string txtLastNameValue
        {
            get { return txtLastName.Text; }
            set { txtLastName.Text = value; }
        }
 
        public string txtEmailValue
        {
            get { return txtEmail.Text; }
            set { txtEmail.Text = value; }
        }
 
        public string txtUserIdValue
        {
            get { return txtUserID.Text; }
            set { txtUserID.Text = value; }
        }
 
    }
}
 

BasePage

The web project has had a BasePage class added to reuse element and methods common to more than just a single web page. This includes the SelfRegister method and various properties for RequestString, RequestUrl and IsPostBack. These are sample functions which have common utility throughout all the web pages. It is here that additional utility methods and functions with similar commonality would be added.

BasePage.cs
 using System;
using System.Collections.Specialized;
using BusinessServices;
 
namespace WebNHibernate
{
    public class BasePage : System.Web.UI.Page, IView
    {
 
        private string _requestUrl;
 
        protected T RegisterView<T>() where T : Presenter
        {
            return PresentationManager.RegisterView<T>(typeof(T), this, new HttpSessionProvider());
        }
 
        protected void SelfRegister(System.Web.UI.Page page)
        {
            if (page != null && page is IView)
            {
                object[] attributes = page.GetType().GetCustomAttributes(typeof(PresenterTypeAttribute), true);
 
                if (attributes != null && attributes.Length > 0)
                {
                    foreach (Attribute viewAttribute in attributes)
                    {
                        if (viewAttribute is PresenterTypeAttribute)
                        {
                            PresentationManager.RegisterView((viewAttribute as PresenterTypeAttribute).PresenterType,
                                page as IView, new HttpSessionProvider());
                            break;
                        }
                    }
                }
            }
        }
 
        public NameValueCollection RequestString
        {
            get { return Request.QueryString; }
        }
 
        public string RequestUrl
        {
            get { return Request.RawUrl;  }
            set { _requestUrl = value; }
        }
 
        public bool IsPostback
        {
            get { return this.IsPostBack; }
        }
    }
}
 

PersonPresenter

The PersonPresenter class now inherits the code that was commented out in the code behind file. It must also setup event listeners for events that will be raised from the web page. It is these event listeners that improve the testability of the solution, as now this functionality can be unit tested separate from any System.Web dependency. At this point the various presenters have a reference to NHibernate and work directly with the data access layer. The next iteration of the bootstrapper will refactor the presenter and place a data services layer between the presenter and the data access layer. The presenter will then no longer reference NHibernate.

PersonPresenter.cs (Part 1)
 using System;
using System.Collections.Generic;
using System.Linq;
using NHibernate;
using NHibernateDAO;
using NHibernateDAO.DAOImplementations;
using DataServices.Person;
using DomainModel.Person;
using Infrastructure;
using BusinessServices.Interfaces;
 
namespace BusinessServices.Presenters
{
    public class PersonPresenter : Presenter
    {
        private ISession m_session = null;
 
 
        public PersonPresenter(IPersonView view)
            : this(view, null)
        { }
 
        public PersonPresenter(IPersonView view, IHttpSessionProvider httpSession)
            : base(view, httpSession)
        {
            IPersonView _personView = null;
            _personView = base.GetView<IPersonView>();
            _personView.OnEditCommand += new GridViewBtnEvent(_view_OnEditCommand);
            _personView.OnDeleteCommand += new GridViewBtnEvent(_view_OnDeleteCommand);
            _personView.OnRefreshPersonGrid += new EmptyBtnEvent(_view_OnRefreshPersonGrid);
            _personView.OnSaveEditPerson += new EmptyBtnEvent(_view_OnSaveEditPerson);
            _personView.OnClearEditPerson += new EmptyBtnEvent(_view_OnClearEditPerson);
            _personView.OnPageLoadNoPostback += new EmptyEvent(_personView_OnPageLoadNoPostback);
        }
 
 
        public void _personView_OnPageLoadNoPostback()
        {
            IPersonView _personView = base.GetView<IPersonView>();
            IList<PersonDto> gvData = Get_PersonData();
            _personView.Fill_gvPerson(gvData);
        }
 

PersonPresenter.cs (Part 2)
 public void _view_OnEditCommand(Guid id)
{
    IPersonView _personView = base.GetView<IPersonView>();
    m_session = SessionManager.SessionFactory.GetCurrentSession();
 
    PersonDAOImpl dao = new PersonDAOImpl(m_session);
    DomainModel.Person.Person pers = dao.GetByID(id);
 
    _personView.txtPersonIdValue = pers.Id.ToString();
    _personView.txtFirstNameValue = pers.FirstName;
    _personView.txtLastNameValue = pers.LastName;
    _personView.txtEmailValue = pers.Email;
    _personView.txtUserIdValue = pers.UserID;
 
    pers = null;
    dao = null;
}
 
public void _view_OnDeleteCommand(Guid id)
{
    IPersonView _personView = base.GetView<IPersonView>();
    m_session = SessionManager.SessionFactory.GetCurrentSession();
 
    PersonDAOImpl dao = new PersonDAOImpl(m_session);
    using (var tx = m_session.BeginTransaction())
    {
        dao.Delete(id);
        tx.Commit();
    }
 
    dao = null;
    _view_OnRefreshPersonGrid();
}
 
public void _view_OnRefreshPersonGrid()
{
    IPersonView _personView = base.GetView<IPersonView>();
    IList<PersonDto> gvData = Get_PersonData();
    _personView.Fill_gvPerson(gvData);
}
 

PersonPresenter.cs (Part 3)
 public void _view_OnSaveEditPerson()
{
    IPersonView _personView = base.GetView<IPersonView>();
    m_session = SessionManager.SessionFactory.GetCurrentSession();
 
    Guid editId = new Guid();
    Person editPers = new Person();
 
    if (!string.IsNullOrEmpty(_personView.txtPersonIdValue))
        editId = new Guid(_personView.txtPersonIdValue);
 
    PersonDAOImpl dao = new PersonDAOImpl(m_session);
    using (var tx = m_session.BeginTransaction())
    {
            if ((editId != null) && (!editId.Equals(System.Guid.Empty))) //was a bug here
                editPers = dao.GetByID(editId);
            editPers.FirstName = _personView.txtFirstNameValue;
            editPers.LastName = _personView.txtLastNameValue;
            editPers.Email = _personView.txtEmailValue;
            editPers.UserID = _personView.txtUserIdValue;
 
            editPers = dao.Save(editPers);
            tx.Commit();
    }
 
    editPers = null;
    dao = null;
    _view_OnRefreshPersonGrid();
    _view_OnClearEditPerson();
}
 
public void _view_OnClearEditPerson()
{
    IPersonView _personView = base.GetView<IPersonView>();
 
    _personView.txtPersonIdValue = null;
    _personView.txtFirstNameValue = null;
    _personView.txtLastNameValue = null;
    _personView.txtEmailValue = null;
    _personView.txtUserIdValue = null;
}
 

PersonPresenter.cs (Part 4)
         public IList<PersonDto> Get_PersonData()
        {
            IPersonView _personView = base.GetView<IPersonView>();
            IList<PersonDto> retVal = null;
 
            m_session = SessionManager.SessionFactory.GetCurrentSession();
 
            ICriteria crit = m_session.CreateCriteria(typeof(Person));
            PersonDAOImpl dao = new PersonDAOImpl(m_session);
 
            IList<Person> people = dao.GetByCriteria(crit);
            retVal = (from person in people
                      select new PersonDto
                      {
                          PersonID = person.Id,
                          FirstName = person.FirstName,
                          LastName = person.LastName,
                          Email = person.Email,
                          UserID = person.UserID
                      }).ToList<PersonDto>();
            crit = null;
            dao = null;
            people = null;
 
            return retVal;
        }
 
        public IPersonView personView
        {
            get { return base.GetView<IPersonView>(); }
        }
 
    }
}
 

The interface for the PersonView web page has also had to be revised. Here the methods that are commented out have had the implementations moved from the web page to the presenter. One new event has been added for the presenter.

IPersonView.cs
 using System.Collections.Generic;
using DataServices.Person;
 
namespace BusinessServices.Interfaces
{
 
    public interface IPersonView : IView
    {
 
        event GridViewBtnEvent OnEditCommand;
        event GridViewBtnEvent OnDeleteCommand;
        event EmptyBtnEvent OnRefreshPersonGrid;
        event EmptyBtnEvent OnSaveEditPerson;
        event EmptyBtnEvent OnClearEditPerson;
        //the event below had to be added for the presenter
        event EmptyEvent OnPageLoadNoPostback;
 
        //void _view_OnEditCommand(Guid id);
        //void _view_OnDeleteCommand(Guid id);
        //void _view_OnRefreshPersonGrid();
        //void _view_OnSaveEditPerson();
        //void _view_OnClearEditPerson();
 
        string txtPersonIdValue { get; set; }
        string txtFirstNameValue { get; set; }
        string txtLastNameValue { get; set; }
        string txtEmailValue { get; set; }
        string txtUserIdValue { get; set; }
 
        void Fill_gvPerson(IList<PersonDto> data);
        //IList<PersonDto> Get_PersonData();
 
 
    }
}
 

Data Access Objects Improvements

The data access objects have been expanded to include support for NHibernate LINQ, which is now part of the core. Also support for selection of an unique object has been included, rather than always returning an IList. This means that there has been an update to the IRead.cs file as shown below.

IRead.cs
 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DomainModel;
using NHibernate;
 
namespace NHibernateDAO
{
    public interface IRead<TEntity> where TEntity : Entity
    {
        TEntity GetByID(Guid ID);
        IList<TEntity> GetByCriteria(ICriteria criteria);
        TEntity GetUniqByCriteria(ICriteria criteria);
        IList<TEntity> GetByQueryable(IQueryable<TEntity> queryable);
        TEntity GetUniqByQueryable(IQueryable<TEntity> queryable);
    }
}
 

The implementation file for the data access objects has been revised to include the implementation details for LINQ and unique object support.

GenericDAOImpl.cs (Pt 1)
 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DomainModel;
using NHibernate;
 
namespace NHibernateDAO
{
    public class GenericDAOImpl<TEntity> : IRead<TEntity>, ISave<TEntity> where TEntity : Entity
    {
        public GenericDAOImpl(ISession Session)
        {
            m_Session = Session;
        }
 
        protected readonly ISession m_Session;
 
        public TEntity GetByID(Guid ID)
        {
            if (!m_Session.Transaction.IsActive)
            {
                TEntity retval;
                using (var tx = m_Session.BeginTransaction())
                {
                    retval = m_Session.Get<TEntity>(ID);
                    tx.Commit();
                    return retval;
                }
            }
            else
            {
                return m_Session.Get<TEntity>(ID);
            }
        }
 

GenericDAOImpl.cs (Pt 2)
 public IList<TEntity> GetByCriteria(ICriteria criteria)
{
    if (!m_Session.Transaction.IsActive)
    {
        IList<TEntity> retval;
        using (var tx = m_Session.BeginTransaction())
        {
            retval = criteria.List<TEntity>();
            tx.Commit();
            return retval;
        }
    }
    else
    {
        return criteria.List<TEntity>();
    }
}
 
public TEntity GetUniqByCriteria(ICriteria criteria)
{
    if (!m_Session.Transaction.IsActive)
    {
        TEntity retval;
        using (var tx = m_Session.BeginTransaction())
        {
            retval = criteria.UniqueResult<TEntity>();
            tx.Commit();
            return retval;
        }
    }
    else
    {
        return criteria.UniqueResult<TEntity>();
    }
}
 

GenericDAOImpl.cs (Pt 3)
 public IList<TEntity> GetByQueryable(IQueryable<TEntity> queryable)
{
    if (!m_Session.Transaction.IsActive)
    {
        IList<TEntity> retval;
        using (var tx = m_Session.BeginTransaction())
        {
            retval = queryable.ToList<TEntity>();
            tx.Commit();
            return retval;
        }
    }
    else
    {
        return queryable.ToList<TEntity>();
    }
}
 
public TEntity GetUniqByQueryable(IQueryable<TEntity> queryable)
{
    if (!m_Session.Transaction.IsActive)
    {
        TEntity retval;
        using (var tx = m_Session.BeginTransaction())
        {
            retval = queryable.Single<TEntity>();
            tx.Commit();
            return retval;
        }
    }
    else
    {
        return queryable.Single<TEntity>();
    }
}
 

GenericDAOImpl.cs (Pt 4)
         public TEntity Save(TEntity entity)
        {
            if (!m_Session.Transaction.IsActive)
            {
                using (var tx = m_Session.BeginTransaction())
                {
                    m_Session.SaveOrUpdate(entity);
                    tx.Commit();
                }
            }
            else
            {
                m_Session.SaveOrUpdate(entity);
            }
            return entity;
        }
 
    }
}
 

Unit Test

The unit testing capabilities of the solution have been expanded. It starts with a fake PersonView class in the unit test project that includes functionality similar to that in the web page, but implemented without any reference to System.Web

PersonView.cs (Part 1)
 using System;
using System.Collections.Generic;
using BusinessServices;
using BusinessServices.Interfaces;
using BusinessServices.Presenters;
using DataServices.Person;
 
namespace BootstrapperUnitTests.Views
{
    [PresenterType(typeof(PersonPresenter))]
    public class PersonView : BaseView, IPersonView
    {
        private bool blnRegistered = false;
 
        private string _txtPersonID;
        private string _txtFirstName;
        private string _txtLastName;
        private string _txtEmail;
        private string _txtUserID;
        private static bool postBack;
 
        private IList<PersonDto> _gvPerson;
 
        public event GridViewBtnEvent OnEditCommand;
        public event GridViewBtnEvent OnDeleteCommand;
        public event EmptyBtnEvent OnRefreshPersonGrid;
        public event EmptyBtnEvent OnSaveEditPerson;
        public event EmptyBtnEvent OnClearEditPerson;
        public event EmptyEvent OnPageLoadNoPostback;
 
        public PersonView()
        {
            postBack = false;
            base.SelfRegister(this);
            blnRegistered = true;
        }
 
        /// <summary>
        /// This is used by the test subsystem to avoid the self-registry action and allow normal
        /// object creation.
        /// </summary>
        /// <param name="noRegister"></param>
        public PersonView(bool noRegister)
        {
            blnRegistered = false;
            postBack = false;
        }
 

PersonView.cs (Part 2)
 public void Fill_gvPerson(IList<PersonDto> data)
{
    _gvPerson = data;
}
 
protected internal IList<PersonDto> GvPerson
{
    get { return _gvPerson; }
}
 
public void FireEvent_OnEditCommand(Guid id)
{
    OnEditCommand(id);
}
 
public void FireEvent_OnDeleteCommand(Guid id)
{
    OnDeleteCommand(id);
}
 
public void FireEvent_OnRefreshPersonGrid()
{
    OnRefreshPersonGrid();
}
 
public void FireEvent_OnSaveEditPerson()
{
    if (_txtUserID != null)
    {
        OnSaveEditPerson();
    }
}
 
public void FireEvent_OnClearEditPerson()
{
    OnClearEditPerson();
}
 
public void FireEvent_OnPageLoadNoPostback()
{
    OnPageLoadNoPostback();
}
 

PersonView.cs (Part 3)
         public string txtPersonIdValue
        {
            get { return _txtPersonID; }
            set { _txtPersonID = value; }
        }
 
        public string txtFirstNameValue
        {
            get { return _txtFirstName; }
            set { _txtFirstName = value; }
        }
 
        public string txtLastNameValue
        {
            get { return _txtLastName; }
            set { _txtLastName = value; }
        }
 
        public string txtEmailValue
        {
            get { return _txtEmail; }
            set { _txtEmail = value; }
        }
 
        public string txtUserIdValue
        {
            get { return _txtUserID; }
            set { _txtUserID = value; }
        }
 
        bool IView.IsPostback
        {
            get 
            {
                if (!postBack)
                {
                    postBack = true;
                    return false;
                }
                else
                    return true;
            }
        }
    }
}
 

BasePage.cs must also be copied to the unit test project, and it also no longer references System.Web. It is renamed to BaseView.cs in the actual solution. You will note that the property IsPostBack throws a NotImplementedException, but it could be set to a read/write property and provide values through an external property setter in the tests.

BaseView.cs
 using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Linq;
using System.Text;
using BusinessServices;
 
namespace BootstrapperUnitTests
{
    public class BaseView : IView
    {
        private string _requestUrl;
        private NameValueCollection _queryString = new NameValueCollection();
        
 
        protected T RegisterView<T>() where T : Presenter
        {
            return PresentationManager.RegisterView<T>(typeof(T), this, null);
        }
 
        protected void SelfRegister(IView page)
        {
            if (page != null && page is IView)
            {
                object[] attributes = page.GetType().GetCustomAttributes(typeof(PresenterTypeAttribute), true);
 
                if (attributes != null && attributes.Length > 0)
                {
                    foreach (Attribute viewAttribute in attributes)
                    {
                        if (viewAttribute is PresenterTypeAttribute)
                        {
                            PresentationManager.RegisterView((viewAttribute as PresenterTypeAttribute).PresenterType,
                                page as IView, null);
                            break;
                        }
                    }
                }
            }
        }
 
        public NameValueCollection RequestString
        {
            get { return _queryString; }
        }
 
        public string RequestUrl
        {
            get { return _requestUrl; }
            set { _requestUrl = value; }
        }
 
        public bool IsPostback
        {
            get { throw new NotImplementedException(); }
        }
    }
}
 

The tests themselves have been expanded and now show a considerably increased code coverage. In doing so the tests are now a combination of unit tests and integration tests, but I would argue that this is desirable as it increases the overall reliability of the solution, which is the purpose of automated tests.

PersonPresenterTests.cs (Pt 1)
 using System;
using System.Collections.Generic;
using NUnit.Framework;
using DomainModel.Person;
using NHibernate;
using NHibernate.Context;
using NHibernateDAO;
using NHibernateDAO.DAOImplementations;
using BootstrapperUnitTests.Views;
using BootstrapperUnitTests.TestData;
using BusinessServices.Interfaces;
using BusinessServices.Presenters;
using DataServices.Person;
 
namespace BootstrapperUnitTests.PresenterTests
{
    [TestFixture]
    public class PersonPresenterTests
    {
        private ISession m_session;
 
        [TestFixtureSetUp]
        public void TestFixtureSetup()
        {
            var session = SessionManager.SessionFactory.OpenSession();
            CallSessionContext.Bind(session);
        }
 
        [TestFixtureTearDown]
        public void TestFixtureTeardown()
        {
            PersonTestData ptd = new PersonTestData();
            ptd.RemoveAllPersonEntries();
 
            var session = CallSessionContext.Unbind(SessionManager.SessionFactory);
            if (session != null)
            {
                if (session.Transaction != null && session.Transaction.IsActive)
                {
                    session.Transaction.Rollback();
                }
                else
                    session.Flush();
 
                session.Close();
            }
 
            session.Dispose();
        }
 

PersonPresenterTests.cs (Pt 2)
 [Test]
public void View_OnEditCommandTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(1);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    PersonPresenter _pp =new PersonPresenter(new PersonView(false));
 
    daoPerson = null;
    m_session = null;
 
    _pp._view_OnEditCommand(people[0].Id);
    IPersonView _pv = _pp.personView;
    Assert.IsTrue(new Guid(_pv.txtPersonIdValue).Equals(people[0].Id));
    Assert.IsTrue(_pv.txtUserIdValue.Equals(people[0].UserID));
 
    ptd = null;
    _pv = null;
    _pp = null;
}
 

PersonPresenterTests.cs (Pt 3)
 [Test]
public void FireEvent_OnEditCommandTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(1);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    IPersonView _pv = new PersonView();
    PersonView _pvc = _pv as PersonView;
 
    daoPerson = null;
    m_session = null;
 
    _pvc.FireEvent_OnEditCommand(people[0].Id);
    Assert.IsTrue(new Guid(_pv.txtPersonIdValue).Equals(people[0].Id));
    Assert.IsTrue(_pv.txtUserIdValue.Equals(people[0].UserID));
 
    ptd = null;
    _pv = null;
    _pvc = null;
}
 

PersonPresenterTests.cs (Pt 4)
 [Test]
public void View_OnDeleteCommandTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.RemoveAllPersonEntries();
    ptd.CreatePersonEntries(1);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    PersonPresenter _pp = new PersonPresenter(new PersonView(false));
    IPersonView _pv = _pp.personView;
 
    daoPerson = null;
    m_session = null;
 
    _pp._view_OnDeleteCommand(people[0].Id);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    daoPerson = new PersonDAOImpl(m_session);
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.AreEqual(people.Count, 0);
    }
 
    ptd = null;
    _pv = null;
    _pp = null;
}
 

PersonPresenterTests.cs (Pt 5)
 [Test]
public void FireEvent_OnDeleteCommandTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.RemoveAllPersonEntries();
    ptd.CreatePersonEntries(1);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    IPersonView _pv = new PersonView();
    PersonView _pvc = _pv as PersonView;
 
    daoPerson = null;
    m_session = null;
 
    _pvc.FireEvent_OnDeleteCommand(people[0].Id);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    daoPerson = new PersonDAOImpl(m_session);
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.AreEqual(people.Count, 0);
    }
 
    ptd = null;
    _pv = null;
    _pvc = null;
}
 

PersonPresenterTests.cs (Pt 6)
         [Test]
        public void View_OnClearEditPerson()
        {
            PersonPresenter _pp = new PersonPresenter(new PersonView(false));
            IPersonView _pv = _pp.personView;
 
            _pv.txtFirstNameValue = "testData";
 
            _pp._view_OnClearEditPerson();
            Assert.IsNullOrEmpty(_pv.txtFirstNameValue);
 
            _pv = null;
            _pp = null;
        }
 
        [Test]
        public void FireEvent_OnClearEditPerson()
        {
            IPersonView _pv = new PersonView();
            PersonView _pvc = _pv as PersonView;
 
            _pv.txtFirstNameValue = "testData";
 
            _pvc.FireEvent_OnClearEditPerson();
            Assert.IsNullOrEmpty(_pv.txtFirstNameValue);
 
            _pv = null;
            _pvc = null;
        }
 
        [Test]
        public void Get_PersonDataTest()
        {
            PersonTestData ptd = new PersonTestData();
            ptd.CreatePersonEntries(3);
 
            m_session = SessionManager.SessionFactory.GetCurrentSession();
            ICriteria crit = m_session.CreateCriteria(typeof(Person));
            PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
            IList<Person> people;
 
            using (var tx = m_session.BeginTransaction())
            {
                people = daoPerson.GetByCriteria(crit);
                tx.Commit();
                Assert.GreaterOrEqual(people.Count, 1);
            }
 
            PersonPresenter _pp = new PersonPresenter(new PersonView(false));
            Assert.IsInstanceOf<PersonPresenter>(_pp);
 
 
            daoPerson = null;
            m_session = null;
 
            IList<PersonDto> pers = _pp.Get_PersonData();
            Assert.GreaterOrEqual(pers.Count, 3);
 
            ptd = null;
 
            _pp = null;
        }
 

PersonPresenterTests.cs (Pt 7)
 [Test]
public void FireEvent_OnPageLoadNoPostbackTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(3);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    IPersonView _pv = new PersonView();
    PersonView _pvc = _pv as PersonView;
 
    people = null;
    daoPerson = null;
    m_session = null;
 
    _pvc.FireEvent_OnPageLoadNoPostback();
    Assert.GreaterOrEqual(_pvc.GvPerson.Count, 3);
 
    ptd = null;
    _pv = null;
    _pvc = null;
}
 

PersonPresenterTests.cs (Pt 8)
 [Test]
public void View_OnRefreshPersonGridTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(3);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    PersonPresenter _pp = new PersonPresenter(new PersonView(false));
    IPersonView _pv = _pp.personView;
    PersonView _pvc = _pv as PersonView;
 
    people = null;
    daoPerson = null;
    m_session = null;
 
    _pvc.FireEvent_OnRefreshPersonGrid();
    Assert.GreaterOrEqual(_pvc.GvPerson.Count, 3);
 
    ptd = null;
    _pp = null;
    _pv = null;
    _pvc = null;
}
 

PersonPresenter.cs (Pt 9)
 [Test]
public void FireEvent_OnRefreshPersonGridTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(3);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    IPersonView _pv = new PersonView();
    PersonView _pvc = _pv as PersonView;
 
    people = null;
    daoPerson = null;
    m_session = null;
 
    _pvc.FireEvent_OnRefreshPersonGrid();
    Assert.GreaterOrEqual(_pvc.GvPerson.Count, 3);
 
    ptd = null;
 
    _pv = null;
    _pvc = null;
}
 

PersonPresenterTests.cs (Pt10)
 [Test]
public void View_OnSaveEditPersonNewTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.RemoveAllPersonEntries();
 
    PersonPresenter _pp = new PersonPresenter(new PersonView(false));
    IPersonView _pv = _pp.personView;
 
    _pv.txtPersonIdValue = "";
    _pv.txtFirstNameValue = "Mary";
    _pv.txtLastNameValue = "Johnston";
    _pv.txtEmailValue = "some@email";
    _pv.txtUserIdValue = "mj1";
 
    _pp._view_OnSaveEditPerson();
 
    _pv = null;
    _pp = null;
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    people = null;
    daoPerson = null;
    m_session = null;
 
    ptd = null;
}
 

PersonPresneterTests.cs (Pt11)
 [Test]
public void FireEvent_OnSaveEditPersonNewTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.RemoveAllPersonEntries();
 
    IPersonView _pv = new PersonView();
 
    _pv.txtPersonIdValue = "";
    _pv.txtFirstNameValue = "Mary";
    _pv.txtLastNameValue = "Johnston";
    _pv.txtEmailValue = "some@email";
    _pv.txtUserIdValue = "mj1";
 
    PersonView _pvc = _pv as PersonView;
    _pvc.FireEvent_OnSaveEditPerson();
 
    _pv = null;
    _pvc = null;
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    people = null;
    daoPerson = null;
    m_session = null;
 
    ptd = null;
}
 

PersonPresenterTests.cs (Pt12)
 [Test]
public void View_OnSaveEditPersonExistingTest()
{
    PersonTestData ptd = new PersonTestData();
    ptd.RemoveAllPersonEntries();
    ptd.CreatePersonEntries(1);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    IList<Person> people;
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    PersonPresenter _pp = new PersonPresenter(new PersonView(false));
    IPersonView _pv = _pp.personView;
 
    _pv.txtPersonIdValue = people[0].Id.ToString();
    _pv.txtFirstNameValue = people[0].FirstName;
    _pv.txtLastNameValue = people[0].LastName;
    _pv.txtEmailValue = people[0].Email;
    _pv.txtUserIdValue = "differentUser";
 
    _pp._view_OnSaveEditPerson();
 
    _pv = null;
    _pp = null;
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    crit = m_session.CreateCriteria(typeof(Person));
    daoPerson = new PersonDAOImpl(m_session);
 
    using (var tx = m_session.BeginTransaction())
    {
        people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    people = null;
    daoPerson = null;
    m_session = null;
 
    ptd = null;
}
 

PersonPresenterTests.cs (Pt13)
         [Test]
        public void FireEvent_OnSaveEditPersonExistingTest()
        {
            PersonTestData ptd = new PersonTestData();
            ptd.RemoveAllPersonEntries();
            ptd.CreatePersonEntries(1);
 
            m_session = SessionManager.SessionFactory.GetCurrentSession();
            ICriteria crit = m_session.CreateCriteria(typeof(Person));
            PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
            IList<Person> people;
 
            using (var tx = m_session.BeginTransaction())
            {
                people = daoPerson.GetByCriteria(crit);
                tx.Commit();
                Assert.GreaterOrEqual(people.Count, 1);
            }
 
            IPersonView _pv = new PersonView();
 
            _pv.txtPersonIdValue = people[0].Id.ToString();
            _pv.txtFirstNameValue = people[0].FirstName;
            _pv.txtLastNameValue = people[0].LastName;
            _pv.txtEmailValue = people[0].Email;
            _pv.txtUserIdValue = "differentUser";
 
            PersonView _pvc = _pv as PersonView;
            _pvc.FireEvent_OnSaveEditPerson();
 
            _pv = null;
            _pvc = null;
 
            m_session = SessionManager.SessionFactory.GetCurrentSession();
            crit = m_session.CreateCriteria(typeof(Person));
            daoPerson = new PersonDAOImpl(m_session);
 
            using (var tx = m_session.BeginTransaction())
            {
                people = daoPerson.GetByCriteria(crit);
                tx.Commit();
                Assert.GreaterOrEqual(people.Count, 1);
            }
 
            people = null;
            daoPerson = null;
            m_session = null;
 
            ptd = null;
        }
 
    }
}
 

Unit tests have also been included for an unique object and also for the added NHibernate LINQ capabilities

PersonDAOImplTest.cs (Pt 1)
 using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DomainModel.Person;
using NHibernateDAO;
using NHibernateDAO.DAOImplementations;
using NUnit.Framework;
using NHibernate;
using NHibernate.Context;
using NHibernate.Linq;
using BootstrapperUnitTests.TestData;
 
namespace BootstrapperUnitTests
{
    [TestFixture]
    public class PersonDAOImplTests
    {
 
        private ISession m_session;
 
        [TestFixtureSetUp]
        public void TestFixtureSetup()
        {
            var session = SessionManager.SessionFactory.OpenSession();
            CallSessionContext.Bind(session);
        }
 
        [TestFixtureTearDown]
        public void TestFixtureTeardown()
        {
            PersonTestData ptd = new PersonTestData();
            ptd.RemoveAllPersonEntries();
 
            var session = CallSessionContext.Unbind(SessionManager.SessionFactory);
            if (session != null)
            {
                if (session.Transaction != null && session.Transaction.IsActive)
                {
                    session.Transaction.Rollback();
                }
                else
                    session.Flush();
 
                session.Close();
            }
 
            session.Dispose();
        }
 

PersonDAOImplTests.cs (Pt 2)
 [Test]
public void PersonSaveTestWithTx()
{
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    Person _person = new Person();
    _person.FirstName = "John";
    _person.LastName = "Davidson";
    _person.Email = "jwdavidson@gmail.com";
    _person.UserID = "jwd";
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
    
    using (var tx = m_session.BeginTransaction())
    {
        Person newPerson = daoPerson.Save(_person);
        tx.Commit();
        Assert.AreEqual(_person, newPerson);
    }
 
    _person = null;
    daoPerson = null;
    m_session = null;
}
 
[Test]
public void PersonCriteriaQueryTestWithTx()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(3);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    using (var tx = m_session.BeginTransaction())
    {
        IList<Person> people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 3);
    }
 
    daoPerson = null;
    m_session = null;
 
    ptd.RemoveAllPersonEntries();
    ptd = null;
}
 

PersonDAOImplTest.cs (Pt 3)
 [Test]
public void PersonDeleteTestWithTx()
{
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    m_session.FlushMode = FlushMode.Commit;
    Person _person = new Person();
    _person.FirstName = "John";
    _person.LastName = "Davidson";
    _person.Email = "jwdavidson@gmail.com";
    _person.UserID = "jwd";
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    Person newPerson;
    using (var tx = m_session.BeginTransaction())
    {
        newPerson = daoPerson.Save(_person);
        tx.Commit();
        Assert.AreEqual(_person, newPerson);
        Console.WriteLine("Person ID: {0}", newPerson.Id);
    }
 
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    
    Int32 pers = 0;
    using (var tx = m_session.BeginTransaction())
    {
        IList<Person> people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Assert.Greater(people.Count, 0);
        pers = people.Count;
        Console.WriteLine("Count After Add: {0}", pers);
    }
 
    using (var tx = m_session.BeginTransaction())
    {
        daoPerson.Delete(newPerson);
        tx.Commit();
        newPerson = null;
    }
 
    using (var tx = m_session.BeginTransaction())
    {
        IList<Person> people = daoPerson.GetByCriteria(crit);
        tx.Commit();
        Console.WriteLine("Count after Delete: {0}", people.Count);
 
        Assert.IsTrue(pers.Equals(people.Count + 1));
    }
 
    _person = null;
    daoPerson = null;
    m_session = null;
}
 

PersonDAOImplTests.cs (Pt 4)
 [Test]
public void PersonSaveTestWithoutTx()
{
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    Person _person = new Person();
    _person.FirstName = "John";
    _person.LastName = "Davidson";
    _person.Email = "jwdavidson@gmail.com";
    _person.UserID = "jwd";
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
    Person newPerson = daoPerson.Save(_person);
 
    Assert.AreEqual(_person, newPerson);
    _person = null;
    newPerson = null;
    daoPerson = null;
    m_session = null;
}
 
[Test]
public void PersonCriteriaQueryTestWithoutTx()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(3);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    ICriteria crit = m_session.CreateCriteria(typeof(Person));
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
    IList<Person> people = daoPerson.GetByCriteria(crit);
 
    Assert.GreaterOrEqual(people.Count, 3);
    people = null;
    daoPerson = null;
    m_session = null;
 
    ptd.RemoveAllPersonEntries();
    ptd = null;
}
 

PersonDAOImplTest.cs (Pt 5)
 [Test]
public void PersonLinqQueryTestWithTx()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(3);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    IQueryable<Person> qry = from p in m_session.Query<Person>() select p;
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    using (ITransaction tx = m_session.BeginTransaction())
    {
        IList<Person> people = daoPerson.GetByQueryable(qry);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 3);
    }
 
    daoPerson = null;
    m_session = null;
 
    ptd.RemoveAllPersonEntries();
    ptd = null;
}
 
[Test]
public void PersonLinqQueryWhereTestWithTx()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(3);
 
    string userid = "jwd2";
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    IQueryable<Person> qry = from p in m_session.Query<Person>() where p.UserID == userid select p;
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
 
    using (ITransaction tx = m_session.BeginTransaction())
    {
        IList<Person> people = daoPerson.GetByQueryable(qry);
        tx.Commit();
        Assert.GreaterOrEqual(people.Count, 1);
    }
 
    daoPerson = null;
    m_session = null;
 
    ptd.RemoveAllPersonEntries();
    ptd = null;
}
 

PersonDAOImplTests.cs (Pt 6)
 [Test]
public void PersonLinqQueryTestWithoutTx()
{
    PersonTestData ptd = new PersonTestData();
    ptd.CreatePersonEntries(3);
 
    m_session = SessionManager.SessionFactory.GetCurrentSession();
    IQueryable<Person> qry = from p in m_session.Query<Person>() select p;
    PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
    IList<Person> people = daoPerson.GetByQueryable(qry);
 
    Assert.GreaterOrEqual(people.Count, 3);
    people = null;
    daoPerson = null;
    m_session = null;
 
    ptd.RemoveAllPersonEntries();
    ptd = null;
}
 

PersonDAOImplTests.cs (Pt 7)
         [Test]
        public void PersonDeleteTestWithoutTx()
        {
            m_session = SessionManager.SessionFactory.GetCurrentSession();
            m_session.FlushMode = FlushMode.Commit;
            Person _person = new Person();
            _person.FirstName = "John";
            _person.LastName = "Davidson";
            _person.Email = "jwdavidson@gmail.com";
            _person.UserID = "jwd";
            PersonDAOImpl daoPerson = new PersonDAOImpl(m_session);
            Person newPerson = daoPerson.Save(_person);
 
            Assert.AreEqual(_person, newPerson);
            Console.WriteLine("Person ID: {0}", newPerson.Id);
 
            ICriteria crit = m_session.CreateCriteria(typeof(Person));
            IList<Person> people = daoPerson.GetByCriteria(crit);
 
            Assert.Greater(people.Count, 0);
            Int32 pers = people.Count;
            Console.WriteLine("Count After Add: {0}", pers);
 
            people = null;
            daoPerson.Delete(newPerson);
            newPerson = null;
            people = daoPerson.GetByCriteria(crit);
            Console.WriteLine("Count after Delete: {0}", people.Count);
 
            Assert.IsTrue(pers.Equals(people.Count + 1));
 
            people = null;
            _person = null;
            daoPerson = null;
            m_session = null;
        }
    }
}
 

Summary

This solution retains all the functionality as was included in the original solution, but it has now been placed in an architecture that improves testability and simplifies the creation of functionality as each element now has a clear project where it belongs within the solution. The next evolution of the bootstrapper will investigate data service usage and more complex mappings. However this version of the bootstrapper is now appropriate to use for simple projects with NHibernate where the domain model is relatively simple.

If you remember back to the code behind file discussion there were still methods that remained for working with the gridview and drop down controls on the web page. These could be moved up to the presenter if these controls were redesigned as composite controls in a separate project in the solution so that they were no longer inherited through System.Web.

NHibernate.Linq 1.0.0 GA released

Tuna Toksoz — Sun, 26 Jul 2009 10:52:00 GMT

We have just released the first version of Linq provider for NHibernate.

The current implementation you'll find in the provided links are based on the NHibernate Contrib project which uses Criteria API. It can support almost everything you can do with Criteria API.

You can get the binaries and the source code from the files section

LINQ to NHibernate Update

Steve Strong — Thu, 11 Jun 2009 13:50:40 GMT

We're long overdue for another update. Progress as been somewhat slower over the last few weeks, largely due to other commitments and holidays meaning that I've probably only spent a total of around 10 days working on this stuff.

Where we are is that I'm pretty comfortable with what needs to happen, and have a fairly clear route for moving forward from my prototype / exploratory coding phase to something that I can actually release to the wild and let folk start playing with.

There are two options as to how this might happen. The first is by utilizing the concepts within the excellent IQToolkit, which provides a great sample for anyone who wants to explore how to build a Linq to Sql provider. Alas, the code can't be used as it stands, since it's quite closely tied to building and executing SQL and then processing the resulting data rows, which isn't quite what we're trying to achieve here. However, the fundamental concepts and algorithms for handling some of the Linq complexities are certainly valid, and can be ported across to meet our needs relatively simply.

The second option is by building on top of the promising re-linq project, which performs a similar task to the first half of the IQ Toolkit, in that it takes a Linq expression tree and turns it into something a little more manageable. re-linq doesn't attempt to handle the execution side, so it precisely avoids some of the stuff that I'd need to rip out of the IQ Toolkit.

re-linq is currently undergoing some final refactoring (some of it driven by the potential to use it within this project,so many thanks to them for keeping us in mind!). This is due to be completed in the next 3 or so weeks; once they are done, a final decision as to the exact approach can be taken and I'd expect pretty fast progress from that point.

Obviously, my original guesstimate of a June date is looking seriously in doubt, but I don't think it'll be too much longer. Hang in there folks, I know it's been a long wait but it'll be worth it!

New Kid on the Block. And some info on Linq to NHibernate

Steve Strong — Thu, 07 May 2009 18:52:00 GMT

This is my first post on this site as an NH committer, and I'm very pleased to be part of the team helping move NH forward for the benefit of everyone. Specifically, I've spent the last few months working semi-full time on helping to build a full Linq-to-NHibernate implementation. The bulk of the effort so far has been porting over the Hibernate ANTLR-based HQL parser - see here for a fairly detailed description of the work that I've been doing. Progress updates so far can be found here, here and here.

For those that don't want to follow all those links, the summary is that the AST parser is largely done (and already being used to great advantage on non-Linq related work by Fabio). I'm currently working through building a basic Linq provider. Based on extensive blogs from Matt Warren & Frans Bouma, I'm fully expecting to hit a couple of fairly big walls whilst doing this, and the chaps at Rubicon have a product called re-linq which may assist with effort. Once I see exactly where the pain points lie, I'll be in a good position to evaluate how to move forward.

Everyone is bound to want to know when this is going to be ready for use - that's a real hard thing to answer right now. It's difficult to foresee exactly how many dragons lie in between me and the goal, plus knowing exactly how much time I can spend on the project is hard. Personally, I'd like to have something looking respectable by June, but don't bet your house on it :)

Anyhow, it's great to be a part of this fantastic product, and I hope the my contribution helps at least some of you out there.

Cheers,

Steve

BTW, as well as this blog, you can also find me at http://blogs.imeta.co.uk/sstrong or on http://twitter.com/srstrong

NHibernate HQL AST Parser

Ayende — Sun, 22 Feb 2009 20:12:58 GMT

Steve from iMeta has been doing a lot of work on the HQL AST Parser. For a long time, that has been a really troublesome pain point for us, since this is a prerequisite for a lot of other features. It is also one of two parts of NHibernate that really need significant refactoring because the way they are built right now make it hard to do stuff (the second being the semantic model for the mapping, which the Fluent NHibernate guys are working on).

Just to give you two features that should make you drool which depends on this work:

Full Linq implementation
Set based DML operations on top of the domain model

In true Open Source manner, you can view the work being done right now: http://unhaddins.googlecode.com/svn/trunk, Checkout the ANTRL-HQL project.

This is something that several members of the NHibernate project has tried doing in the past, but the scope of the work is very big, and require full time work for an extended period of time. iMeta has been sponsoring Steve’s work on NHibernate, which make this possible.

I have been going through the code, and I am literally jumping up and down in excitement. It is still very early, but it is already clear that Steve has taken us much farther than before, and it is possible to see the end. The most significant milestone has been reached, and we are currently able to execute ( a very simple ) query and get the results back:

Yes, it also integrates with NH Prof :-)