using System;

using System.Linq;

using System.Collections.Generic;

public class Program

{

    public class Product

    {

        public string FA {get;set;}

        public double FB {get;set;}

    }

    public static void Main()

    {

        //1. view from the database using LINQ

        var products = new List<Product>() 

        {

            new Product()

            {

                FA = "A",

                FB = 0.2334

            },

            new Product()

            {

                FA = "B",

                FB = 1.2334

            }

        };      

        var products_queryable = products.AsQueryable();

        //2. filtering depending the filters that the front-end sends. Using reflection get the properties for the class Product

        if (true)

        products_queryable = products_queryable.Where(f => f.FB > 1);       

        if (false)

        products_queryable = products_queryable.Where(f => f.FA == "A");

        //3. The SQL query is executed at this point        

        Console.WriteLine(products_queryable.Count().ToString()); 

    }

}