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 }; }