public virtual string Case(Case @case, SqlOptions sql)
{
var c = $"CASE WHEN {@case.Condition.ToString(sql)} THEN {sql.CreateItemID(@case.Result)} ";
foreach (var when in @case.Whens)
{
c += $"WHEN {when.Condition.ToString(sql)} THEN {sql.CreateItemID(when.Result)} ";
}
if (@case.ElseResult != null)
{
c += $"ELSE {sql.CreateItemID(@case.ElseResult)} ";
}
return(c + "END");
}
public virtual string Column(Column column, SqlOptions sql)
{
var line = $"{sql.IdentifieName(column.Name)} ";
line += sql.CSharpTypeToSqlDataType(column.DataType, column.Size, column.Digits);
line += column.NotNull ? " NOT NULL" : "";
if (column.AutoIncrement)
{
line += " AUTO_INCREMENT";
}
else if (column.DefaultValue != null)
{
line += $" DEFAULT {sql.CreateItemID(column.DefaultValue)}";
}
return(line);
}
/// <summary>
/// Returns the <see cref="Value"/> as a string.
/// </summary>
public override string ToString(SqlOptions sql)
{
return(sql.CreateItemID(Object));
}
