public void OnSQLUpdated(object sender, EventArgs e)
{
var qb = QueryBuilderStore.Get("AlternateNames");
var opts = new SQLFormattingOptions();
opts.Assign(qb.SQLFormattingOptions);
opts.KeywordFormat = KeywordFormat.UpperCase;
// get SQL query with real object names
opts.UseAltNames = false;
var plainSql = FormattedSQLBuilder.GetSQL(qb.SQLQuery.QueryRoot, opts);
// get SQL query with alternate names
opts.UseAltNames = true;
var sqlWithAltNames = FormattedSQLBuilder.GetSQL(qb.SQLQuery.QueryRoot, opts);
// prepare additional data to be sent to the client
qb.ExchangeData = new
{
SQL = plainSql,
AlternateSQL = sqlWithAltNames
};
}
public void OnSQLUpdated(object sender, EventArgs e)
{
var qb = QueryBuilderStore.Get(InstanceId);
var opts = new SQLFormattingOptions();
opts.Assign(qb.SQLFormattingOptions);
opts.KeywordFormat = KeywordFormat.UpperCase;
// get query with virtual objects and fields
opts.ExpandVirtualObjects = false;
var sqlWithVirtObjects = FormattedSQLBuilder.GetSQL(qb.SQLQuery.QueryRoot, opts);
// get SQL query with real object names
opts.ExpandVirtualObjects = true;
var plainSql = FormattedSQLBuilder.GetSQL(qb.SQLQuery.QueryRoot, opts);
// prepare additional data to be sent to the client
qb.ExchangeData = new
{
SQL = plainSql,
VirtualObjectsSQL = sqlWithVirtObjects
};
}