Linq to sql

参考代码

using System;
using System.Linq;
using LinqToSqlDemo.Orm;

namespace ConsoleApplication2
{
    class Program
    {
        private static DataClassesDataContext dataContext = new DataClassesDataContext();

        private static void Output()
        {
            //输出分类信息
            foreach (people p in dataContext.people)
            {
                Console.WriteLine("Id  " + p.Id + "\nname  " + p.name + "\nage  " + p.age);
            }
        }

        private static void TestInsert()
        {
            //生成分类实体类
            people p1 = new people()
            {
                Id = 1,
                name = "漩涡鸣人",
                age = 22
            };
            people p2 = new people()
            {
                Id = 2,
                name = "路飞",
                age = 18
            };
            people p3 = new people()
            {
                Id = 3,
                name = "孙悟空",
                age = 33
            };

            //加入数据库
            dataContext.people.InsertOnSubmit(p1);
            dataContext.people.InsertOnSubmit(p2);
            dataContext.people.InsertOnSubmit(p3);
            dataContext.SubmitChanges();
        }

        private static void TestDelete()
        {
            dataContext.people.DeleteOnSubmit(dataContext.people.Single(p => p.name == "路飞"));
            dataContext.SubmitChanges();
        }

        private static void TestUpdate()
        {
            people _p = dataContext.people.Single(p => p.name == "孙悟空");
            _p.age = 11;
            dataContext.SubmitChanges();
        }

        static void Main(string[] args)
        {
            Console.WriteLine("==============================Linq to SQL 测试==============================");
            Console.WriteLine();

            Console.WriteLine("==============================测试Insert==============================");
            Console.WriteLine();
            TestInsert();
            Output();

            Console.WriteLine("==============================测试Delete==============================");
            Console.WriteLine();
            TestDelete();
            Output();

            Console.WriteLine("==============================测试Update==============================");
            Console.WriteLine();
            TestUpdate();
            Output();

            Console.ReadLine();
        }
    }
}