Pa to je to, ugl Dapper sluzi svrsi, evo kako izgleda otprilike zvanje neke procedure:
Code:
public static void Create(User user)
{
string storedProcedure = "usp_UserCreate";
using (SqlConnection db = new SqlConnection(WebCMS.Helpers.Core.SqlConString()))
{
DynamicParameters parms = new DynamicParameters();
parms.Add("@Username", user.Username);
parms.Add("@Password", user.Password);
parms.Add("@Email", user.Email);
parms.Add("@FirstName", user.FirstName);
parms.Add("LastName", user.LastName);
db.Query(storedProcedure, parms, commandType: CommandType.StoredProcedure);
}
Imam neki problem sa uzimanjem Connection stringa iz json config fajla, mrsko mi se bahcat sad sa tim.. :D