public void Log_updates() { var begin = DateTime.Now; var producer = localSession.Query <Producer>().First(); localSession.CreateSQLQuery("delete from Logs.ProducerLogs where ProducerId = :id") .SetParameter("id", producer.Id) .ExecuteUpdate(); var producerDto = new ProducerDto { Checked = !producer.Checked, Id = producer.Id, Name = producer.Name }; service.UpdateProducer(producerDto); var users = localSession.CreateSQLQuery("select OperatorName from Logs.ProducerLogs where ProducerId = :id and LogTime >= :begin") .SetParameter("id", producer.Id) .SetParameter("begin", begin) .List <string>(); Assert.That(users, Is.EquivalentTo(new[] { Environment.UserName })); }