国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

打開(kāi)APP
userphoto
未登錄

開(kāi)通VIP,暢享免費(fèi)電子書(shū)等14項(xiàng)超值服

開(kāi)通VIP
linq to sql簡(jiǎn)單使用
 2014/4/6 10:13:40  燕閃碩  博客園  我要評(píng)論(0)
  • 摘要:1.新建一個(gè)winform項(xiàng)目。2.添加一個(gè)LinqtoSql類,命名為Northwind3.打開(kāi)服務(wù)器資源管理器,將表拖動(dòng)到linqtosql類,實(shí)體類就由Vs生成了4.實(shí)例化DataContext類NorthwindDataContextdc=newNorthwindDataContext();5.下面就可以使用LinqtoSql啦。a.查詢Employees所有數(shù)據(jù)varee=fromemployeeindc.Employeesselectemployee;b.加個(gè)Where條件
  • 標(biāo)簽:使用 SQL

1.新建一個(gè)winform項(xiàng)目。

2.添加一個(gè)Linq to Sql 類,命名為Northwind

3.打開(kāi)服務(wù)器資源管理器,將表拖動(dòng)到linq to sql 類,實(shí)體類就由Vs生成了

4.實(shí)例化DataContext類

class="brush:csharp;gutter:true;">NorthwindDataContext dc = new NorthwindDataContext();

5.下面就可以使用Linq to Sql啦。

a.查詢Employees所有數(shù)據(jù)

var ee =
from employee in dc.Employees
select employee;

b.加個(gè)Where條件,查詢Employee表所有City=London

            var e2 =                from employee in dc.Employees                where employee.City == "London"                select employee;

 

c.查詢EmployeeID<5的數(shù)據(jù)

            var e3 =                from employee in dc.Employees                where employee.EmployeeID < 5                select employee;

 

d.查詢雇傭日期在1993年1月1日以前的人員。

            var e4 =                from employee in dc.Employees                where employee.HireDate < new DateTime(1993, 1, 1)                select employee;

 

e.多個(gè)查詢條件

            var e5 =                from employee in dc.Employees                where employee.HireDate < new DateTime(1993, 1, 1)                where employee.EmployeeID < 3                select employee;

 

f.like語(yǔ)句

           var e6 =                from employee in dc.Employees                where SqlMethods.Like(employee.FirstName, "%a%")                //where employee.FirstName.Contains("a")    //等價(jià)于 like '%a%'                //where employee.FirstName.StartsWith("a")  //等價(jià)于 like 'a%'                //where employee.FirstName.EndsWith("a")    //等價(jià)于 like '%a'                select employee;

 

g.查詢指定的列

           var e7 =                (from employee in dc.Employees                 //select new { employee.EmployeeID, employee.FirstName };                 select new                 {                     員工編號(hào) = employee.EmployeeID,                     員工姓名 = employee.FirstName,                     尊稱 = employee.TitleOfCourtesy                 });

 

h.子查詢

            var e8 =                from employee in dc.Employees                where employee.Orders.Count > 100                select employee;

 

i.內(nèi)連接

            /**             * 查詢位于倫敦的客戶的訂單             * SELECT *             * FROM [dbo].[Orders]             * INNER JOIN [dbo].[Customers] ON [Customers].[CustomerID] = [Orders].[CustomerID]             * WHERE [Customers].[City] = 'London'             */            var e9 =                from cus in dc.Customers                join ord in dc.Orders on cus.CustomerID equals ord.CustomerID                where cus.City == "London"                select ord;

 

j.增加

            Employees m = new Employees();            m.LastName = "閃碩";            m.FirstName = "";            m.Title = "閃碩標(biāo)題";            dc.Employees.InsertOnSubmit(m);            dc.SubmitChanges();

 

k.修改

            var e10 = dc.Employees.FirstOrDefault(employee => employee.LastName == "閃碩");            e10.City = "石家莊";            dc.SubmitChanges();

 

l.刪除

            var e10 = dc.Employees.FirstOrDefault(employee => employee.LastName == "閃碩");            dc.Employees.DeleteOnSubmit(e10);            dc.SubmitChanges();

 

練習(xí)代碼使用Vs2012,微軟northwnd示例數(shù)據(jù)庫(kù)

代碼下載:http://pan.baidu.com/s/1pJyh0Mn  

本站僅提供存儲(chǔ)服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請(qǐng)點(diǎn)擊舉報(bào)。
打開(kāi)APP,閱讀全文并永久保存 查看更多類似文章
猜你喜歡
類似文章
LINQ to SQL(3):增刪改查
SQL FOR XML
LINQ查詢操作符 LINQ學(xué)習(xí)第二篇 一、投影操作符
c# – 過(guò)濾條件使用LINQ進(jìn)行搜索
Linq To Sql進(jìn)階系列(七)動(dòng)態(tài)查詢續(xù)及CLR與SQL在某些細(xì)節(jié)上的差別
LINQ 實(shí)現(xiàn)常見(jiàn)SQL查詢_asp.net
更多類似文章 >>
生活服務(wù)
分享 收藏 導(dǎo)長(zhǎng)圖 關(guān)注 下載文章
綁定賬號(hào)成功
后續(xù)可登錄賬號(hào)暢享VIP特權(quán)!
如果VIP功能使用有故障,
可點(diǎn)擊這里聯(lián)系客服!

聯(lián)系客服