i had issues with saving to sterling as well until i figured out that i have to give each new entry a new ID.
this is something i didnt expect after working with sql-server a long time ;)
so whats the recommended strategy to generate keys?
- select max row and insert new one with +1?
- generate a PrimaryKeyProvider<T> class that uses IsolatedStorage for saving the last id?
- use GUID as a key?
pls give advice and maybe integrate it in the product? :)