Calling stored procedures with parameters in PetaPoco
Update:
I tried the following for fetch and insert and it worked perfectly:
var s = PetaPoco.Sql.Builder.Append("EXEC SP_FindCust @@last_name = @0", lname);
s.Append(", @@first_name = @0", fName);
s.Append(", @@last_name = @0", lName);
s.Append(", @@dob = @0", dob);
return db.Query<Cust>(s);
This can be improved further to pass SQL parameters.
As of v6.0.344-beta, PetaPoco now supports stored procedures without needing to use EXEC
. See https://github.com/CollaboratingPlatypus/PetaPoco/wiki/Stored-procedures