I found the answer from a colleague, "AnsiString" but I still can't find the actual <i>list</i>
On Feb 25, 11:05 am, jasonsirota <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
