how execute scalar works in c# code example
Example: executescalar in sql server
DECLARE @IsDuplicate BIT
IF EXISTS(SELECT * FROM dbo.ListData WHERE [description] = @description AND [dataTypeId] = @dataTypeId) -- Checking if duplicate name
SET @IsDuplicate = 1
ELSE
BEGIN
END