OleDbParameterCollection_Add.cs 2.4 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586
  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 OleDbParameterCollection_Add : ADONetTesterClass
  32. {
  33. public static void Main()
  34. {
  35. OleDbParameterCollection_Add tc = new OleDbParameterCollection_Add();
  36. Exception exp = null;
  37. try
  38. {
  39. tc.BeginTest("OleDbParameterCollection_Add");
  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. OleDbCommand cmd = new OleDbCommand();
  50. OleDbParameter param = cmd.Parameters.Add(new OleDbParameter("MyParam", "abcd"));
  51. try
  52. {
  53. BeginCase("check value");
  54. Compare(param.Value ,"abcd" );
  55. }
  56. catch(Exception ex){exp = ex;}
  57. finally{EndCase(exp); exp = null;}
  58. param = cmd.Parameters.Add("MyParam", OleDbType.VarChar, 50);
  59. try
  60. {
  61. BeginCase("check parameter type");
  62. Compare(param.GetType().FullName ,typeof(OleDbParameter).FullName );
  63. }
  64. catch(Exception ex){exp = ex;}
  65. finally{EndCase(exp); exp = null;}
  66. try
  67. {
  68. BeginCase("check parameter name");
  69. Compare(param.ParameterName ,"MyParam" );
  70. }
  71. catch(Exception ex){exp = ex;}
  72. finally{EndCase(exp); exp = null;}
  73. }
  74. }
  75. }