xml and varchar(max)

Posts   
 
    
J-Ray
User
Posts: 1
Joined: 03-Jan-2008
# Posted on: 03-Jan-2008 03:18:33   

LLBLGen Pro. Version 2.5 Final SqlServer2005 -> replicating to SqlServerCE SQLServer DBDriver (2.5.08162007)

Generating against a SqlServer2005 database, xml and varchar(max) data types appear to be used as varchar(2147483647). However, when replicated to a SqlServerCE database, neither of these data types is supported and they are both converted to ntext. This creates a problem when trying to insert a varchar() type into a ntext field in the SqlServerCE database.

Is there an explicit way to force certain entity fields to generate as if the underlying database type was ntext instead of varchar()? Is there support to generate directly against a SqlServerCE database?

Thanks, Jason

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 03-Jan-2008 04:43:34   

Please read LLBLGenPro Help - Using generated code - Database specific features - SqlServer specific: SqlServer CE Desktop support

This thread should be helpful too: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=12140

David Elizondo | LLBLGen Support Team