C# (CSharp) FilterCriteriaSample NwindDbContext Exemples

Exemple #1

Fichier : Form1.cs Projet : DevExpress-Examples/how-to-filter-a-chart-using-the-filtering-ui-context-t566197

 public Form1()
 {
     InitializeComponent();
     using (NwindDbContext context = new NwindDbContext()) {
         Products        = context.Products.ToList();
         FilterViewModel = new FilterViewModel(context);
     }
 }

Exemple #2

        public FilterViewModel(NwindDbContext context)
        {
            Categories = context.Categories.ToList();

            UnitPriceMinValue = context.Products.Min(p => p.UnitPrice).Value;
            UnitPriceMaxValue = context.Products.Max(p => p.UnitPrice).Value;

            UnitsInStockMinValue = context.Products.Min(p => p.UnitsInStock).Value;
            UnitsInStockMaxValue = context.Products.Max(p => p.UnitsInStock).Value;

            UnitsOnOrderMinValue = context.Products.Min(p => p.UnitsOnOrder).Value;
            UnitsOnOrderMaxValue = context.Products.Max(p => p.UnitsOnOrder).Value;
        }