public override string ToString(Dialects.SqlDialect dialect, int paramIndex)
{
if (dialect == null)
{
throw new ArgumentNullException("dialect");
}
var sb = new StringBuilder();
sb.Append(dialect.FormatFieldName(FieldName));
sb.Append((_isNull) ? " IS NULL" : " IS NOT NULL");
return(sb.ToString());
}
public override string ToString(Dialects.SqlDialect dialect, int paramIndex)
{
if (dialect == null)
{
throw new ArgumentNullException("dialect");
}
var sb = new StringBuilder();
sb.Append(dialect.FormatFieldName(FieldName));
sb.Append(' ');
sb.Append(_operator);
sb.Append(' ');
sb.Append(dialect.FormatParameterName(paramIndex, CommandType.Text));
return(sb.ToString());
}
/// <summary>
/// Adds to command.
/// </summary>
/// <param name="command">The command.</param>
/// <param name="dialect">The dialect.</param>
public void AddToCommand(DbCommand command, Dialects.SqlDialect dialect)
{
if (command == null)
{
throw new ArgumentNullException("command");
}
if (dialect == null)
{
throw new ArgumentNullException("dialect");
}
_nativeParam = command.CreateParameter();
if ((_parameterName != null) || (dialect.UseNamedParameters) || (command.CommandType == CommandType.StoredProcedure))
{
_nativeParam.ParameterName = dialect.FormatParameterName(_parameterName, command.CommandType);
}
_nativeParam.Direction = _direction;
if (_dbType != DbType.Object)
{
if ((_nativeParam is SqlParameter) && (_dbType == DbType.Time)) // hack M$ issue
{
((SqlParameter)_nativeParam).SqlDbType = SqlDbType.Time;
}
else
{
_nativeParam.DbType = _dbType;
}
}
if (_size != 0)
{
_nativeParam.Size = _size;
}
_nativeParam.SourceColumn = _sourceColumn;
_nativeParam.Value = (_value ?? DBNull.Value);
command.Parameters.Add(_nativeParam);
}
/// <summary> /// Formats the SqlFilter as a string. /// </summary> /// <param name="dialect">The SQL dialect.</param> /// <param name="paramIndex">Index of the param.</param> /// <returns>A string representation of the SqlFilter</returns> public abstract string ToString(Dialects.SqlDialect dialect, int paramIndex);
