OleDbConnection_Database.cs 2.9 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394
  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_Database : ADONetTesterClass
  32. {
  33. public static void Main()
  34. {
  35. OleDbConnection_Database tc = new OleDbConnection_Database();
  36. Exception exp = null;
  37. try
  38. {
  39. tc.BeginTest("OleDbConnection_Database");
  40. tc.run();
  41. }
  42. catch(Exception ex){exp = ex;}
  43. finally {tc.EndTest(exp);}
  44. }
  45. [Test]
  46. public void run()
  47. {
  48. Exception exp = null;
  49. OleDbConnection con = new OleDbConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString);
  50. //test does not apply to ORACLE,DB2,Sybase,Postgres
  51. if (ConnectedDataProvider.GetDbType(con) == DataBaseServer.Oracle) return;
  52. if (ConnectedDataProvider.GetDbType(con) == DataBaseServer.DB2) return;
  53. if (ConnectedDataProvider.GetDbType(con) == DataBaseServer.Sybase) return;
  54. if (ConnectedDataProvider.GetDbType(con) == DataBaseServer.PostgreSQL) return;
  55. //get the expected result from the connection string
  56. string[] arrCon = con.ConnectionString.Split(';');
  57. string result = null;
  58. for (int i=0; i < arrCon.Length; i++)
  59. if (arrCon[i].IndexOf("Initial Catalog") >= 0)
  60. {
  61. result = arrCon[i];
  62. break;
  63. }
  64. result = result.Substring(result.IndexOf('=')+1).Trim();
  65. try
  66. {
  67. BeginCase("check Database");
  68. Compare(con.Database , result);
  69. }
  70. catch(Exception ex){exp = ex;}
  71. finally{EndCase(exp); exp = null;}
  72. }
  73. //public TestClass():base(true){}
  74. //Activate this constructor to log Failures to a log file
  75. //public TestClass(System.IO.TextWriter tw):base(tw, false){}
  76. //Activate this constructor to log All to a log file
  77. //public TestClass(System.IO.TextWriter tw):base(tw, true){}
  78. //BY DEFAULT LOGGING IS DONE TO THE STANDARD OUTPUT ONLY FOR FAILURES
  79. }
  80. }