using System;using System.Collections.Generic;using System.Data.Linq;using System.Text;using System.Data.SqlClient;using System.Data.Linq.Mapping;
namespace ConsoleApplication1{ class Program { static void Main(string[] args) { SqlConnectionStringBuilder builder=new SqlConnectionStringBuilder; builder.DataSource="36110227"; builder.InitialCatalog="Northwind"; builder.IntegratedSecurity=true; DataContext db=new DataContext(builder.ConnectionString); Table<product> products=db.GetTable<product>(); var productQuery=from p in products select p; foreach(var p in productQuery) { Console.WriteLine("客户号：{0}客户名：{1}供应商号：{2}单价：{3}",) } } } [Table(Name = "Products")] public class product { [Column(IsPrimaryKey = true, CanBeNull = false)] public int productID { get; set; } [Column(CanBeNull = false)] public string productName { get; set; } [Column] public decimal? Unitprice { get; set; } }}


using System;
using System.Collections.Generic;
using System.Data.Linq;
using System.Linq;
using System.Text;
using System.Data.SqlClient;
using System.Data.Linq.Mapping;
namespace ConsoleApplication1
{
     class Program
     {
         static void Main(string[] args)
         {
             SqlConnectionStringBuilder builder=new SqlConnectionStringBuilder;
             builder.DataSource="36110227";
             builder.InitialCatalog="Northwind";
             builder.IntegratedSecurity=true;
             DataContext db=new DataContext(builder.ConnectionString);
             Table<product> products=db.GetTable<product>();
             var productQuery=from p in products select p;
             foreach(var p in productQuery)
             {
                 Console.WriteLine("客户号：{0}客户名：{1}供应商号：{2}单价：{3}",p.productID,p.productName,p.Unitprice);
             }
         }
     }
     [Table(Name = "Products")]
     public class product
     {
         [Column(IsPrimaryKey = true, CanBeNull = false)]
         public int productID { get; set; }
         [Column(CanBeNull = false)]
         public string productName { get; set; }
         [Column]
         public decimal? Unitprice { get; set; }
     }
}