1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
| protected void Button1_Click(object sender, EventArgs e)
{
try
{
//
// Test de NpgsqlMembershipProvider
//
NpgsqlMembershipProvider tester = new NpgsqlMembershipProvider();
NameValueCollection config = new NameValueCollection();
MembershipUser user;
MembershipCreateStatus status;
NpgsqlProviderUserKey provideruserkey;
int tot;
config.Add("applicationName", "/");
config.Add("maxInvalidPasswordAttempts", "5");
config.Add("passwordAttemptWindow", "10");
config.Add("minRequiredNonAlphanumericCharacters", "1");
config.Add("minRequiredPasswordLength", "7");
config.Add("passwordStrengthRegularExpression", "");
config.Add("enablePasswordReset", "true");
config.Add("enablePasswordRetrieval", "true");
config.Add("requiresQuestionAndAnswer", "false");
config.Add("requiresUniqueEmail", "true");
config.Add("passwordFormat", "Encrypted");
config.Add("connectionStringName", "PgsqlLocalServer");
tester.Initialize(null, config);
user = tester.CreateUser("name", "password", "email", "question", "answer", true, null, out status);
switch (status)
{
case MembershipCreateStatus.DuplicateEmail :
throw new Exception("DuplicateEmail");
case MembershipCreateStatus.DuplicateProviderUserKey :
throw new Exception("DuplicateProviderUserKey");
case MembershipCreateStatus.DuplicateUserName :
throw new Exception("DuplicateUserName");
case MembershipCreateStatus.InvalidAnswer :
throw new Exception("InvalidAnswer");
case MembershipCreateStatus.InvalidEmail :
throw new Exception("InvalidEmail");
case MembershipCreateStatus.InvalidPassword :
throw new Exception("InvalidPassword");
case MembershipCreateStatus.InvalidProviderUserKey :
throw new Exception("InvalidProviderUserKey");
case MembershipCreateStatus.InvalidQuestion :
throw new Exception("InvalidQuestion");
case MembershipCreateStatus.InvalidUserName :
throw new Exception("InvalidUserName");
case MembershipCreateStatus.ProviderError :
throw new Exception("ProviderError");
case MembershipCreateStatus.UserRejected :
throw new Exception("UserRejected");
}
tester.ChangePassword("name", "password", "newone");
tester.ChangePasswordQuestionAndAnswer("name", "newone", "pouet", "pouetpouet");
tester.FindUsersByEmail("email", 0, 1, out tot);
tester.FindUsersByName("name", 0, 1, out tot);
tester.GetAllUsers(0, 10, out tot);
tester.GetNumberOfUsersOnline();
tester.GetPassword("name", "pouetpouet");
provideruserkey = new NpgsqlProviderUserKey();
provideruserkey.UserName = "name";
provideruserkey.ApplicationName = "/";
tester.GetUser(provideruserkey, false);
tester.GetUserNameByEmail("email");
tester.ResetPassword("name", "pouetpouet");
tester.UnlockUser("name");
tester.UpdateUser(user);
tester.ValidateUser("name", "newone");
//
// Test de NpgsqlRoleProvider
//
NpgsqlRoleProvider role = new NpgsqlRoleProvider();
role.Initialize("NpgsqlRoleProvider", config);
role.CreateRole("role");
string[] users = { "name" };
string[] roles = { "role" };
role.AddUsersToRoles(users, roles);
role.FindUsersInRole("role", "name");
role.GetAllRoles();
role.GetRolesForUser("name");
role.GetUsersInRole("admin");
role.IsUserInRole("name", "admin");
role.RemoveUsersFromRoles(users, roles);
role.RoleExists("role");
role.DeleteRole("role", true);
tester.DeleteUser("name", true);
Resultm.Text = "c'est tout bon :)";
}
catch (NpgsqlException n)
{
Resultm.Text = n.Line + " : " + n.Message;
}
} |
[Source] MemberShipProvider et RoleProvider pour postgre (npgsql)
tout fonctionne bien
avec les composants de l'onglets "Connexion" de VS2005.
Répondre avec citation
(en ouvrant un sujet dans le forum approprié).
Envoyé par dinguot
à condition que le paramètre applicationName des providers (dans le web.config) soit personnaliser pour chaque site :
). 
!) les utilisateurs seront "mutualisés" sur les deux sites.
+ 
+ 
= 
!
Partager