Entity FrameWork 6基本增删改查

增+查

using EFDemo01.Modules;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity.Validation;

namespace EFDemo01
{
    internal class Program
    {
        static void Main(string[] args)
        {
            using (var db = new DBModel())
            {
                /**
                 */
                //person表insert数据
                db.people.Add(new person { name = "张三", age = 20, position = "码农", departmentId = 2 });
                db.people.Add(new person { name = "李四", age = 19, position = "工程", departmentId = 3 });
                //department表insert数据
                db.departments.Add(new department { departmentName = "SI" });
                db.departments.Add(new department { departmentName = "CIM" });
                db.departments.Add(new department { departmentName = "TED" });
                //提交transact sql
                db.SaveChanges();

                //
                var resultPeople = db.people.Where(p => p.age >= 20).DefaultIfEmpty();
                foreach (var per in resultPeople)
                {
                    Console.WriteLine($"姓名:{per.name}, 年龄:{per.age}, 部门:{per.position}");
                }
                var resultDepartment = from depar in db.departments select depar;
                foreach (var depar in resultDepartment)
                {
                    Console.WriteLine($"部门:{depar.departmentName}");
                }
            }
            Console.Read();
        }
    }
}

using EFDemo01.Modules;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity.Validation;

namespace EFDemo01
{
    internal class Program
    {
        static void Main(string[] args)
        {
            using (var db = new DBModel())
            {
                var resultBeforeUpdate = db.people.Where(p => p.age >= 20).DefaultIfEmpty();

                //
                var person = db.people.Where(p => p.name=="小明").FirstOrDefault();
                if (person != null)
                {
                    person.age = 22;
                    db.SaveChanges();
                }

                var resultAfterUpdate = db.people.Where(p => p.age >= 20).DefaultIfEmpty();

                Console.WriteLine("修改前:");
                foreach (var per in resultBeforeUpdate)
                {
                    Console.WriteLine($"姓名:{per.name}, 年龄:{per.age}, 部门:{per.position}");
                }
                Console.WriteLine("修改后:");
                foreach (var per in resultAfterUpdate)
                {
                    Console.WriteLine($"姓名:{per.name}, 年龄:{per.age}, 部门:{per.position}");
                }

            }
            Console.Read();
        }
    }
}

 删

using EFDemo01.Modules;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.Entity.Validation;
using System.Data;

namespace EFDemo01
{
    internal class Program
    {
        static void Main(string[] args)
        {
            using (var db = new DBModel())
            {
                //
                var person = db.people.Where(p => p.name == "张三").FirstOrDefault();
                if (person != null)
                {
                    db.people.Remove(person);
                    db.SaveChanges();
                }
                var resultAfterRemove = from p in db.people where 1==1 select p;
                Console.WriteLine("删除后:");
                foreach (var per in resultAfterRemove)
                {
                    Console.WriteLine($"姓名:{per.name}, 年龄:{per.age}, 部门:{per.position}");
                }
            }
            Console.Read();
        }
    }
}

 

删除前:

 删除后:

 

posted @ 2023-05-12 13:33  船长华莱士  阅读(102)  评论(0)    收藏  举报