public override bool TryCompile(QxType targetType, QxCompilationContext ctx, out string resultSql, out QxNullity resultNullity)
{
switch (targetType)
{
case QxType.Date:
if (DateTime.TryParse(Value, out DateTime d))
{
d = d.Date; // Remove the time component
string varDef = $"N'{d:yyyy-MM-dd}'";
string varName = ctx.Variables.AddVariable("DATE", varDef);
resultSql = $"@{varName}";
resultNullity = QxNullity.NotNull;
return(true);
}
else
{
resultSql = null;
resultNullity = default;
return(false);
}
case QxType.DateTime:
if (DateTime.TryParse(Value, out DateTime dt))
{
string varDef = $"N'{dt:yyyy-MM-ddTHH:mm:ss.ff}'";
string varName = ctx.Variables.AddVariable("DATETIME2(2)", varDef);
resultSql = $"@{varName}";
resultNullity = QxNullity.NotNull;
return(true);
}
else
{
resultSql = null;
resultNullity = default;
return(false);
}
case QxType.DateTimeOffset:
if (DateTimeOffset.TryParse(Value, out DateTimeOffset dto))
{
string varDef = $"N'{dto:o}'";
string varName = ctx.Variables.AddVariable("DATETIMEOFFSET(7)", varDef);
resultSql = $"@{varName}";
resultNullity = QxNullity.NotNull;
return(true);
}
else
{
resultSql = null;
resultNullity = default;
return(false);
}
}
return(base.TryCompile(targetType, ctx, out resultSql, out resultNullity));
}
public override bool TryCompile(QxType targetType, QxCompilationContext ctx, out string resultSql, out QxNullity resultNullity)
{
string nameLower = Name?.ToLower();
switch (nameLower)
{
case "min":
case "max":
{
var(arg1, conditionSql) = AggregationParameters(ctx);
if (arg1.TryCompile(targetType, ctx, out string expSql, out resultNullity))
{
resultSql = AggregationCompile(expSql, conditionSql);
return(true);
}
public override bool TryCompile(QxType targetType, QxCompilationContext ctx, out string resultSql, out QxNullity resultNullity)
{
// This here is merely an optimization
if (Operator == "+")
{
if ((targetType == QxType.String && // String concatenation
Left.TryCompile(QxType.String, ctx, out string leftSql, out QxNullity leftNullity) &&
Right.TryCompile(QxType.String, ctx, out string rightSql, out QxNullity rightNullity)) ||
(targetType == QxType.Numeric && // Numeric
Left.TryCompile(QxType.Numeric, ctx, out leftSql, out leftNullity) &&
Right.TryCompile(QxType.Numeric, ctx, out rightSql, out rightNullity)))
{
resultNullity = leftNullity | rightNullity;
resultSql = $"({leftSql} + {rightSql})";
return(true);
}
else
{
// No other types are possible for +
resultNullity = default;
resultSql = null;
return(false);
}
}