Procedure deleterecord has no parameters and arguments were supplied

Question

I wrote a stored procedure for delete record in SQL server database But I Can not send parameters with stored procedures. This is my stored procedure:

ALTER PROCEDURE [dbo].[DeleteRecord]
AS
    DECLARE @id INT

    DELETE FROM Student1 WHERE id = @id

This is my C# code calling this stored procedure:

var db = new PetaPoco.Database("test");
    db.Fetch<Models.Generated.test.Student1>("; EXEC [dbo].[DeleteRecord] @@Id = @0", Id);

Answer 1

your proc definition is not correct, you are not passing any parameter to your function , that variable inside proc never gets any value (It's always null since no value has been assigned to it)

CREATE OR ALTER Procedure [dbo].[DeleteRecord]
( 
    @id INT
) 
AS 
Delete from Student1 where id=@id