mcs/class/System.Data.OracleClient/Test/System.Data.OracleClient.jvm/OracleConnection/IDBConnection_For_Oracle.cs

   1 //
   2 // Copyright (c) 2006 Mainsoft Co.
   3 //
   4 // Permission is hereby granted, free of charge, to any person obtaining
   5 // a copy of this software and associated documentation files (the
   6 // "Software"), to deal in the Software without restriction, including
   7 // without limitation the rights to use, copy, modify, merge, publish,
   8 // distribute, sublicense, and/or sell copies of the Software, and to
   9 // permit persons to whom the Software is furnished to do so, subject to
  10 // the following conditions:
  11 //
  12 // The above copyright notice and this permission notice shall be
  13 // included in all copies or substantial portions of the Software.
  14 //
  15 // THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
  16 // EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
  17 // MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
  18 // NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
  19 // LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
  20 // OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
  21 // WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  22 //
  23
  24 using System;
  25 using System.Data;
  26 using System.Data.OracleClient ;
  27
  28 using MonoTests.System.Data.Utils;
  29
  30
  31 using NUnit.Framework;
  32
  33 namespace MonoTests.System.Data.OracleClient
  34 {
  35         [TestFixture]
  36         class IDBConnection_For_Oracle : GHTBase
  37         {
  38                 string _ConnectionString = "";
  39                 [SetUp]
  40                 public void SetUp()
  41                 {
  42                         try
  43                         {
  44                                 _ConnectionString = MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString;
  45                         }
  46                         catch(Exception ex)
  47                         {
  48                                 EndCase(ex);
  49                         }
  50                 }
  51
  52                 [TearDown]
  53                 public void TearDown()
  54                 {
  55                 }
  56
  57                 public static void Main()
  58                 {
  59                         IDBConnection_For_Oracle tc = new IDBConnection_For_Oracle();
  60                         Exception exp = null;
  61                         try
  62                         {
  63                                 tc.BeginTest("IDBConnection_For_Oracle");
  64                                 tc.SetUp();
  65                                 tc.run();
  66                                 tc.TearDown();
  67                         }
  68                         catch(Exception ex){exp = ex;}
  69                         finally {tc.EndTest(exp);}
  70                 }
  71
  72                 [Test]
  73                 public void run()
  74                 {
  75                         Exception exp = null;
  76                         IDbConnection ICon = new OracleConnection();
  77
  78                         try
  79                         {
  80                                 BeginCase("check IDbConnection is null");
  81                                 Compare(ICon != null, true);
  82                         }
  83                         catch(Exception ex){exp = ex;}
  84                         finally{EndCase(exp); exp = null;}
  85
  86                         try
  87                         {
  88                                 BeginCase("check IDbConnection type");
  89                                 Compare(ICon.GetType().FullName ,typeof(OracleConnection).FullName);
  90                         }
  91                         catch(Exception ex){exp = ex;}
  92                         finally{EndCase(exp); exp = null;}
  93
  94                         ICon = new OracleConnection(_ConnectionString);
  95
  96                         try
  97                         {
  98                                 BeginCase("check IDbConnection connection string");
  99                                 Compare(ICon.ConnectionString ,_ConnectionString);
 100                         }
 101                         catch(Exception ex){exp = ex;}
 102                         finally{EndCase(exp); exp = null;}
 103
 104                         try
 105                         {
 106                                 BeginCase("check IDbConnection ConnectionTimeout");
 107                                 Compare(ICon.ConnectionTimeout ,15);
 108                         }
 109                         catch(Exception ex){exp = ex;}
 110                         finally{EndCase(exp); exp = null;}
 111
 112                         try
 113                         {
 114                                 BeginCase("check IDbConnection state - closed");
 115                                 Compare(ICon.State ,ConnectionState.Closed);
 116                         }
 117                         catch(Exception ex){exp = ex;}
 118                         finally{EndCase(exp); exp = null;}
 119
 120                         ICon.Open();
 121
 122                         try
 123                         {
 124                                 BeginCase("check IDbConnection - open");
 125                                 Compare(ICon.State ,ConnectionState.Open );
 126                         }
 127                         catch(Exception ex){exp = ex;}
 128                         finally{EndCase(exp); exp = null;}
 129
 130                         try
 131                         {
 132                                 BeginCase("check IDbConnection CreateCommand");
 133                                 IDbCommand cmd = ICon.CreateCommand();
 134                                 Compare(cmd.GetType().FullName ,typeof(OracleCommand).FullName);
 135                         }
 136                         catch(Exception ex){exp = ex;}
 137                         finally{EndCase(exp); exp = null;}
 138
 139                         if (ICon.State == ConnectionState.Open) ICon.Close();
 140
 141                 }
 142         }
 143
 144 }