BUG: edit button is not available for a table consisting of a single identity field
There is a bug in grid editing feature. The edit button is not available for a table consisting of a single identity field only (PK), as for instance:
CREATE TABLE Table1 (
[Id] INT NOT NULL IDENTITY,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
In this case, there is nothing to EDIT in the table indeed, but the ability to ADD and DELETE records is still needed. And BTW, LINQ2SQL performs inserts just fine by issuing “INSERT INTO [Table1] DEFAULT VALUES”
CREATE TABLE Table1 (
[Id] INT NOT NULL IDENTITY,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
In this case, there is nothing to EDIT in the table indeed, but the ability to ADD and DELETE records is still needed. And BTW, LINQ2SQL performs inserts just fine by issuing “INSERT INTO [Table1] DEFAULT VALUES”