Page 1 of 1

TEXT is not a valid datatype for SQL Compact 4.0

Posted: Tue 11 Dec 2012 18:25
by sdbcs
Moin,

using version 4.7.313 of EntityDeveloper I've built a model and selected "Update database from model" to create the new storage for a SQL Compact 4.0 database. Unfortunately the SQL script tries to use TEXT as a type for a table column. TEXT does not appear to be supported by SQL Compact 4.0. The model property is of type string. Is this a bug or might I doing something wrong ?

-Stefan

Re: TEXT is not a valid datatype for SQL Compact 4.0

Posted: Mon 17 Dec 2012 14:43
by Shalex
Thank you for the report. We have reproduced the issue and are investigating it.

Re: TEXT is not a valid datatype for SQL Compact 4.0

Posted: Wed 26 Dec 2012 13:03
by Shalex
The bug with generating a database type for the string property of a class is fixed in the latest (5.0.9) build of Entity Developer.