How does one make NHibernate stop using nvarchar(4000) for insert parameter strings?

Specify the Type as NAnsiString with a Length instead of using a CustomSqlType.

I'll give it a shot, thanks for the lead. – Mark Rogers Jul 8 at 15:34 It worked, thanks again! – Mark Rogers Jul 8 at 15:40.

This issue can cause a huge performance problem in queries if it forces SQL Server to perform a table scan instead of using an index. We use varchar throughout our database so I created a convention to set the type globally: /// /// Convert all string properties to AnsiString (varchar). This does not work with SQL CE.

/// public class AnsiStringConvention : IPropertyConventionAcceptance, IPropertyConvention { public void Accept(IAcceptanceCriteria criteria) { criteria. Expect(x => x.Property.PropertyType. Equals(typeof(string))); } public void Apply(IPropertyInstance instance) { instance.

CustomType("AnsiString"); } }.

This may come in handy, thanks for your work! – Mark Rogers Jul 9 at 17:47.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.