以 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; } } |