In your example below, what happens if I don't specify size in SetParameter? Will it use vnvarchar(4000) by default?
On Oct 28, 6:25 pm, Fabio Maulo <[email protected]> wrote: > No problem but write in your post that what you are saying is YOUR > interpretation of the story. > We can't force, by default, each user to set the parameter dimension in each > query. > Who set prepare-sql=true must know that, at the same time, he must change > his way to write a query and he must set the right size in each query. > select p from Person where p.Name || p.Surname = :pFullName > which is the size of the parameter ? > > Now think about what each user should do with his existing project if we > will make that behaviour the default only because a MsSQL issue. > Who serve who ? > The RDBMS serve us or we should serve de RDBMS ? > > If your choice is "serve MsSQL" we are giving you the way to do that (and > its very easy, as I showed above). > > 2009/10/28 zvolkov <[email protected]> > > > > > > > Fabio, this was my interpretation of your comment on NH-1713: "NH-1707 > > was reverted because, more than our work, it mean additional attention > > by the user when he create a query (each parameter may need additional > > info)... is better if the user set prepare_sql explicitly". My > > apologies if what you meant was different from how I understood it. > > > On Oct 28, 6:02 pm, Fabio Maulo <[email protected]> wrote: > > > I don't know where you read or saw part of your story. > > > Try to implement that Drive and le me knoe what you must do when you are > > > setting the parameters of each query (NHQ and Criteria). > > > After that let me know who are doing it in each query. > > > > 2009/10/28 zvolkov <[email protected]> > > > > > Blogged: NHibernate parameter sizes controversy, history of the issue > > > > >http://zvolkov.com/blog/post/2009/10/28/NHibernate-parameter-sizes-co. > > .. > > > > -- > > > Fabio Maulo > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
