using System;

using System.Data.SqlClient;

using System.Linq;

using System.Collections.Generic;

public class Program

{

    public static void Main()

    {

        var productList = GetProductList();

        productList = productList.Where(p => p.UnitPrice >= 20).ToList();

        Console.WriteLine("|{0,2}| {1,50}|{2,10:c}|{3,12}|"

                              , "ID", "Product"

                              , "Price", "Available");

        Console.WriteLine("--------------------------------------------------------------------------------");

        foreach(Product product in productList)

        {

            Console.WriteLine("|{0,2}| {1,-50}|{2,10:c}|{3,12}|"

                              , product.ProductID, product.ProductName

                              , product.UnitPrice, product.Discontinued == false ? "YES" : "NO");

        }

        Console.WriteLine("--------------------------------------------------------------------------------");

    }

    private static List<Product> GetProductList()

    {

        var sql = "SELECT * FROM Products";

        var lst = new List<Product>();

​

        using (var conn = new SqlConnection(FiddleHelper.GetConnectionStringSqlServerNorthwind()))

        {

            conn.Open();

            var cmd = new SqlCommand();

            cmd.Connection = conn;

            cmd.CommandText = sql;

            var rd = cmd.ExecuteReader();

            while(rd.Read())

            {

                Product product = new Product()

                {

                    ProductID = Convert.ToInt32(rd["ProductID"]),

                    ProductName = Convert.ToString(rd["ProductName"]),

                    UnitPrice = Convert.ToDecimal(rd["UnitPrice"]),

                    Discontinued = Convert.ToBoolean(rd["Discontinued"])

                };

                lst.Add(product);

            }

        }

        return lst;

    }

}

​

public class Product

{

    public int ProductID { get; set; }

    public string ProductName { get; set; }

    public decimal UnitPrice { get; set; }

    public bool Discontinued { get; set; }

}