By default, AR is passing string properties as nvarchar instead of varchar, my SQL Server 2000 existing database uses varchar as its string type and is causing a full-table scan on the query.
Is there any way to force AR/NH to pass varchar instead of nvarchar. What it's currently passing: exec sp_executesql N'SELECT [QUERY] WHERE this_.member = @p0', N'@p0 nvarchar(11)', @p0 = N'01130004903' What I would like it to pass: exec sp_executesql N'SELECT [QUERY] WHERE this_.member = @p0', N'@p0 varchar(11)', @p0 = '01130004903' Is there a document somewhere of the NHibernate Types to SQL Server columns? Jason --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" 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/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
