lambda表达式5
示例数据库
?

 字段名字段类型允许空字段说明   IDuniqueidentifier?表主键字段   UserNamevarchar(50)?留言用户名   PostTimedatetime?留言时间   Messagevarchar(400)√留言内容   IsRepliedbit?留言是否回复   Replyvarchar(400)√留言管理员回复 

创建数据库，同时创建表tblGuestBook

右键点击网站项目，选择添加新项，然后选择“Linq to sql Classes”，命名为GuestBook。然后打开App_Code里面的GuestBook.dbml。
那么，我们就在服务器资源管理器中创建一个指向GuestBook数据库的数据连接，然后把tbGuestBook表拖动到GuestBook.dbml的设计视图上，按CTRL+S保存。打开GuestBook.designer.cs可以发现系统自动创建了GuestBook数据库中tbGuestBook表的映射
GuestBook.designer.cs
代码：

#pragma warning disable 1591//------------------------------------------// <auto-generated>//     此代码由工具生成。//     运行时版本:4.0.30319.1////     对此文件的更改可能会导致不正确的行为，并且如果//     重新生成代码，这些更改将会丢失。// </auto-generated>//------------------------------------------using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Data.Linq;using System.Data.Linq.Mapping;using System.Linq;using System.Linq.Expressions;using System.Reflection;[global::System.Data.Linq.Mapping.DatabaseAttribute(Name="linq1")]public partial class GuestBookDataContext : System.Data.Linq.DataContext{private static System.Data.Linq.Mapping.MappingSource mappingSource = new AttributeMappingSource();  #region 可扩展性方法定义  partial void OnCreated();  #endregionpublic GuestBookDataContext() : base(global::System.Configuration.ConfigurationManager.ConnectionStrings["linq1ConnectionString"].ConnectionString, mappingSource){OnCreated();}public GuestBookDataContext(string connection) : base(connection, mappingSource){OnCreated();}public GuestBookDataContext(System.Data.IDbConnection connection) : base(connection, mappingSource){OnCreated();}public GuestBookDataContext(string connection, System.Data.Linq.Mapping.MappingSource mappingSource) : base(connection, mappingSource){OnCreated();}public GuestBookDataContext(System.Data.IDbConnection connection, System.Data.Linq.Mapping.MappingSource mappingSource) : base(connection, mappingSource){OnCreated();}public System.Data.Linq.Table<tblGuestBook> tblGuestBook{get{return this.GetTable<tblGuestBook>();}}}[global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.tblGuestBook")]public partial class tblGuestBook{private int _ID;private string _UserName;private System.DateTime _PostTime;private string _Message;private bool _IsReplied;private string _Reply;public tblGuestBook(){}[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ID", AutoSync=AutoSync.Always, DbType="Int NOT NULL IDENTITY", IsDbGenerated=true)]public int ID{get{return this._ID;}set{if ((this._ID != value)){this._ID = value;}}}[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_UserName", DbType="NVarChar(50) NOT NULL", CanBeNull=false)]public string UserName{get{return this._UserName;}set{if ((this._UserName != value)){this._UserName = value;}}}[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_PostTime", DbType="DateTime NOT NULL")]public System.DateTime PostTime{get{return this._PostTime;}set{if ((this._PostTime != value)){this._PostTime = value;}}}[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Message", DbType="VarChar(400)")]public string Message{get{return this._Message;}set{if ((this._Message != value)){this._Message = value;}}}[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_IsReplied", DbType="Bit NOT NULL")]public bool IsReplied{get{return this._IsReplied;}set{if ((this._IsReplied != value)){this._IsReplied = value;}}}[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Reply", DbType="VarChar(400)")]public string Reply{get{return this._Reply;}set{if ((this._Reply != value)){this._Reply = value;}}}}#pragma warning restore 1591

由表自动生成实体类。
2011-6-2 22:28 danny