Note - smalldatetime should not be used for Concurrency field data type

Aug 1, 2013 at 5:32 PM
smalldatetime should not be used as the data type for an object's Concurrency field - if this data type is used and presumably it will only be used in Database First scenarios, concurrency will not work correctly

The symptoms of this problem are to update an object, save and then attempt to add an object to a child collection on this object. The framework will erroneously report a concurrency issue. While this is rather counter intuitive (smalldatetime has less precision than datetime), the solution is simply to change the data type to datetime