public IQueryable<T> Query(Expression<Func<T, bool>> predicate)
{
    IQueryable<T> returnValue;
    using (ITransaction transaction = _session.BeginTransaction())
    {
        try
        {
            returnValue = _session.Linq<T>().Where(predicate);
            transaction.Commit();
        }

set nocount on
 
-- build a working table called x
 
if (object_id('x') is not null) 
    drop table x
create table x (col1 varchar(50))
 
declare @sql nvarchar(500)
set @sql = 'insert into x select ''test'';'