a few more changes on mysql

1 files changed, 19 insertions, 17 deletions

diff --git a/OpenSim/Data/MySQL/MySQLAuthenticationData.cs b/OpenSim/Data/MySQL/MySQLAuthenticationData.cs
index 5030c1d..fef582e 100644
--- a/OpenSim/Data/MySQL/MySQLAuthenticationData.cs
+++ b/OpenSim/Data/MySQL/MySQLAuthenticationData.cs
@@ -77,30 +77,32 @@ namespace OpenSim.Data.MySQL
                 {
                     cmd.Parameters.AddWithValue("?principalID", principalID.ToString());
 
-                    IDataReader result = cmd.ExecuteReader();
-
-                    if (result.Read())
+                    using(IDataReader result = cmd.ExecuteReader())
                     {
-                        ret.PrincipalID = principalID;
+                         if(result.Read())
+                        {
+                            ret.PrincipalID = principalID;
 
-                        CheckColumnNames(result);
+                            CheckColumnNames(result);
 
-                        foreach (string s in m_ColumnNames)
-                        {
-                            if (s == "UUID")
-                                continue;
+                            foreach(string s in m_ColumnNames)
+                            {
+                                if(s == "UUID")
+                                    continue;
 
-                            ret.Data[s] = result[s].ToString();
-                        }
+                                ret.Data[s] = result[s].ToString();
+                            }
 
-                        return ret;
-                    }
-                    else
-                    {
-                        return null;
+                            dbcon.Close();
+                            return ret;
+                        }
+                        else
+                        {
+                            dbcon.Close();
+                            return null;
+                        }
                     }
                 }
-                dbcon.Close();
             }
         }