I am glad you have resolved the situation.
As you found out, one of the ways to change the SQL type of the column to nvarchar(max), or any other type, is to use the Table Editor
Note that the SQL type can also be set using the SqlType
property located in the properties window of the column. Using this approach however, you will have to type the name of the property manually instead of selecting it from a drop-down list.
Additionally, in case you need to change the SQL type of multiple columns, you can do so by using Model Operations
- Open the Model Operations dialog.
- Select Members as the Display Mode. You can filter the displayed columns by their SQL type.
- Choose the columns which which type you wish to change.
- From the Operation drop-down list, select the Change SQL Type operation.
- Click the Execute button.
I hope this helps. In case you have additional questions, feel free to contact us via our ticketing system or post in our forums again.
OpenAccess ORM Q3 2013 simplifies your model operations even further providing you with greater flexibility. Check out the list of new features
shipped with our latest release!