public void Update(Service service)
 {
     using (ISession session = NHibernateHelper.OpenSession())
     {
         using (ITransaction transaction = session.BeginTransaction())
         {
             session.Update(service);
             transaction.Commit();
         }
     }
 }
        public void Can_add_new_service()
        {
            var service = new Service { Name = "Build", Description = "Build stuff" };
            IServiceRepository repository = new ServiceRepository();
            repository.Add(service);

            // use session to try to load the service
            using (ISession session = _sessionFactory.OpenSession())
            {
                var fromDb = session.Get<Service>(service.Id);
                Assert.IsNotNull(fromDb);
                Assert.AreNotSame(service, fromDb);
                Assert.AreEqual(service.Name, fromDb.Name);
                Assert.AreEqual(service.Description, fromDb.Description);
            }
        }