Linq 學習1

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml.Linq;
using System.Collections.Generic;
namespace WebApplication3
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack)
            {
                Linq1();
                Linq2();
            }

        }

        public void Linq1()
        {
            int[] numbers = { 5, 4, 1, 3, 9, 8, 6, 7, 2, 0 };

            var lowNums =
                from n in numbers
                where n < 5
                select n + 1;

            Console.WriteLine("Numbers < 5:");
            foreach (var x in lowNums)
            {
                this.Response.Write(x);
            }
        }

        public void Linq2()
        {
            IEnumerable<Product> products = GetProductList();

            var soldOutProducts =
                from p in products
                where p.UserID>=2
                select p;

            foreach (var product in soldOutProducts)
            {
                this.Response.Write(product.UserName);
            }

        }

        private List<Product> productList;

        public List<Product> GetProductList()
        {
            if (productList == null)
                createLists();

            return productList;
        }
        private void createLists()
        {
            // Product data created in-memory using collection initializer:
            productList =
                new List<Product> {
                    new Product { UserID =1, UserName="blueidea1" , UserPass="admin"},
                     new Product { UserID =2, UserName="blueidea2" , UserPass="admin"},
                   new Product { UserID =3, UserName="blueidea3" , UserPass="admin"},
                   new Product { UserID =4, UserName="blueidea4" , UserPass="admin"},
                   new Product { UserID =5, UserName="blueidea5" , UserPass="admin"}
    
                };
        }

    }