private void SAMPLEProcessKBSearch(HttpContext context, int parentID, int userID) { string term = context.Request.QueryString["q"]; //Sample code to show you how to easily get SQL to JSON SqlCommand command = new SqlCommand(); command.CommandText = "SELECT Name, TicketNumber, TicketID FROM Tickets WHERE TicketID = @TicketID"; command.Parameters.AddWithValue("TicketID", 1637556); ExpandoObject[] tickets = SqlExecutor.GetExpandoObject(LoginUser.Anonymous, command); command = new SqlCommand(); command.CommandText = "SELECT Description FROM Actions WHERE TicketID = @TicketID"; command.Parameters.AddWithValue("TicketID", 1637556); ExpandoObject[] actions = SqlExecutor.GetExpandoObject(LoginUser.Anonymous, command); (tickets[0] as dynamic).Actions = actions; dynamic result = new ExpandoObject(); result.Term = term; result.UserID = userID; result.ParentID = parentID; result.Tickets = tickets; WriteJson(context, result); }