Connector/NET commit: r709 - in trunk: . MySql.Web/Source

[rburnett]

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;