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(); } } }
LINQ方式查询数据库
最新推荐文章于 2024-05-12 16:34:34 发布