You're reading from NHibernate 4.x Cookbook Over 90 incredible and powerful recipes to help you efficiently use NHibernate in your application

Product type Paperback

Published in Jan 2017

Publisher Packt

ISBN-13 9781784396428

Length 448 pages

Edition 2nd Edition

Tools

NHibernate

Concepts

Application Development

Authors (4):

Liljas

Darshan Joshi

Zaytsev

Jason Dentler

View More author details

Table of Contents (11) Chapters

Preface

1. The Configuration and Schema FREE CHAPTER

2. Models and Mappings

3. Sessions and Transactions

4. Queries

5. Improving Performance

6. Testing

7. Data Access Layer

8. Extending NHibernate

9. NHibernate Contribution Projects

Index

Setting Microsoft SQL's Context_Info

In this recipe, we will show you how to use Microsoft SQL Server's Context_Info to provide the current username to your audit triggers.

Getting ready

Complete the previous recipe, Generating trigger-based auditing
Download Ninject.dll and CommonServiceLocator.NinjectAdapter.dll from the Ninject project at http://ninject.org
Download Microsoft.Practices.ServiceLocation.dll from the Microsoft patterns and practices team available at http://commonservicelocator.codeplex.com/

How to do it…

Add a reference to Ninject.dll, CommonServiceLocator.NinjectAdapter.dll and Microsoft.Practices.ServiceLocation.dll.

Add the following IAuditColumnSource implementation:

public class CtxAuditColumnSource : IAuditColumnSource 
{


  public IEnumerable<AuditColumn> 
    GetAuditColumns(Table dataTable)
  {
    var userStamp = new AuditColumn()
    {
      Name = "AuditUser",
      Value = new SimpleValue()
      {
        TypeName = NHibernateUtil...