the query I'm copying from NHProf is like your second example using @p0 = 123456789 or @p= '123456789'
i set the sqltype as nvarchar(9) in the mapping file and I'm still getting the same result. I tried nvarchar as well. I even changed the type in the db to char(9) and used that in the mapping file. No combination of data types and length specifications seems to change the behavior. I can't help but think NHibernate is trying to be too cleaver here, by looking to see if this is a number and not quoting it. I can see where that helps if you are querying a number column, but it is causing the CONVERT_IMPLICIT issue when the underlying column is a character data type. I wonder if there is a flag somewhere to turn off the thing that is unquoting this string? Ralph On May 20, 11:18 am, José F. Romaniello <[email protected]> wrote: > 2011/5/20 Ralph Balck <[email protected]> > > > <property name="SSN" type="System.String, mscorlib, > > Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> > > <column name="SSN" /> > > </property> > > can you show us exactly the loging result... because nhibernate doesn't > execute this: > select * from Census where SSN=265145847 > > it might be something like: > select .... from ... where SSN = @p0 ; @p0 = .... > > the problem, i see is that > 1-you don't have the lenght of the column > 2- you would probably need to use <column name="SSN" sql-type="nvarchar(8)" > /> > > but try first 1. > Maybe you see is a CONVERT_IMPLICIT because is converting a varchar > parameter to a nvarchar column.. or different sizes. > Not quite sure what is going on... -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
