public static int ExecuteNonQuery(string procedureName, params object[] parameters)
{
if (parameters == null || parameters.Length == 0 || parameters.Length % 2 != 0)
{
return(-1);
}
var keys = parameters.Where((p, i) => i % 2 == 0).ToArray();
var values = parameters.Where((p, i) => i % 2 != 0).ToArray();
if (keys.Length != values.Length)
{
return(-1);
}
return(SqlHelperBase.ExecuteNonQuery(procedureName, keys.Select((t, i) => new SqlParameter(t.ToString(), values[i])).ToArray()));
}
public static int ExecuteNonQueryNoParam(string procedureName)
{
return(SqlHelperBase.ExecuteNonQuery(procedureName));
}
