EF增删查改

增

namespace TryAboutEF
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var db = new Model1())
            {
                Student s = new Student
                {
                    Id = 2,
                    Age = "23",
                    Name = "钱"
                };
                db.Student.Add(s);
                db.SaveChanges();
            }
        }
    }
}
 

删

namespace TryAboutEF
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var db = new Model1())
            {
                var student = db.Student.FirstOrDefault(s => s.Id == 1);
                db.Student.Remove(student);
                db.SaveChanges();
            }
        }
    }
} 

改

namespace TryAboutEF
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var db = new Model1())
            {
                var student = db.Student.FirstOrDefault(s => s.Id == 2);
                student.Name = "钱2";
                db.SaveChanges();
            }
        }
    }
}

查

namespace TryAboutEF
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var db = new Model1())
            {
                var result = from i in db.Student
                    where i.Name != null
                    select i;
                foreach (var student in result)
                {
                    Console.WriteLine("id:" + student.Id + "Name" + student.Name + "Age" + student.Age);
                }

                Console.WriteLine("finish!");
            }
        }
    }
}