OleDbConnection_Close.cs 2.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  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. using System;
  24. using System.Data;
  25. using System.Data.OleDb ;
  26. using MonoTests.System.Data.Utils;
  27. using NUnit.Framework;
  28. namespace MonoTests.System.Data.OleDb
  29. {
  30. [TestFixture]
  31. public class OleDbConnection_Close : GHTBase
  32. {
  33. [SetUp]
  34. public void SetUp()
  35. {
  36. Exception exp = null;
  37. BeginCase("Setup");
  38. try
  39. {
  40. }
  41. catch(Exception ex) {exp = ex;}
  42. finally {EndCase(exp); exp = null;}
  43. }
  44. [TearDown]
  45. public void TearDown()
  46. {
  47. }
  48. public static void Main()
  49. {
  50. OleDbConnection_Close tc = new OleDbConnection_Close();
  51. Exception exp = null;
  52. try
  53. {
  54. tc.BeginTest("OleDbConnection_Close");
  55. tc.SetUp();
  56. tc.run();
  57. tc.TearDown();
  58. }
  59. catch(Exception ex){exp = ex;}
  60. finally {tc.EndTest(exp);}
  61. }
  62. [Test]
  63. public void run()
  64. {
  65. Exception exp = null;
  66. OleDbConnection con = new OleDbConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString);
  67. try
  68. {
  69. BeginCase("Close without open");
  70. con.Close();
  71. Compare(con.State , ConnectionState.Closed);
  72. }
  73. catch(Exception ex){exp = ex;}
  74. finally{EndCase(exp); exp = null;}
  75. con.Open();
  76. try
  77. {
  78. BeginCase("Close after open");
  79. con.Close();
  80. Compare(con.State , ConnectionState.Closed);
  81. }
  82. catch(Exception ex){exp = ex;}
  83. finally{EndCase(exp); exp = null;}
  84. //An application can call Close more than one time.
  85. //No exception is generated.
  86. try
  87. {
  88. BeginCase("Close again");
  89. con.Close();
  90. Compare(con.State , ConnectionState.Closed);
  91. }
  92. catch(Exception ex){exp = ex;}
  93. finally{EndCase(exp); exp = null;}
  94. if (con.State == ConnectionState.Open) con.Close();
  95. }
  96. }
  97. }