c# - Tinyint as byte nhibernate -

i have table tinyint column in sql server 2008 r2 database, maps byte property in poco.

the problem whenever run query clause on tinyint column using nhibernate, results in following sql...

and cast(table0_.tinyintcolumn int)=@p1  

i want know how rid of behaviour, because although query still works annoying , unnecessary, know of solutions or come across before?

thanks.

this seems bug in linq provider.

of following queries:

session.createquery("from foo tinyintcolumn = :b").setparameter("b", 1) session.queryover<foo>().where(x => x.tinyintcolumn == 1) session.query<foo>().where(x => x.tinyintcolumn == 1) 

...only last 1 results in behavior experiencing.

please open issue @ https://nhibernate.jira.com/