以 LINQ + DataContext 獲得 Database 上 Table 既 Record

 
以 LINQ + DataContext 獲得 Database 上 Table 既 Record
 

 
   using System;
   using System.Linq;
   using System.Data.Linq;
   using System.Data.Linq.Mapping;
 
   namespace WebApplication13
   {
      public partial class WebForm4 : System.Web.UI.Page
      {
         protected void Page_Load(object sender, EventArgs e)
         {
            try
            {
               string conn = <Connection String>;
               DataContext dc = new DataContext(conn);
               Table<SoccerTeam> TeamData = dc.GetTable<SoccerTeam>();
 
               var TeamCollection = from table in TeamData select table.Team_Name;
 
               foreach (var item in TeamCollection)
               {
                  Response.Write(item.ToString() + "<br />");
               }
            }
            catch (Exception ex)
            {
               Response.Write(ex.Message + "<br />");
            }
         }
      }
 
      [Table(Name = "Team")]
      public class SoccerTeam
      {
         [Column]
         public int Team_ID;
         [Column]
         public String Team_Name;
         [Column]
         public int League_ID;
      }
   }