public static Int32Expression IndexOf(this StringExpression expr, StringExpression value)
{
var newExpr = new Int32Expression("CHARINDEX(?, " + expr._sql + ") - 1", ((StringExpression)expr.Clone())._childExpressions);
newExpr.ChildExpressions.Insert(0, value);
return(newExpr);
}
public static Int32Expression IndexOf(this StringExpression expr, string value)
{
var newExpr = new Int32Expression("CHARINDEX(?, " + expr._sql + ") - 1", ((StringExpression)expr.Clone())._childExpressions);
newExpr.ChildExpressions.Insert(0, new StringParameterExpression(value, expr.IsUnicode));
return(newExpr);
}
/// <summary>
/// Index of specified substring in current string expression.
/// </summary>
/// <param name="expr">The expr.</param>
/// <param name="value">The substring value.</param>
/// <returns></returns>
public static Int32Expression IndexOf(this StringExpression expr, StringExpression value)
{
var newExpr = new Int32Expression("INSTR(" + expr.Sql + ", ?) - 1", ((StringExpression)expr.Clone()).ChildExpressions);
newExpr.ChildExpressions.Insert(0, value);
return(newExpr);
}
public static DateTimeExpression AddMonth(this DateTimeExpression expr, Int32Expression n)
{
if (n == null)
{
throw new ArgumentNullException("n");
}
var newExpr = (DateTimeExpression)expr.Clone();
newExpr._sql = "DATEADD(month, ?, " + newExpr._sql + ")";
newExpr._childExpressions.Insert(0, n);
return(newExpr);
}
public static StringExpression Right(this StringExpression expr, Int32Expression length)
{
if (ReferenceEquals(length, null))
{
throw new ArgumentNullException("length");
}
var newExpr = (StringExpression)expr.Clone();
newExpr._sql = "RIGHT(" + newExpr._sql + ", ?)";
newExpr._childExpressions.Add(length);
return(newExpr);
}
internal Int32Column(Int32Expression expr, string columnName)
: this(columnName)
{
if (ReferenceEquals(expr, null))
{
throw new ArgumentNullException("expr");
}
Sql = expr.Sql;
if (expr.ChildExpressions != null)
{
ChildExpressions.AddRange(expr.ChildExpressions);
}
}
public static StringExpression Substring(this StringExpression expr, Int32Expression begin, int length)
{
if (ReferenceEquals(begin, null))
{
throw new ArgumentNullException("begin");
}
var newExpr = (StringExpression)expr.Clone();
newExpr._sql = "SUBSTRING(" + newExpr._sql + ", ? + 1, ?)";
newExpr._childExpressions.Add(begin);
newExpr._childExpressions.Add(new Int32ParameterExpression(length));
return(newExpr);
}
/// <summary>
/// Substring of specified expr.
/// </summary>
/// <param name="expr">The expr.</param>
/// <param name="begin">The begin.</param>
/// <param name="length">The length.</param>
/// <returns></returns>
public static StringExpression Substring(this StringExpression expr, Int32Expression begin, Int32Expression length)
{
if (ReferenceEquals(begin, null))
{
throw new ArgumentNullException("begin");
}
if (ReferenceEquals(length, null))
{
throw new ArgumentNullException("length");
}
var newExpr = (StringExpression)expr.Clone();
newExpr.Sql = "SUBSTR(" + newExpr.Sql + ", ? + 1, ?)";
newExpr.ChildExpressions.Add(begin);
newExpr.ChildExpressions.Add(length);
return(newExpr);
}
internal OracleInt32Column(Int32Expression expr, string columnName)
: base(expr, columnName)
{
}
public StringExpression Substring(Int32Expression begin, Int32Expression length)
{
return(OracleExtensionMethods.Substring(this, begin, length));
}
public DateTimeExpression AddMonth(Int32Expression n)
{
return(OracleExtensionMethods.AddMonth(this, n));
}
public StringExpression Right(Int32Expression length)
{
return(SqlExtensionMethods.Right(this, length));
}
public StringExpression Substring(int begin, Int32Expression length)
{
return(SqlExtensionMethods.Substring(this, begin, length));
}
public DateTimeExpression AddSecond(Int32Expression n)
{
return(SqlExtensionMethods.AddSecond(this, n));
}
/// <summary>
/// To a char.
/// </summary>
/// <param name="expr">The expr.</param>
/// <returns></returns>
public static StringExpression ToChar(this Int32Expression expr)
{
return(new StringExpression(false, "CHR(" + expr.Sql + ")", ((Int32Expression)expr.Clone()).ChildExpressions));
}
public static StringExpression ToNChar(this Int32Expression expr)
{
return(new StringExpression(false, "NCHAR(" + expr._sql + ")", ((Int32Expression)expr.Clone())._childExpressions));
}
public Assignment Set(Int32Expression value)
{
return(new Assignment(this, ((object)value) == null ? (IExpression)NullExpression.Value : value));
}
public DateTimeExpression AddMinute(Int32Expression n)
{
return(SqlExtensionMethods.AddMinute(this, n));
}
