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.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Is there any way to identify the SQL DataType of a Property in a LightSpeed Model? (I see that the .Net DataType is stored in the XML, but I don't see the SQL DataType) I am trying to auto format currency and preprocess xml, and other complex sql types that are represented as strings in the Model. |
|
|
|
|
No. The LightSpeed model presents a .NET-centric, database-agnostic view of the model. The actual representation of the data may vary from database to database (for example, GUIDs are represented differently in SQL Server and Oracle). One possible solution is to define custom data types such as Currency and Xml, and use those instead of Decimal and String for those fields. Here's an example of creating and using a Money data type: Another is to apply custom attributes to properties indicating how they should be formatted and/or preprocessed. You can do this using the Custom Attributes setting or (if you have a lot of properties like this and you're confident with the designer) by using custom templates and designer extensibility. |
|
|
|
