LINQ方式查询数据库

using System;using System.Linq;namespace ConsoleApplication1{ class Class1 { static void Main(string[] args) { NorthwindDataContext dc = new NorthwindDataContext(); //DataContext dc = new DataContext(@"Data Source=./SQLEXPRESS; //AttachDbFilename=|DataDirectory|/NORTHWIND.MDF;Integrate Security=True; User Instance=True"); //Table < Product > query = dc.GetTable < Product > (); var query = from p in dc.Products select p; //Table < Product > query = dc.Products; foreach (Product item in query) { Console.WriteLine(item.ProductID + "|" + item.ProductName); } Console.ReadLine(); } }}