Razor

                                
                                        
DbNetGridCore productSalesSummaryGrid = new DbNetGridCore("northwind", "Invoices join Products on Products.ProductID = Invoices.ProductId", "salesGrid");
productSalesSummaryGrid.Columns = new List() { "CategoryID", "(Invoices.UnitPrice * Invoices.Quantity) as TotalValue" };
productSalesSummaryGrid.Labels = new List() { "Category", "Total Value" };
productSalesSummaryGrid.GroupBy = true;
productSalesSummaryGrid.ToolbarPosition = ToolbarPosition.Hidden;
productSalesSummaryGrid.Column("TotalValue").Format("c").DataType(typeof(Decimal)).Aggregate(AggregateType.Sum);
productSalesSummaryGrid.Column("CategoryID").Lookup(new Lookup("Categories", "CategoryId", "CategoryName"));
productSalesSummaryGrid.GoogleChartOptions = new GoogleChartOptions() { Type = GoogleChartType.PieChart, PanelId = "piechart", FunctionName = "chartOptions" };
@productSalesSummaryGrid.Render()