internal override void setObjectProperties(DbConnection connection, Dictionary <string, object> values)
        {
            this.ExtendedProperties = ExtendedProperties.Where(ep => ep.Level1Object == this.PrincipalName &&
                                                               ep.Level1Type == "USER").ToList();

            if (string.IsNullOrEmpty(this.LoginName))
            {
                this.AuthenticationType = AuthenticationType.NONE;
            }
            else
            {
                switch (this.PrincipalType)
                {
                case PrincipalType.SQLUser:
                    this.AuthenticationType = AuthenticationType.INSTANCE;
                    break;

                case PrincipalType.WindowsUser:
                    this.AuthenticationType = AuthenticationType.WINDOWS;
                    break;
                }
            }

            if (string.IsNullOrEmpty(this.DefaultSchema))
            {
                this.DefaultSchema = "dbo";
            }
            Database.Principals.Add(this);

            // TODO:

            /*
             *
             * if (_is2000OrLess)
             * {
             *      foreach (var role in principals.Where(dp => dp.PrincipalType == PrincipalType.DatabaseRole))
             *      {
             *              cmd.CommandText = string.Format("exec sp_helprolemember [{0}]", role.PrincipalName);
             *
             *              using (var rdr = cmd.ExecuteReader())
             *              {
             *                      if (rdr.HasRows)
             *                      {
             *                              while (rdr.Read())
             *                              {
             *                                      var child = principals.FirstOrDefault(p => p.PrincipalName == rdr["MemberName"].ToString());
             *                                      if (child == null) continue;
             *                                      role.ChildMembers.Add(child);
             *                              }
             *                      }
             *                      rdr.Close();
             *              }
             *      }
             * }
             * else
             * {
             *      cmd.CommandText = @"
             * select drb.role_principal_id as RolePrincipalID, drb.member_principal_id as MemberPrincipalID
             * from sys.database_role_members drb
             * "; ;
             *      using (var rdr = cmd.ExecuteReader())
             *      {
             *              if (rdr.HasRows)
             *              {
             *                      while (rdr.Read())
             *                      {
             *                              var parent = principals.FirstOrDefault(p => p.PrincipalID == (int)rdr["RolePrincipalID"]);
             *                              var child = principals.FirstOrDefault(p => p.PrincipalID == (int)rdr["MemberPrincipalID"]);
             *                              if (child == null || parent == null) continue;
             *                              parent.ChildMembers.Add(child);
             *                      }
             *              }
             *              rdr.Close();
             *      }
             * }
             * return principals;
             */
        }