EntityFramework数据持久化 第二章 Linq查询（C#代码实现）

Program类里面的代码，实现条件筛选、条件排序。封装UserInfo类，进行调用。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Demo01
{
    public class UserInfo
    {
        //编号、姓名、年龄、地址、电话、Email  (快捷键prop)
        public int UserId { get; set; }     
        public string UserName { get; set; }
        public int UserAge { get; set; }
        public string UserSex { get; set; }
        public string Address { get; set; }
        public string Phone { get; set; }
        public string Email { get; set; }

        public override string ToString()
        {
            return $"用户编号:{UserId}，用户姓名：{UserName}，性别：{UserSex}，年龄：{UserAge}，地址：{Address}，联系电话：{Phone}，邮箱：{Email}";
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Demo01
{
    class Program
    {
        private static List<UserInfo> userInfos;
        private static List<StuScore> stuScores;
        static void Main(string[] args)
        {
            InitData();
            Exe01();
            Exe02();
            Console.ReadKey();
        }


        private static void Exe01()
        {
            //按条件筛选
            var users = from user in userInfos where user.UserSex == "女" select user;
            foreach (var item in users)
            {
                Console.WriteLine(item.ToString());
            }
            Console.WriteLine("-----------------------------------------------");
            //按条件排序
            var users1 = from user in userInfos orderby user.UserAge descending select user;
            foreach (var item in users1)
            {
                Console.WriteLine(item.ToString());
            }
        }
               
        private static void Exe02()
        {
            //var users = from user in userInfos where user.UserAge > 20 select user;
            //延迟加载
            var users = userInfos.Where(user => user.UserAge >= 20).ToList();
            foreach (var item in users)
            {
                Console.WriteLine(item.ToString());
            }
        }
        /// <summary>
        /// 初始化集合数据
        /// </summary>
        private static void InitData()
        {
            userInfos = new List<UserInfo>()
            {
                new UserInfo()
                {
                    UserId  =1,
                    UserName = "张三三",
                    UserAge = 20,
                    Address = "ASFsfdsdkfjlsk",
                    UserSex = "男",
                    Phone = "12324325443",
                    Email = "123@123.123"
                },
                new UserInfo()
                {
                    UserId  =2,
                    UserName = "张三丰",
                    UserAge = 120,
                    Address = "武当山",
                    UserSex = "男",
                    Phone = "12324325443",
                    Email = "123@123.123"
                },
                new UserInfo()
                {
                    UserId  =3,
                    UserName = "张翠山",
                    UserAge = 40,
                    Address = "武当山",
                    UserSex = "男",
                    Phone = "12324325443",
                    Email = "123@123.123"
                },
            };
        }
    }
}

Program类里面的代码，实现Select进行投影操作。封装StuScore类，进行调用。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Demo01
{
    public class StuScore
    {
        //姓名、文科、数学、语文、英语、综合  (快捷键prop)
        public string Name { get; set; }
        public bool IsWen { get; set; }
        public double Shuxu { get; set; }
        public double Yuwen { get; set; }
        public double Yingyu { get; set; }
        public double Zonghe { get; set; }

        public override string ToString()
        {
            return $"姓名:{Name},是否文科:{IsWen},数学:{Shuxu},语文:{Yuwen},英语:{Yingyu},综合:{Zonghe}";
        }
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Demo01
{
    class Program
    {
        private static List<UserInfo> userInfos;
        private static List<StuScore> stuScores;
        static void Main(string[] args)
        {
            InitScore();
            Exe03();
            Console.ReadKey();
        }
        
        private static void Exe03()
        {
            //使用select进行投影操作 将查询出的数据赋值到新的类
            var data = stuScores.Where(s => s.IsWen).Select(s => new { s.Name, Sum = s.Shuxu + s.Yuwen + s.Yingyu + s.Zonghe }).ToList();
            foreach (var item in data)
            {
                Console.WriteLine(item);
            }
            //通过Average进行求平均值
            Console.WriteLine("平均成绩:" + data.Average(s => s.Sum));
        }
        
        private static void InitScore()
        {
            stuScores = new List<StuScore>()
            {
                new StuScore()
                {
                    Name = "张三",
                    IsWen = true,
                    Shuxu = 49,
                    Yuwen = 121,
                    Yingyu = 110,
                    Zonghe = 180
                },
                new StuScore()
                {
                    Name = "李四",
                    IsWen = false,
                    Shuxu = 149,
                    Yuwen = 91,
                    Yingyu = 100,
                    Zonghe = 210
                },
            };
        }
    }
}

小剧场：负重一万斤长大。Grow up with a load of ten thousand jin.