[Table(Name="Products")] public class Products { public int ProductID; public string ProductName ; }
LINQ to SQL 的Table属性位于System.data.Linq.Mapping命名空间中。在进行开发的过程中需要添加命名空间
[Table(Name="Products")] public class Products { [Column(IsPrimaryKey = true)] public int ProductID{get;set;} [Column(Name="ProductName")] public string ProductName { get; set; } }
dataContext
提供 LINQ (语言集成查询) 访问和更改跟踪、 列表和Microsoft SharePoint Foundation网站的文档库。
具体工程代码如下:
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Data.SqlClient; using System.Data; using System.Xml; using System.Data.Linq.Mapping; using System.Data.Linq; namespace ConsoleApplication1 { class Program { [Table(Name="Products")] public class Products { [Column(IsPrimaryKey = true)] public int ProductID{get;set;} [Column(Name="ProductName")] public string ProductName { get; set; } } static void Main() { SqlConnection conn = new SqlConnection(@"Data Source=;Initial Catalog=Store;User ID=sa;Password= 123;"); DataContext ctx = new DataContext(conn); var stores = from store in ctx.GetTable<Products>() where store.ProductID >= 2 select store; foreach (var store in stores) { Console.WriteLine(store.ProductName); } Console.ReadLine(); } } }