public void ExecuteStoredProcedure(IStoredProcedureNonQuery procedure, IConnectionSetting connectionSetting)
{
using (SqlConnection connection = new SqlConnection(connectionSetting.GetDataSourcePath()))
{
using (SqlCommand command = new SqlCommand(procedure.StoredProcedureName, connection))
{
command.CommandType = CommandType.StoredProcedure;
foreach (var parameter in procedure.Parameters)
{
command.Parameters.AddWithValue(parameter.Key, parameter.Value);
}
connection.Open();
command.ExecuteNonQuery();
}
}
}
public void PostSqlNonQuery(IStoredProcedureNonQuery storedProcedure, IConnectionSetting connectionSetting)
{
new SqlExecutor().ExecuteStoredProcedure(storedProcedure, connectionSetting);
}
