search

abe545 / CodeOnlyStoredProcedures

A library for easily calling Stored Procedures in .NET using only code (no xml or gui).
MIT License
4 stars 3 forks source link

Execute mysql stored proc with parameters #100

Closed Rajiv-Kulkarni closed 6 years ago

Rajiv-Kulkarni commented 6 years ago

How can I do something like this:

strQuery = new StringBuilder("CALL " + lstMetrics[counter] + "(?ScheduleID, ?EmployeeID,?OBS,?Details)");

MySqlParameter[] parameters = new MySqlParameter[] { new MySqlParameter("ScheduleID", scheduleID), new MySqlParameter("EmployeeID", null), new MySqlParameter("OBS", null), new MySqlParameter("Details",0) };

int nReturn = _isatDb.Database.ExecuteSqlCommand(strQuery.ToString(), parameters);

where the stored proc name is dynamically retrieved. Thanks.

Rajiv-Kulkarni commented 6 years ago

Works for me now: StoredProcedure.SetObjectQuoteStyle(ObjectQuoteStyle.BackTick); StoredProcedure.Create("isat", lstMetrics[counter]) .WithParameter("ScheduleID", scheduleID) .WithParameter("EmployeeID", DBNull.Value) .WithParameter("OBS", DBNull.Value) .WithParameter("Details", 0) .Execute(db); Thanks.