Moq NHibernate Session for Unit Testing

[sos....@gmail.com]

Hi,  I am writing the Unit tests against the MVC application, which is based on Nhibernate.  I have successfully Moq ed some repository classes / functions in order to test my service layer methods.  But I came to this function below in my repository and I don't know how to Moq it.  I need to Moq this function as many other functions rely on it.  The function:

public T GetByProperty<T>(string property, object value)
{
   return (T)
       this.Session.CreateCriteria(typeof(T))
       .Add(NHibernate.Criterion.Restrictions.Eq(property, value))
       .SetCacheable(RepositoryFactory.CanCache<T>()).SetCacheMode(CacheMode.Normal)
       .UniqueResult();
}

I've never worked with Nhibernate before and I am not sure whether I need to Moq Session or somehow I can Moq the whole method or what?

I've tried this but it always returns null:

Mock mockRepository = new Mock<IRepository>();
mockRepository.Setup(x => x.GetByProperty<Account>(“UserName”, “MyUserName”))

  .Returns(new Account { UserName = “MyUserName” });

I appreciate for you suggestions, thanks.

[Oskar Berggren]

Regarding why mocking your GetByProperty() doesn't work it sounds like more of a question for the Moq communit. I don't know it at least.

As for mocking the ISession itself I suspect it will lead to much troubles due to too much work required to return the proper things for each query. Besides, it won't actually verify if your queries work with _NHibernate_ or not. In my experience at least it's better to mock away the whole method that implements the query (i.e. GetProperty() in this case), and then separately test the queries by having tests that run with full NHibernate and an actual database. Either as full system tests or if you do "unit tests" than runs just the queries, but with a database connected.

/Oskar

--
You received this message because you are subscribed to the Google Groups "nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhusers+u...@googlegroups.com.
To post to this group, send email to nhu...@googlegroups.com.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

[Rein Verberne]

Maybe in Setup use It.IsAny<string> and It.IsAny<object> ?

---

Van: sos....@gmail.com
Verzonden: ‎3-‎8-‎2016 11:35
Aan: nhusers
Onderwerp: [nhusers] Moq NHibernate Session for Unit Testing

[Gunnar Liljas]

Try 

mockRepository.Setup(x => x.GetByProperty<Account>(“UserName”, (object)“MyUserName”))

  .Returns(new Account { UserName = “MyUserName”});