Linq to sql

来源:互联网 发布:小米4c数据信号不稳定 编辑:程序博客网 时间:2024/05/18 02:07
using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data.Linq;namespace ConsoleApplication1{    class Program    {        public static DataClasses1DataContext DataClass=new DataClasses1DataContext();        static void Main(string[] args)        {            //=====================查询所有========================            var Select = SelectAll();            foreach (var sel in Select)            {                Console.WriteLine(sel.name);            }            //==================查询指定条件内容==========================            aa SelectSingles = SelectSingle();            Console.WriteLine(SelectSingles.name);            //==================修改指定条件的内容========================            Update();                         //=================添加指定条件的内容========================            Insert();            //=================删除指定条件的内容========================            Delete();        }        //linq to sql查询全部        public static IEnumerable<aa> SelectAll()        {            return DataClass.aa;        }        public static aa SelectSingle()        {            return DataClass.aa.Single(x => x.name == "测试");        }        public static void Update()        {            var updates = DataClass.aa.Single(x=>x.name=="测试");            updates.name = "abc";            DataClass.SubmitChanges();//千万别忘记            Console.WriteLine("更新完成");        }        public static void Insert()        {             var a=new aa            {              name="添加"            };            DataClass.aa.InsertOnSubmit(a);            DataClass.SubmitChanges();            Console.WriteLine("添加成功");        }        public static void Delete()        {            DataClass.aa.DeleteOnSubmit(DataClass.aa.Single(x=>x.name=="测试"));            DataClass.SubmitChanges();            Console.WriteLine("删除成功");        }    }}

原创粉丝点击