对象关系映射(ORM)及代码生成器和插件C#源码(DBFrameworkV4.5.3)

下载地址：http://download.csdn.net/source/720607   

 [Serializable()]
    [Table(TableName = "usyUser")]
    public class BusinessUser : SqlTableGateway<BusinessUser>, ICloneable
    {

        public BusinessUser()
        {
            string connectionString = SystemConfig.ConnectionString;
            base.InitializeGateway(connectionString, this);
        }

        略.............

        #region Properties

        [Column(ColumnName = "UserId", IsIdentity = true, IsPrimaryKey = true)]
        public int UserId
        {
            get { return _userId; }
            set { _userId = value; }
        }

        [Column(ColumnName = "EmployeeNumber")]
        public string EmployeeNumber
        {
            get { return _employeeNumber; }
            set { _employeeNumber = value; }
        }

        [Column(ColumnName = "UserName")]
        public string UserName
        {
            get { return _userName; }
            set { _userName = value; }
        }


       Role[] _roles = new Role[0];
      [Relation(RelationType = RelationType.ManyToMany, InterrelationType = typeof(UserRole), ResultOrder = "RoleName ASC")]
        public Role[] Roles
        {
            get { return _roles; }
            set { _roles = value; }
        }



      public DataTable RoleTable
        {
            get
            {
                Role role = new Role();
                return role.ToTable(_roles, false);
            }
        }

      #endregion //Properties



       }

        Role role = new Role();
        gvRole.DataSource = role.QueryAll();
        gvRole.DataBind();

        Role role = new Role();
        int roleId=1;
        role.RoleId = roleId;
        role.IsActive = false;
        role.PartialUpdateById("IsActive") ;

        Role role = new Role();
        int roleId=1;
        role.RoleId = roleId;
        role.RetrieveById();
        role.IsActive = false;
        role.UpdateById() ;

        BusinessUser user = new BusinessUser();
        user.UserId = 2;
        user.RetrieveRelationObject(typeof(Role));