public ActionResult Index() { using (var context = new NwindDbContext()) { Category beveragesCategory = context.Categories .Where(c => c.CategoryName == "Beverages") .Single(); return(View(beveragesCategory.Products.ToList())); } }
private void Form1_Load(object sender, EventArgs e) { chart.CustomDrawSeriesPoint += OnCustomDrawSeriesPoint; chart.BoundDataChanged += OnBoundDataChanged; chart.ObjectHotTracked += OnObjectHotTracked; using (var context = new NwindDbContext()) { chart.DataSource = PrepareDataSource(context.Orders); InitPhotoCache(context.Employees); } chart.SeriesDataMember = "Year"; chart.SeriesTemplate.ArgumentDataMember = "Employee"; chart.SeriesTemplate.ValueDataMembers.AddRange("Value"); chart.SeriesTemplate.ToolTipPointPattern = "{S}: {A} ({VP:P})"; chart.SeriesTemplate.SeriesPointsSorting = SortingMode.Ascending; }
private void Form1_Load(object sender, EventArgs e) { using (var context = new NwindDbContext()) { InitPhotoCache(context.Employees); chart.DataSource = context.Orders.ToList(); } chart.SeriesDataMember = "Employee.FullName"; chart.SeriesTemplate.ArgumentDataMember = "OrderDate"; chart.SeriesTemplate.ValueDataMembers.AddRange("Freight"); XYDiagram diagram = chart.Diagram as XYDiagram; if (diagram != null) { diagram.AxisX.DateTimeScaleOptions.AggregateFunction = AggregateFunction.Sum; diagram.AxisX.DateTimeScaleOptions.MeasureUnit = DateTimeMeasureUnit.Year; } chart.CustomDrawCrosshair += OnCustomDrawCrosshair; }