I do stored procedure as following
ALTER PROCEDURE [dbo].[UpdateEmployee]
@EmployeeName nvarchar(50),
@OldTimeStamp timestamp
AS
BEGIN
update Employee set
EmployeeName=@EmployeeName where
CurrentTimestamp=@OldTimeStamp
if(@@rowcount=0)
begin
raiserror('There are another one changed the record')
end
END
IF possible what the code i write in c# interface that represent stored procedure