在efcore Demo.App中添加查询数据的代码 学习笔记4

在program.cs添加代码

using System;
using Demo.Data;
using Demo.Domain;

namespace Demo.App
{
    class Program
    {
        static void Main(string[] args)
        {
            using var context = new DemoContext();

            var serieA=context.Leagues.Single(x=>x.Name=="Serie A");

            var serieB = new League
            {
                Country = "Italy",
                Name = "Serie B"
            };
            var serieC = new League
            {
                Country = "Italy",
                Name = "Serie C"
            };

            var milan = new Club
            {
                Name = "AC Milan",
                City = "Milan",
                DateOfEstablishment = new DateTime(1899, 12, 16),
                League = serieA,
            };

            context.AddRange(serieB, serieC, milan);
            //context.Leagues.AddRange(serieB, serieC);


            var count=context.SaveChanges();

            Console.WriteLine(count);
        }
    }
}

运行添加代码

查询 

using System;
using Demo.Data;
using Demo.Domain;

namespace Demo.App
{
    class Program
    {
        static void Main(string[] args)
        {
            using var context = new DemoContext();

            var leagues=context.Leagues
                .Where(x=>x.Country =="Italy")
                .ToList();

            foreach(var league in context.Leagues)
            {
                Console.WriteLine(league.Name);
            }
            //var leaguse2 = (from lg in context.Leagues
            //                    where lg.Country =="Italy"
            //                    select lg)              
            //                    .ToList();
        }
    }
}