24畫(huà)生有一篇同名文章(http://www.cnblogs.com/esshs/archive/2006/07/13/449888.html),但他只是列一下數(shù)據(jù)庫(kù)表與字段,并沒(méi)有展開(kāi)講述.

下面我以DNN4.5.5為源碼版本站在24畫(huà)生的肩旁上再展開(kāi)講述.

由上面三圖可見(jiàn),DNN系統(tǒng)設(shè)計(jì)中的MemberShip是完全獨(dú)立于DNN其他表的,那么能不能將整個(gè)MemberShip獨(dú)立放一個(gè)表中,或直接使用已經(jīng)存在的MemberShip表?由于上面的表是相對(duì)獨(dú)立的,沒(méi)有直接關(guān)系,所以理論上是可以的.實(shí)際上可以嗎?做個(gè)實(shí)驗(yàn).

 在web.config中增加一個(gè)數(shù)據(jù)連接字符串.SiteSqlServer1,并且指向已經(jīng)存在的MemberShip數(shù)據(jù)庫(kù)ASPNETDB,其中DNN4_5_5是空數(shù)據(jù)庫(kù),即DNN并未安裝,ASPNETDB是一個(gè)現(xiàn)存系統(tǒng)的MemberShip數(shù)據(jù)庫(kù).

 <connectionStrings>
    <!-- Connection String for SQL Server 2005 Express
    <add
      name="SiteSqlServer"
      connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
      providerName="System.Data.SqlClient" />
    -->
    <!-- Connection String for SQL Server 2000/2005 -->
    <add name="SiteSqlServer" connectionString="Data Source=(local);Initial Catalog=DNN4_5_5;User ID=sa;Password=" providerName="System.Data.SqlClient" />
    <add name="SiteSqlServer1" connectionString="Data Source=(local);Initial Catalog=ASPNETDB;User ID=sa;Password=" providerName="System.Data.SqlClient" />
  </connectionStrings>

將AspNetSqlMembershipProvider的配置connectionStringName="SiteSqlServer"改成 connectionStringName="SiteSqlServer1"如下.

    <membership defaultProvider="AspNetSqlMembershipProvider" userIsOnlineTimeWindow="15">
      <providers>
        <clear />
        <!-- Configuration for DNNSQLMembershipProvider:
              connectionStringName="string"               Name corresponding to the entry in <connectionStrings> section where the connection string for the provider is specified
              passwordAttemptThreshold="int"              The number of failed password attempts, or failed password answer attempts that are allowed before locking out a user?s account
              passwordAttemptWindow="int"                 The time window, in minutes, during which failed password attempts and failed password answer attempts are tracked
              enablePasswordRetrieval="[true|false]"      Should the provider support password retrievals
              enablePasswordReset="[true|false]"          Should the provider support password resets
              requiresQuestionAndAnswer="[true|false]"    Should the provider require Q & A
                    minRequiredPasswordLength="int"                  The minimum password length
                    minRequiredNonalphanumericCharacters="int"  The minimum number of non-alphanumeric characters
              applicationName="string"                    Optional string to identity the application: defaults to Application Metabase path
              requiresUniqueEmail="[true|false]"          Should the provider require a unique email to be specified
              passwordFormat="[Clear|Hashed|Encrypted]"   Storage format for the password: Hashed (SHA1), Clear or Encrypted (Triple-DES)
              description="string"                        Description of what the provider does
        -->
        <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="SiteSqlServer1" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="false" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" requiresUniqueEmail="false" passwordFormat="Encrypted" applicationName="/" description="Stores and retrieves membership data from the local Microsoft SQL Server database" />
      </providers>
    </membership>

這樣運(yùn)行的結(jié)果是:

DNN成功安裝,DNN4_5_5數(shù)據(jù)庫(kù)中有MemberShip的所有表,但是里面全為空,host,admin的賬號(hào)在ASPNETDB的MemberShip表中,用host,admin賬號(hào)登錄成功.DNN運(yùn)行一切正常.

這面意味著:DNN可以很方便地與其他同樣以MemberShip為身份驗(yàn)證的系統(tǒng)整合.

再分析相關(guān)代碼:

舉例: 刪除用戶方法

Public Overrides Function DeleteUser(ByVal user As UserInfo) As Boolean

    Dim retValue As Boolean = True
    Dim dr As IDataReader

    Try
        dr = dataProvider.GetRolesByUser(user.UserID, user.PortalID)
        While dr.Read
            dataProvider.DeleteUserRole(user.UserID, Convert.ToInt32(dr("RoleId")))
        End While
        dr.Close()

        ‘check if user exists in any other portal
        dr = dataProvider.GetUserByUsername(-1, user.Username)
        dr.Read()
        If Not dr.Read Then
            dataProvider.DeleteUser(user.UserID) ‘ 刪除dnn_User表中的用戶記錄

            ‘Delete AspNet MemrshipUser
            retValue = DeleteMembershipUser(user)  ‘刪除Membership表中的用戶記錄(至于Membership相關(guān)表在哪里,在這里是透明的,DNN并不在意他在哪里.)
        Else
            dataProvider.DeleteUserPortal(user.UserID, user.PortalID)
        End If
        dr.Close()
    Catch ex As Exception
        retValue = False
    End Try

    Return retValue

End Function

Private Function DeleteMembershipUser(ByVal user As UserInfo) As Boolean
    Dim retValue As Boolean = True
    Try

‘刪除Membership表中的用戶記錄(至于Membership相關(guān)表在哪里,在這里是透明的,DNN并不在意他在哪里.)
        AspNetSecurity.Membership.DeleteUser(user.Username, True)
    Catch ex As Exception
        retValue = False
    End Try
    Return retValue
End Function

我比較喜歡這樣的設(shè)計(jì),因?yàn)檫@樣,不管多少系統(tǒng),只要基于MemberShip就可以很方便地整合在一起.實(shí)現(xiàn)單點(diǎn)登陸.