7.9 - CheckConcurrencyViolation.sql 352 Bytes
Newer Older
O'Reilly Media, Inc.'s avatar
O'Reilly Media, Inc. committed
1 2 3 4 5 6 7 8 9 10 11 12
USE AdoDotNet35Cookbook
GO

CREATE TABLE ConcurrencyViolation(
	Id int NOT NULL PRIMARY KEY,
	Field1 nvarchar(50) NULL,
	Version timestamp NOT NULL)
GO

INSERT INTO ConcurrencyViolation VALUES (1, 'Field1.1', null);
INSERT INTO ConcurrencyViolation VALUES (2, 'Field1.2', null);
INSERT INTO ConcurrencyViolation VALUES (3, 'Field1.3', null);