public void Update(ReviewEM model) { using (IDbConnection db = new SqlConnection(connectionString)) { db.Query(SP_UPDATE_REVIEW, model, null, true, null, CommandType.StoredProcedure); } }
public ReviewEM Create(ReviewEM model) { using (IDbConnection db = new SqlConnection(connectionString)) { DynamicParameters sqlParams = new DynamicParameters(); sqlParams.Add("@Name", model.Name, DbType.String); sqlParams.Add("@DateOfBirth", model.DateOfBirth, DbType.Date); sqlParams.Add("@Message", model.Message, DbType.String); model.Id = db.Query <int>(SP_Create_REVIEW, sqlParams, null, true, null, CommandType.StoredProcedure).FirstOrDefault(); } return(model); }