1 files changed, 14 insertions, 13 deletions

diff --git a/OpenSim/Data/MySQL/MySQLFSAssetData.cs b/OpenSim/Data/MySQL/MySQLFSAssetData.cs
index 2fb81ae..ce40c03 100644
--- a/OpenSim/Data/MySQL/MySQLFSAssetData.cs
+++ b/OpenSim/Data/MySQL/MySQLFSAssetData.cs
@@ -316,15 +316,16 @@ namespace OpenSim.Data.MySQL
                     return 0;
                 }
 
-                MySqlCommand cmd = conn.CreateCommand();
-
-                cmd.CommandText = String.Format("select count(*) as count from {0}", m_Table);
-
-                using (IDataReader reader = cmd.ExecuteReader())
+                using(MySqlCommand cmd = conn.CreateCommand())
                 {
-                    reader.Read();
+                    cmd.CommandText = String.Format("select count(*) as count from {0}",m_Table);
+
+                    using (IDataReader reader = cmd.ExecuteReader())
+                    {
+                        reader.Read();
 
-                    count = Convert.ToInt32(reader["count"]);
+                        count = Convert.ToInt32(reader["count"]);
+                    }
                 }
             }
 
@@ -333,15 +334,15 @@ namespace OpenSim.Data.MySQL
 
         public bool Delete(string id)
         {
-            MySqlCommand cmd = new MySqlCommand();
-
-            cmd.CommandText = String.Format("delete from {0} where id = ?id", m_Table);
+            using(MySqlCommand cmd = new MySqlCommand())
+            {
 
-            cmd.Parameters.AddWithValue("?id", id);
+                cmd.CommandText = String.Format("delete from {0} where id = ?id",m_Table);
 
-            ExecuteNonQuery(cmd);
+                cmd.Parameters.AddWithValue("?id", id);
 
-            cmd.Dispose();
+                ExecuteNonQuery(cmd);
+            }
 
             return true;
         }