From: Date: May 8 2007 5:19pm
Subject: Connector/NET commit: r709 - in trunk: . MySql.Web/Source
List-Archive: http://lists.mysql.com/commits/26307
X-Bug: 28251
Message-Id: <200705081519.l48FJLYk014044@bk-internal.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Modified:
   trunk/CHANGES
   trunk/MySql.Web/Source/RoleProvider.cs
Log:
Bug #28251  	mysql_usersinroles not found

Fixed bug in role provider where the GetRolesForUser override was attemtping to use the wrong table due to a typo.

Modified: trunk/CHANGES
===================================================================
--- trunk/CHANGES	2007-05-08 14:42:56 UTC (rev 708)
+++ trunk/CHANGES	2007-05-08 15:19:21 UTC (rev 709)
@@ -3,7 +3,7 @@
     attribute.  This causes dots to show instead of actual password text.
   - Fixed problem with pooling on the compact framework.  It should work now.    
   - Install now calls VS setup only when VS integration is selected. (bug #28260)
-
+  - MySqlRoleProvider.GetRolesForUser now works correctly (bug #28251)
     
 Version 5.1.0 - 5/1/2007
 

Modified: trunk/MySql.Web/Source/RoleProvider.cs
===================================================================
--- trunk/MySql.Web/Source/RoleProvider.cs	2007-05-08 14:42:56 UTC (rev 708)
+++ trunk/MySql.Web/Source/RoleProvider.cs	2007-05-08 15:19:21 UTC (rev 709)
@@ -294,7 +294,7 @@
             MySqlConnection conn = new MySqlConnection(connectionString);
             MySqlCommand cmd =
                 new MySqlCommand(
-                    @"SELECT Rolename FROM myql_UsersInRoles 
+                    @"SELECT Rolename FROM mysql_UsersInRoles 
                 WHERE Username = ?Username AND ApplicationName = ?ApplicationName",
                     conn);
             cmd.Parameters.Add("?Username", MySqlDbType.VarChar, 255).Value = username;