LINQ ASP NET WPF Win Form RIASilverlight MobileWindows

{ LINQ為何重要 } 未來存取任何資料來源的核心技術 應用在各種領域 -ASP. NET -WPF / Win. Form -RIA(Silverlight) -Mobile(Windows Mobile)

{ LINQ的魔術 } 相容於. NET Framework 2. 0 都是Syntactic Sugar(Compiler Sugar) 輔助的Assembly(. NET Framework 3. 5)

{ LINQ的組成 } 都是Syntactic Sugar(Compiler Sugar) 語言的擴充(Language Extension) 由C# / VB的編譯器來完成 輔助的Assembly(. NET Framework 3. 5) 具箱(LINQ Toolset) 由相容於. NET Framework 2. 0的函式庫完成

ADO. NET Entity Framework The Entity Data Model ADO. NET Entity Framework ADO. NET 2. 0 LINQ over Entities Dataset Object Services ADO. NET Providers Entity Client LINQ over Dataset Language Integrated Query (LINQ) ADO. NET Providers <book> <title/> <author/> <year/> <price/> </book>

{ LINQ架構 } C# 3. 0 VB 9. 0 其他語言 LINQ Provider(LINQ Toolset) LINQ to ADO. NET LINQ to Objects LINQ to Data. Set LINQ to SQL <book> <title/> <author/ > <year/> <price/> </book> ADO. NET Data. Set Objects 所有ADO. NET Data. Set能使用 的資料來源 LINQ to XML SQL Server XML LINQ to Other Data Source ? 其他 資料來源

{ LINQ架構 + 加入EF } C# 3. 0 VB 9. 0 其他語言 LINQ Provider(LINQ Toolset) LINQ to ADO. NET LINQ to Objects LINQ to Data. Set LINQ to SQL Objects LINQ to Entity <book> <title/> <author/ > <year/> <price/> </book> ADO. NET Data. Set 所有ADO. NET Data. Set能使用 的資料來源 LINQ to XML SQL Server XML 關聯式 資料庫

{ Demo } Visual Studio 2008 對LINQ的價值

{ Demo } LINQ 的運作方式 -使用Visual. Linq

{ Demo } LINQ to SQL -使用LINQPad

from c in Customers where c. City == "London" select c 列舉 應用程式 物件 db. Customers. Add(c 1); c 2. City = “Seattle"; db. Customers. Remove(c 3); Submit. Changes() LINQ to SQL 查詢 或 預存程序 SELECT * FROM Customer WHERE City = 'London' 資料列 SQL 新增、修改、刪除 或 預存程序 INSERT INTO Customer … UPDATE Customer … DELETE FROM Customer …

{ Demo } LINQ to SQL -使用Visual. Studio 2008

Database Table View Column Relationship Stored Procedure

{ Visual Studio 2008的價值 } O/R Mapping設計 具 - LINQ to SQL - LINQ to ADO. NET EF 除錯 - 直接支援LINQ語法的單步執行

{ Demo } LINQ to XML -LINQPad

網站資源 Links to LINQ http: //blogs. msdn. com/charlie/archive/2006/10/05/Links-to. LINQ. aspx LINQ in Action網站 http: //linqinaction. net/ Thinq. Linq http: //thinqlinq. com/ Hooked On LINQ http: //www. hookedonlinq. com

具資源 LINQPad 簡易的LINQ學習 具 http: //www. linqpad. net/ Visual LINQ http: //msmvps. com/blogs/jon. skeet/archive/2008/02/20/visual-linqwatch-query-expressions-as-they-happen. aspx Visual LINQ Query Builder http: //code. msdn. microsoft. com/vlinq

© 2007 Microsoft Corporation. All rights reserved. Microsoft, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U. S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.