public void SetSqlCmdParam(SqlConnection ignored, SqlCommand dbCommand, CriterionNVT q)
{
if (string.IsNullOrEmpty(q.TypeName))
{
dbCommand.Parameters.AddWithValue(q.Name, q.Value ?? DBNull.Value);
}
else
{
var param = dbCommand.Parameters.Add(new SqlParameter(q.Name, q.Value));
param.Value = q.Value ?? DBNull.Value;
param.TypeName = q.TypeName;
}
}
public void SetSqlCmdParam(NpgsqlConnection db, NpgsqlCommand dbCommand, CriterionNVT q)
{
var parameter = dbCommand.CreateParameter();
parameter.Direction = ParameterDirection.Input;
parameter.DbType = q.Type;
parameter.ParameterName = q.Name;
if (q.Type == DbType.String && q.Value != null)
{
var value = q.Value as string;
value = value.Replace("\0", string.Empty);
parameter.Value = value;
}
else
{
parameter.Value = q.Value ?? DBNull.Value;
}
dbCommand.Parameters.Add(parameter);
}
public void SetSqlCmdParam(Database db, DbCommand dbCommand, CriterionNVT q)
{
db.AddInParameter(dbCommand, q.Name, q.Type, q.Value ?? DBNull.Value);
}
