Can we use an "Id" with a data type other than String? #426
-
|
The PK on most of my (SQL Server) tables is of type "int", and some are "bigint" due to the expected number of rows. |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
No. int types (and, by extension, bigint) are not suitable because they are not globally unique. You also don't get an auto-increment capability in the mobile world. One thing you CAN do is to have a GUID Id and an int PkId that is not exposed to the user. The PkId is int/auto-increment on first store; the Id is generated when not provided. |
Beta Was this translation helpful? Give feedback.
-
|
@MartinRobins what I do is that, my entities saved in the DB on the server have an Id to be whatever I want, be it GUID or ULID, and another property, SyncId, which is the mapped property of the Id from the DTO on the client side. This permits me to do filtering, ordering or whatever I want server side with it. I have my custom repositories and acces control providers and this facilitates it. If you need further assistance, let me know. |
Beta Was this translation helpful? Give feedback.
No.
int types (and, by extension, bigint) are not suitable because they are not globally unique. You also don't get an auto-increment capability in the mobile world.
One thing you CAN do is to have a GUID Id and an int PkId that is not exposed to the user. The PkId is int/auto-increment on first store; the Id is generated when not provided.