用Sql生成的脚本生成C#类.doc

/*?* 作者：?? evlon(阿牛) MSN:niukl@? QQ:273352165?* 功能：?? 得用Sql生成的脚本生成C#类?*/对于Sql Server数据库,有查询分析器的帮助.我们可以省下不少的工夫.如果,在查询分析器的选项.脚本中,勾选将扩展属性脚本作为对象脚本的一部分我们可以生成如下的Create 脚本: CREATE?TABLE?[AdminUsers]?(????[userid]?[int]?IDENTITY?(1,?1)?NOT?NULL?,????[loginID]?[varchar]?(30)?COLLATE?Chinese_PRC_CI_AS?NOT?NULL?,????[loginPwd]?[varchar]?(50)?COLLATE?Chinese_PRC_CI_AS?NOT?NULL?,????[UserName]?[nvarchar]?(30)?COLLATE?Chinese_PRC_CI_AS?NOT?NULL?CONSTRAINT?[DF_AdminUsers_UserName]?DEFAULT?(),????[IsSuperMan]?[bit]?NOT?NULL?CONSTRAINT?[DF_AdminUsers_IsSuperMan]?DEFAULT?(0),????CONSTRAINT?[PK_AdminUsers]?PRIMARY?KEY??CLUSTERED?????(????????[userid]????)??ON?[PRIMARY]?)?ON?[PRIMARY]GOexec?sp_addextendedproperty?NMS_Description,?N是否超级用户,?Nuser,?Ndbo,?Ntable,?NAdminUsers,?Ncolumn,?NIsSuperManGOexec?sp_addextendedproperty?NMS_Description,?N登陆名,?Nuser,?Ndbo,?Ntable,?NAdminUsers,?Ncolumn,?NloginIDGOexec?sp_addextendedproperty?NMS_Description,?N登陆密码,?Nuser,?Ndbo,?Ntable,?NAdminUsers,?Ncolumn,?NloginPwdGOexec?sp_addextendedproperty?NMS_Description,?N用户系统标识,?Nuser,?Ndbo,?Ntable,?NAdminUsers,?Ncolumn,?NuseridGOexec?sp_addextendedproperty?NMS_Description,?N真实姓名,?Nuser,?Ndbo,?Ntable,?NAdminUsers,?Ncolumn,?NUserNameGO 我们要生成下面的C#类: /**////?summary///?AdminUsers的摘要说明。///?/summarypublic?class?AdminUsers{????/**////?summary????///?用户系统标识///?/summary????private?int?userid;????public?int?Userid????{????????get{?return?userid;?}????????set{?userid?=?value;?}????}????/**////?summary????///?登陆名///?/summary????private?string?loginID;????public?string?LoginID????{????????get{?return?loginID;?}????????set{?loginID?=?value;?}????}????/**////?summary????///?登陆密码///?/summary????private?string?loginPwd;????public?string?LoginPwd????{????????get{?return?loginPwd;?}????????set{?loginPwd?=?value;?}????}????/**////?summary????///?真实姓名///?/summary????private?string?userName;????public?string?UserName????{????????get{?return?userName;?}????????set