Seems like "Text" was deprecated with SQL2005, you can use .WithLength (10000) in your mapping file and it will create nvarchar(max) column.
-Ryan On Feb 14, 7:41 am, Foltz <[email protected]> wrote: > hey, > > I came across what I think is bug in fluent-nh with the mapping of > text fields (i.e. string-clobs). > To verify that I am using the right technique, I tested this out with > fluent mapping and using fluent-nh to read hbm maps as well. > > fluent: > > Map(x => x.Body).CustomSqlTypeIs("text"); > > hbm: > > <property name="Body" type="String"> > <column name="Body" sql-type="text"/> > </property> > > In both cases, It produces a varchar(100) field in an mssql-2005 > database. > > I used the same hbm/mapping file with the core-nhibernate schema > generation technique, and it works correctly. > > Oddly enough, I tried running the same test in sqlite, and all three > techniques (fluent-map, fluent-hbm and core-hbm) generate the field as > type-text, but also generate another field I'd specified to be a > varchar as text as well, so it looks like both core and fluent have a > bug with sqlite. > > Since I've only recently started playing with fluent-nh, and am not > overly familiar with core-nh, I assume that I may be using the wrong > technique. If it turns out that this IS a bug, I can submit a report > with the test project I used to demonstrate the discrepancy. > Otherwise, if I'm missing some critical step, please let me know. > > thx, > foltz --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Fluent NHibernate" 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/fluent-nhibernate?hl=en -~----------~----~----~----~------~----~------~--~---
