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

namespace LINQDemo.Model
{
    public class Book
    {
        public int Id { get; set; }

        public string Name { get; set; }

        public string Author { get; set; }

        public DateTime PublicationDate { get; set; }
    }
}

using LINQDemo.Model;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LINQDemo.EF
{
    public class SeedingDataInitializer : DropCreateDatabaseAlways<Context>
    {
        /// <summary>
        /// 初始化種子數(shù)據(jù)
        /// </summary>
        /// <param name="context"></param>
        protected override void Seed(Context context)
        {
            context.Books.Add(new Book { Name = "C#高級編程（第十版）", Author = "小明", PublicationDate = Convert.ToDateTime("2017-12-11 12:12:45") });
            context.Books.Add(new Book { Name = "oracle從入門到精通", Author = "張三", PublicationDate = Convert.ToDateTime("2015-12-11 12:12:45") });
            context.Books.Add(new Book { Name = "JavaScript高級編程", Author = "李四", PublicationDate = Convert.ToDateTime("2011-09-11 12:12:45") });
            base.Seed(context);
        }
    }
}

using LINQDemo.Model;
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace LINQDemo.EF
{
    public class Context :DbContext
    {
        public Context()
            : base("AppConnection")
        {
            Database.SetInitializer<Context>(new SeedingDataInitializer());
        }

        // 添加到數(shù)據(jù)上下文
        public virtual DbSet<Book> Books { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            // 設(shè)置生成的表名:Book
            modelBuilder.Entity<Book>().ToTable("Book");
            base.OnModelCreating(modelBuilder);
        }
    }
}

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

namespace LINQDemo
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var context = new Context())
            {
                #region   查詢語法
                var result = from p in context.Books where p.Name.Equals("JavaScript高級編程") select p;
                #endregion

                #region 方法語法
                var books = context.Books.Where(p => p.Name.Equals("JavaScript高級編程"));

                foreach (var item in books)
                {
                    Console.WriteLine(string.Format("書名：{0},作者：{1},發(fā)布時(shí)間：{2}", item.Name, item.Author, item.PublicationDate));
                }
                #endregion
            }

            Console.WriteLine("完成");
            Console.ReadKey();
        }
    }
}