I created the DB using

SqlCeEngine engine = new SqlCeEngine(_db.ConnectionString);
engine.CreateDatabase();

Then I used the SchemaExport to create the table.  The column is the
PropertyXml and I have been round and round with the length hint. Now
it is off.

  <property name="PropertyXml" type="String"  >
      <column name="PropertyXml" sql-type="ntext" />
    </property>

This is the output from Schema Export...
create table PanelDesign (
  Id NVARCHAR(16) not null,
   DisplayElementType NVARCHAR(20) null,
   PropertyXml ntext null,
   DeviceId NVARCHAR(255) null,
   primary key (Id)
)

The max is still there...
 System.InvalidOperationException : @p1 : String truncation: max=4000,
len=20595, value='<FlexProperties>

Thanks for looking at this.
jeff

On Dec 29, 3:58 pm, "Gustavo Ringel" <[email protected]> wrote:
> The sqlce database was created using SchemaUpdate or SchemaExport or did you
> work with an already created DB? maybe the limit is in the column
> definition.
>
> If you are creating the schema using one of those i will recommend removing
> the hint every string greater than 4000 is supposed to be understand as
> ntext definition for MsSqlCe dialect
>
> Gustavo.
>
> On Mon, Dec 29, 2008 at 10:35 PM, jeff.jarrell <[email protected]>wrote:
>
>
>
>
>
> > I have been working with a mapping where I am storing an xml fragment
> > in an NText field.  The xml is about 28k bytes.  If I am working in
> > MsSql it works fine.
>
> > When I change the dialect to go against MsSql Ce I get an
> > InvalidOperationException.  When I look at the stack trace i get
> > System.InvalidOperationException : @p1 : String truncation: max=4000,
> > len=20595, value='<FlexP...
>
> > Where is the max = 4000 coming from?  I am using the SchemaExport tool
> > to drive table creation from the mapping.
>
> > Here is the mapping...
> > <?xml version="1.0" encoding="utf-8" ?>
> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
> >  <class
> > name="Crestron.Tools.DeviceLibrary.PanelDesign.DisplayElement,
> > Crestron.Tools.PanelDesigner.UnitTests" table="PanelDesign">
> >    <id name="Id" column="Id"  type="String" unsaved-value="" length
> > ="16"
> >      access="field.camelcase-underscore">
> >      <generator class="Crestron.Tools.Core.Data.IdGenerator,
> > Crestron.Tools.Core"/>
> >    </id>
>
> >    <!-- String on the DBSide, Enum in class, note use of EnumMapper --
>
> >    <property name="DisplayElementType" length="20"
>
> > type="Crestron.Tools.DeviceLibrary.PanelDesign.DisplayElementTypeEnumMapper­,
> > Crestron.Tools.PanelDesigner.UnitTests"
> >              />
>
> >    <property name="PropertyXml" type="String" length="30000">
> >      <column name="PropertyXml" sql-type="ntext"/>
> >    </property>
>
> >    <property name="DeviceId" type="String"/>
>
> >  </class>
> > </hibernate-mapping>
>
> > Thanks,
> > jeff- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to