public AnyStatement(Identifier identifier, Sequence<Expression> expressions) {
using (StringWriter stringWriter = new StringWriter()) {
SqlWriter statementWriter = new SqlWriter(stringWriter, DatabaseEngine.Unknown);
statementWriter.WriteIdentifier(identifier.Value);
statementWriter.WriteScriptSequence(expressions, WhitespacePadding.SpaceBefore, null);
statementText = stringWriter.ToString();
}
}
public override void WriteTo(SqlWriter writer) {
writer.WriteIdentifier("CONVERT");
writer.Write('(');
writer.WriteScript(typeName, WhitespacePadding.None);
writer.Write(", ");
writer.WriteScript(valueExpression, WhitespacePadding.None);
writer.WriteScript(style, WhitespacePadding.None, w => w.Write(", "), null);
writer.Write(')');
}
public void WriteIdentifier_WritesIdentifier()
{
var builder = new StringBuilder();
using (var writer = new SqlWriter(builder))
{
writer.WriteIdentifier("Blog.dbo.User");
}
Assert.Equal("[Blog].[dbo].[User]", builder.ToString());
}
public void WriteIdentifier_WithNullIdentifier_ThrowsArgumentNull()
{
Assert.Throws <ArgumentNullException>(() =>
{
var builder = new StringBuilder();
using (var writer = new SqlWriter(builder))
{
writer.WriteIdentifier(null);
}
});
}
public override void Visit(SqlSubquery expression)
{
// TODO: This is weird and should actually be handled in SqlSubquery.Accept().
_writer.WriteOpenParenthesis();
expression.Query.Accept(this);
_writer.WriteCloseParenthesis();
if (expression.Alias != null)
{
_writer.WriteIdentifier(expression.Alias);
}
}
public override void WriteTo(SqlWriter writer) {
writer.WriteIdentifier(Key);
writer.Write(' ');
objectName.WriteTo(writer);
}
public override void WriteTo(SqlWriter writer) {
writer.WriteIdentifier(original);
}
public void WriteIdentifier_WritesIdentifier()
{
var builder = new StringBuilder();
using (var writer = new SqlWriter(builder))
{
writer.WriteIdentifier("Blog.dbo.User");
}
Assert.Equal("[Blog].[dbo].[User]", builder.ToString());
}
public void WriteIdentifier_WithNullIdentifier_ThrowsArgumentNull()
{
Assert.Throws<ArgumentNullException>(() =>
{
var builder = new StringBuilder();
using (var writer = new SqlWriter(builder))
{
writer.WriteIdentifier(null);
}
});
}
