Two ways to get JSON from DB
If you want to get the results and pull to JSON.
@*----------------WAY 1 USING THE ADAPTER ---------------------------*@ @using System.IO @functions { protected string Generate() { var adapter = EngineAdapter.Create("Contacts", "People"); adapter.AddResultFields(new[] {"FirstName", "LastName", "PartOfOrganization.Name"}); adapter.AddSearch("Brunton"); MemoryStream ms = new MemoryStream(); adapter.Export(ms, new EngineCore.Data.ExportFormats.Json(), ExportOptions.None); ms.Seek(0, SeekOrigin.Begin); using (StreamReader sr = new StreamReader(ms)) { return sr.ReadToEnd(); }; } } <span>@Generate()</span> @*----------------WAY 2 USING A LISTER ---------------------------*@ @using System; @using System.Text; @{ string whereFilter = DateTime.Now.Year.ToString(); //if no filter, default to this year StringBuilder sb = new StringBuilder(); } @if(!String.IsNullOrEmpty(Request.QueryString["filter"])){ whereFilter = Request.QueryString["filter"]; } @BRT.Lister(tableId: "Content", viewId: "RemitFunds", condition: "<And><Eq FieldId=\"FundActive\" Value=\"false\"/><Or><IsNull FieldId=\"StartDate\"/><Range FieldId=\"StartDate\" StartValue=\"1/1/" + whereFilter + " 12:00:00 AM\" EndValue=\"12/31/" + whereFilter + " 12:00:00 AM\"/></Or><Or><IsNull FieldId=\"EndDate\"/><Range FieldId=\"EndDate\" StartValue=\"1/1/" + whereFilter + " 12:00:00 AM\" EndValue=\"12/31/" + whereFilter + " 12:00:00 AM\"/></Or></And>", sortFields: new SortFieldMeta[] {new SortFieldMeta() {FieldId = "Title"}}, fields: new[] {"Title","Summary"}, pageSize: 500, template: @<div> @{sb.Append("["); StringBuilder DisplayName = new StringBuilder(); foreach(EngineRecord record in item) { if(!record.IsDBNull("Title")) { sb.Append("{ \"id\":" + record.Id.ToString() + ", \"name\": \"" + record["Title"].ToString() + " " + record["Summary"].ToString() + " \"},"); } } sb.Length--; // remove trailing comma sb.Append("]"); } @BRT.Raw(sb.ToString()) </div>)