We are developing an application with .Net and SQL Server, part of the application will allow the users to enter data and later sync with the server database. We are considering using a GUID or a composite key to sync the tables.
I know the GUID has a performance hit , but I am not sure I like having to join two columns in every query using a composite key.
Does anybody have any experience with this type of application? Suggestions?