Simple.Data allows you to call your existing stored procedures. There are three variations on calling procedures, Parameterless, Positional and with Named Parameters.
The example procedure
CREATE PROCEDURE ProcedureWithoutParameters AS SELECT * FROM Customers
Call it in Simple.Data with
db.ProcedureWithoutParameters();
This generates the following SQL
[ProcedureWithoutParameters]
The example procedure
CREATE PROCEDURE ProcedureWithParameters @One VARCHAR(MAX), @Two VARCHAR(MAX) AS SELECT * FROM Customers WHERE Firstname = @One and Lastname like @Two
Call it in Simple.Data with
db.ProcedureWithParameters(1, 2);
This generates the following SQL
[ProcedureWithParameters] @One, @Two @One (AnsiString) = 1 @Two (AnsiString) = 2
The example procedure
CREATE PROCEDURE ProcedureWithParameters @One VARCHAR(MAX), @Two VARCHAR(MAX) AS SELECT * FROM Customers WHERE Firstname = @One and Lastname like @Two
Call it in Simple.Data with
db.ProcedureWithParameters(One: 1, Two: 2);
This generates the following SQL
[ProcedureWithParameters] @One, @Two @One (AnsiString) = 1 @Two (AnsiString) = 2