This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product. Otherwise - post away!
I set up a new DB scheme and configured the string size to be 1024 inside the model designer.
Now the problem is that my tables are not created the way I expected, only the default values were set using the XML document from the respective MappingXml property.
Any thoughts are appreciated.
I haven't been able to reproduce this. I created a new entity and did an Add New Entity Property on it. I set the property's Size to be 1024. Then I did an Update Database from Model, Log SQL, and it showed me a NVARCHAR(1024) column. I tried changing the Size to be 512 and blank and then back to 1024 again, and each time the update SQL reflected the specified size.
Could you maybe provide us with a minimal model (just one entity with a minimal number of properties) that exhibits the problem? And maybe you could also post the SQL you see when you do an Update Database with Log SQL switched on? Thanks!