Performance of Inserts

[davidaustin]

When inserting data into our tables LinqConnect creates code which follows the following pattern

INSERT INTO dbo.table (colNames)
VALUES (@p1);
SELECT rowid FROM dbo.table WHERE rowid = SCOPE_IDENTITY();

We are concerned about the performance of the Select statement. Is there are reason it is not just doing a "Select SCOPE_IDENTITY();" ?

Our database is becoming a bottle neck in our application and we need all the performance we can out of it.

[Shalex]

Thank you for your suggestion. We will optimize the SQL generation when only one property is Auto-Sync=OnInsert and notify you about the result.

The current SQL template is used to unify the generation. For example, if there would be two or more Auto-Sync=OnInsert properties, the SQL would be the following:
SELECT rowid, Property2, Property3, ... FROM dbo.table WHERE rowid = SCOPE_IDENTITY();