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