private void TestCastToString(Int32?x, String expectedValue)
{
_Int32 column1 = x;
_String expr = (_String)column1;
var dbExpr = (DbCastExpression)expr.DbExpression;
dbExpr.Verify(column1, typeof(Int32?), typeof(String));
expr.VerifyEval(expectedValue);
}
private void TestStringColumnCast(String x, Boolean?expectedValue)
{
_String column1 = _String.Const(x);
_Boolean expr = (_Boolean)column1;
var dbExpr = (DbCastExpression)expr.DbExpression;
dbExpr.Verify(column1, typeof(String), typeof(Boolean?));
expr.VerifyEval(expectedValue);
}
private void TestFromString(String x, Int32?expectedValue)
{
_String column1 = x;
_Int32 expr = (_Int32)column1;
var dbExpr = (DbCastExpression)expr.DbExpression;
dbExpr.Verify(column1, typeof(String), typeof(Int32?));
expr.VerifyEval(expectedValue);
}
private void TestFromString(String x, Double?expectedValue)
{
_String column1 = x;
_Double expr = (_Double)column1;
var dbExpr = (DbCastExpression)expr.DbExpression;
dbExpr.Verify(column1, typeof(String), typeof(Double?));
expr.VerifyEval(expectedValue);
}
private void TestFromString(String x, Char?expectedValue)
{
_String column1 = x;
_Char expr = (_Char)column1;
var dbExpr = (DbCastExpression)expr.DbExpression;
dbExpr.Verify(column1, typeof(String), typeof(Char?));
expr.VerifyEval(expectedValue);
}
private void TestCastToString(byte?x, String expectedValue)
{
_Byte column1 = x;
_String expr = column1.CastToString();
var dbExpr = (DbCastExpression)expr.DbExpression;
dbExpr.Verify(column1, typeof(byte?), typeof(String));
expr.VerifyEval(expectedValue);
}
private void TestLessThan(String x, String y, bool?expectedValue)
{
_String column1 = x;
_String column2 = y;
var expr = column1 < column2;
var dbExpr = (DbBinaryExpression)expr.DbExpression;
dbExpr.Verify(BinaryExpressionKind.LessThan, column1, column2);
expr.VerifyEval(expectedValue);
}
private void TestAdd(String x, String y, String expectedValue)
{
_String column1 = x;
_String column2 = y;
var expr = column1 + column2;
var dbExpr = (DbBinaryExpression)expr.DbExpression;
dbExpr.Verify(BinaryExpressionKind.Add, column1, column2);
expr.VerifyEval(expectedValue);
}
private void TestGreaterThanOrEqual(String x, String y, bool?expectedValue)
{
_String column1 = x;
_String column2 = y;
var expr = column1 >= column2;
var dbExpr = (DbBinaryExpression)expr.DbExpression;
dbExpr.Verify(BinaryExpressionKind.GreaterThanOrEqual, column1, column2);
expr.VerifyEval(expectedValue);
}
/// <summary>Creates a column of parameter expression.</summary>
/// <param name="x">The value of the parameter expression.</param>
/// <param name="sourceColumn">The value which will be passed to <see cref="DbParamExpression.SourceColumn"/>.</param>
/// <returns>The column of parameter expression.</returns>
public static _String Param(String x, _String sourceColumn = null)
{
return(new ParamExpression <String>(x, sourceColumn).MakeColumn <_String>());
}
public ContainsFunction(_String column, _String value)
: base(column, value)
{
_column = column;
_value = value;
}
/// <summary>
/// Determines whether column contains specified value.
/// </summary>
/// <param name="x">The column.</param>
/// <param name="value">The specified value.</param>
/// <returns>A <see cref="_Boolean"/> column which contains the result.</returns>
public static _Boolean Contains(this _String x, _String value)
{
x.VerifyNotNull(nameof(x));
value.VerifyNotNull(nameof(value));
return(new ContainsFunction(x, value).MakeColumn <_Boolean>());
}
private void TestConst(String x)
{
_String column = _String.Const(x);
column.VerifyConst(x);
}
private void TestImplicit(String x)
{
_String column = x;
column.VerifyParam(x);
}
