private IDataCommand BuildDelete(QueryTemplate template)
{
var builder = new StringBuilder();
var cmd = new StormCommand(_provider);
_parameterCount = 0;
GenerateDelete(builder, template);
GenerateCriteria(builder, template, cmd);
cmd.CommandText = builder.ToString();
return cmd;
}
private IDataCommand BuildInsert(QueryTemplate template)
{
var builder = new StringBuilder();
var cmd = new StormCommand(_provider);
_parameterCount = 0;
GenerateInsert(builder, template);
GenerateInsertValues(builder, template, cmd);
if (template.SelectIdentity)
{
builder.Append(";");
GenerateSelectIdentity(builder);
}
cmd.CommandText = builder.ToString();
return cmd;
}
private IDataCommand BuildStandardSelect(QueryTemplate template)
{
var builder = new StringBuilder();
var cmd = new StormCommand(_provider);
_parameterCount = 0;
GenerateSelect(builder, template);
GenerateFrom(builder, template);
GenerateJoins(builder, template);
GenerateCriteria(builder, template, cmd);
GenerateOrderBy(builder, template);
cmd.CommandText = builder.ToString();
return cmd;
}
