LINQ to SQL简单示例(SqlMetal版)

:: 生成中间dbml文件
SqlMetal.exe  /server:. /database:Northwind  /dbml:c:\Northwind.dbml
:: 通过dbml文件生成对象模型
SqlMetal.exe /code:c:\Northwind.cs /language:csharp /namespace:ConsoleApplication1 c:\Northwind.dbml

SqlMetal.exe /server:. /database:Northwind /code:c:\Northwind.cs /language:csharp /namespace:ConsoleApplication1

Northwind nw = new Northwind("Data Source=.;Initial Catalog=Northwind;user=sa;pwd=sa;Pooling=False;");
var query = from item in nw.Customers
            select item.ContactName;
foreach (var item in query)
    Console.WriteLine(item);