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); }