当前文件路径：LinqDemo/App_Code/BLL/StaffBLL.cs

		            
 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Linq;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.HtmlControls;
 9using System.Web.UI.WebControls;
10using System.Web.UI.WebControls.WebParts;
11using System.Xml.Linq;
12//Download from 51aspx.com/cv/LinqDemo
13/**//// <summary>
14///StaffBLL 的摘要说明
15/// </summary>
16public class StaffBLL
17...{
18
19    Linq.StaffDataContext st = new Linq.StaffDataContext();
20    public StaffBLL()
21    ...{
22        //
23        //TODO: 在此处添加构造函数逻辑
24        //
25    }
26    public IQueryable LinqStaff()
27    ...{
28        var staff = from s in st.DutyStaff  select s;
29        return staff;
30    }
31
32    public bool LinqUpdateStaff(int id,string name,int age)
33    ...{
34        Linq.DutyStaff staff = st.DutyStaff.Single(a=>a.ID==id);
35        staff.StaffName = name;
36        staff.StaffAge = age;
37        st.SubmitChanges();
38        return true;
39    }
40
41    public bool LinqInsertStaff(string name,int age)
42    ...{
43        Linq.DutyStaff staff = new Linq.DutyStaff();
44        staff.StaffName = name;
45        staff.StaffAge = age;
46        st.DutyStaff.InsertOnSubmit(staff);
47        st.SubmitChanges();
48        return true;
49    }
50
51    public bool LinqDeleteStaff(int id) 
52    ...{
53        Linq.DutyStaff staff = st.DutyStaff.Single(a => a.ID == id);
54        st.DutyStaff.DeleteOnSubmit(staff);
55        st.SubmitChanges();
56        return true;
57
58    }
59}
60