mcs/class/System.Data/Test/ProviderTests/Common/DBHelper.cs

   1 // DBHelper.cs : Helper class for executing queries with database.
   2 //
   3 // Authors:
   4 //      Sureshkumar T (tsureshkumar@novell.com)
   5 //
   6 // Copyright (c) 2004 Novell Inc., and the individuals listed on the
   7 // ChangeLog entries.
   8 //
   9 //
  10 // Permission is hereby granted, free of charge, to any person
  11 // obtaining a copy of this software and associated documentation
  12 // files (the "Software"), to deal in the Software without
  13 // restriction, including without limitation the rights to use, copy,
  14 // modify, merge, publish, distribute, sublicense, and/or sell copies
  15 // of the Software, and to permit persons to whom the Software is
  16 // furnished to do so, subject to the following conditions:
  17 //
  18 // The above copyright notice and this permission notice shall be
  19 // included in all copies or substantial portions of the Software.
  20 //
  21 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  22 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  23 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  24 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS
  25 // BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN
  26 // ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN
  27 // CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
  28 // SOFTWARE.
  29
  30 using System;
  31 using System.Data;
  32 using System.Text;
  33
  34 namespace MonoTests.System.Data.Connected
  35 {
  36         public sealed class DBHelper
  37         {
  38                 public static Random random = new Random ( (int) DateTime.Now.Ticks);
  39
  40                 public static int ExecuteNonQuery (IDbConnection connection ,string query)
  41                 {
  42                         IDbCommand command = connection.CreateCommand ();
  43                         command.CommandType = CommandType.Text;
  44                         command.CommandText = query;
  45                         int result = -1;
  46                         try {
  47                                 result = command.ExecuteNonQuery ();
  48                         } catch {
  49                                 return -2;
  50                         }
  51                         return result;
  52                 }
  53
  54                 public static int ExecuteSimpleSP (IDbConnection connection ,string proc)
  55                 {
  56                         IDbCommand command = connection.CreateCommand ();
  57                         command.CommandType = CommandType.StoredProcedure;
  58                         command.CommandText = proc;
  59                         int result = -1;
  60                         try {
  61                                 result = command.ExecuteNonQuery ();
  62                         } catch {
  63                                 return -2;
  64                         }
  65                         return result;
  66                 }
  67
  68                 public static string GetRandomName (string prefix, int length)
  69                 {
  70                         StringBuilder s = new StringBuilder (prefix.Length + 1 + length);
  71                         s.Append (prefix);
  72                         s.Append ("_");
  73                         for (int i = 0; i < length; i++) {
  74                                 s.Append (random.Next (25) + 'A');
  75                         }
  76                         return s.ToString ();
  77                 }
  78         }
  79 }