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
|
Hello, We are currently evaluating your product and we got one problem - entity Id columns must be integer or guid type. Our company uses ERP system where all Id's are unique varchars. Will it break the functionality of Lightspeed? |
|
|
|
|
Hi, Are the ids numeric? How are they generated? Cheers, Andrew. |
|
|
|
|
No, they are not. They are generated inside by Microsoft Dynamics AX. |
|
|
|
|
So, you are using LightSpeed for a read-only view of the data? |
|
|
|
|
Attachment 1.png: There is a CustomerId column in Customers table, which is unique varchar. Attachment 2.png: Model is generated without CustomerId property and Identity Type is integer/guid instead of varchar. Attachment 3.png: Visual Studio screenshot. CustomerId is integer. --- And no, we would like to use the LightSpeed to read and write (update only, without creating new rows in tables with varchar identity column) the data. |
|
|
|
|
Hi, We've added support for string keys. It is available in the next nightly build. Cheers, Andrew.
|
|
|
|
|
What a great support! Thanks a lot. |
|
|
|
