Can I use ExecuteScalar for updates?

Question

I am using SQL Server 2005 and C #. I want to get the primary key value when I insert records into the database.

For this, I have a C # method in which I insert and update records. I use the method ExecuteScalarto insert and update.

The insert was successful, but there are no updates. How can I use ExecuteScalarto get the primary key for updates?

Answer 1

, ExecuteScalar , (, SELECT). , - , ExecuteNonQuery.

ExecuteNonQuery . , :

INSERT INTO TableName(someFields) VALUES (someValues)
SET @Id = SCOPE_IDENTITY()

SET @Id = newid()
INSERT INTO (ID, someFields) VALUES (@id, someValues)

uniqueidentifier .

output @Id , ExecuteNonQuery .

Answer 2

ExecuteScalar ( /), ExecuteNonQuery , , . , ? - , ? - . (.. ), , ( ). , .