System.Data.SqlClient.SqlException "LockVersion" is used multiply times.

Hi there,

another day another problem.

While inserting an entity with some new associated entities I get a exception:

System.Data.SqlClient.SqlException: Der Spaltenname 'LockVersion' wird mehrmals in der Ergebnisspaltenliste angezeigt.

"The column LockVersion is used multiply times within the result columns".

SQL Trace:

INSERT INTO Customer
(
  Customer_Id,
  LockVersion,
  Customer_Name
)
VALUES
(
  4,
  0,
  'Fred Feuerstein'
);

INSERT INTO Users
(
  User_Id,
  User_Customer_Id,
  User_EMail,
  User_IsDisabled,
  User_IsSuperUser,
  LockVersion,
  User_LoginName,
  User_Name,
  User_Password
)
VALUES
(
  3,
  4,
  'soernt.poppe@mcetools.de',
  False,
  True,
  0,
  'spoppe',
  'Sörnt Poppe',
  'fred'
);

INSERT INTO Backlog
(
  Backlog_Id,
  LockVersion
)
VALUES
(
  1,
  0
);

INSERT INTO BaseProject
(
  Project_ID,
  Backlog_Project_Id,
  Project_Description,
  LockVersion,
  Project_Name,
  ProjectStatusIsClosed,
  ProjectStatusIsPublic,
  Project_Type,
  CustomerId,
  LockVersion
)
VALUES
(
  2,
  1,
  'Kleine Beschreibung am Rande...',
  0,
  'Test Project',
  False,
  True,
  1,
  4,
  0
);

INSERT INTO UserProjectRole
(
  UserProjectRole_Id,
  LockVersion,
  UserProjectRole_Project_Id,
  UserProjectRole_Role_Id,
  UserProjectRole_User_Id
)
VALUES
(
  5,
  0,
  2,
  400,
  3
)

--> Time:   0 ms

The select statement, which causes the exception, is not displayed.

Kind regards,

Sörnt

Looks like BaseProject has two LockVersions.  This could occur if you are using single table inheritance and have defined LockVersion fields (or, in the designer, set Optimistic Concurrency Checking) on both the base and derived classes.  Remove the LockVersion field (or set Optimistic Concurrency Checking to false) on the derived class and you should be good to go (the derived class will still get checked because the setting gets inherited from the base class).

Hello Ivan,

I now set the LockVersion only at the base class and it is working.

LigthSpeed is really an impressive product and the support is excellent!
I really enjoy how fast things gets sorted out.

Kudos to the LightSpeed team!

Sörnt