Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/mono/mono.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/OleDbDataAdapter/OleDbDataAdapter_Fill_3.cs')
-rwxr-xr-xmcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/OleDbDataAdapter/OleDbDataAdapter_Fill_3.cs139
1 files changed, 0 insertions, 139 deletions
diff --git a/mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/OleDbDataAdapter/OleDbDataAdapter_Fill_3.cs b/mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/OleDbDataAdapter/OleDbDataAdapter_Fill_3.cs
deleted file mode 100755
index ad9446cfd50..00000000000
--- a/mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/OleDbDataAdapter/OleDbDataAdapter_Fill_3.cs
+++ /dev/null
@@ -1,139 +0,0 @@
-//
-// Copyright (c) 2006 Mainsoft Co.
-//
-// Permission is hereby granted, free of charge, to any person obtaining
-// a copy of this software and associated documentation files (the
-// "Software"), to deal in the Software without restriction, including
-// without limitation the rights to use, copy, modify, merge, publish,
-// distribute, sublicense, and/or sell copies of the Software, and to
-// permit persons to whom the Software is furnished to do so, subject to
-// the following conditions:
-//
-// The above copyright notice and this permission notice shall be
-// included in all copies or substantial portions of the Software.
-//
-// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
-// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
-// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
-// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
-// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
-// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
-// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
-//
-
-using System;
-using System.Data;
-using System.Data.OleDb;
-
-using MonoTests.System.Data.Utils;
-
-
-using NUnit.Framework;
-
-namespace MonoTests.System.Data.OleDb
-{
- [TestFixture]
- public class OleDbDataAdapter_Fill_3: ADONetTesterClass
- {
- public static void Main()
- {
- OleDbDataAdapter_Fill_3 tc = new OleDbDataAdapter_Fill_3();
- Exception exp = null;
- try
- {
- tc.BeginTest("OleDbDataAdapter_Fill_3");
- tc.run();
- }
- catch(Exception ex){exp = ex;}
- finally {tc.EndTest(exp);}
- }
-
- [Test]
- public void run()
- {
- Exception exp = null;
-
- //in DB2 when trying to fill an empty table - no table is loaded
- OleDbConnection conn = new OleDbConnection(MonoTests.System.Data.Utils.ConnectedDataProvider.ConnectionString);
- OleDbDataAdapter oleDBda = new OleDbDataAdapter();
- oleDBda.SelectCommand = new OleDbCommand("Select * from GH_EMPTYTABLE",conn);
-
- DataSet ds = new DataSet();
- oleDBda.Fill(ds);
-
- try
- {
- BeginCase("Table count - fill with SP");
- Compare(ds.Tables.Count ,1 );
- }
- catch(Exception ex) {exp = ex;}
- finally {EndCase(exp); exp = null;}
-
- //add for bug #2508 - OLEDBDataAdapter.Fill fills only the 1st result set, reported from an evaluation
- if (ConnectedDataProvider.GetDbType(oleDBda.SelectCommand.Connection) == DataBaseServer.SQLServer)
- //multiple commands can not be done with Oracle or DB2
- {
-
-
- //get excpected results
- if (oleDBda.SelectCommand.Connection.State != ConnectionState.Open)
- {
- oleDBda.SelectCommand.Connection.Open();
- }
- OleDbCommand cmd = new OleDbCommand("",oleDBda.SelectCommand.Connection);
- cmd.CommandText = "Select count(*) from Customers";
- int TblResult0 = (int)cmd.ExecuteScalar();
- cmd.CommandText = "Select count(*) from Categories";
- int TblResult1 = (int)cmd.ExecuteScalar();
- cmd.CommandText = "Select count(*) from Region";
- int TblResult2 = (int)cmd.ExecuteScalar();
- if (oleDBda.SelectCommand.Connection.State != ConnectionState.Closed)
- {
- oleDBda.SelectCommand.Connection.Close();
- }
-
-
- oleDBda.SelectCommand.CommandText = "Select * from Customers; " +
- "Select * from Categories; " +
- "Select * from Region";
- ds = new DataSet();
- oleDBda.Fill(ds);
-
- try
- {
- BeginCase("Table count - Fill with query");
- Compare(ds.Tables.Count ,3 );
- }
- catch(Exception ex) {exp = ex;}
- finally {EndCase(exp); exp = null;}
-
- try
- {
- BeginCase("Table 0 rows count");
- Compare(ds.Tables[0].Rows.Count ,TblResult0 );
- }
- catch(Exception ex) {exp = ex;}
- finally {EndCase(exp); exp = null;}
-
- try
- {
- BeginCase("Table 1 rows count");
- Compare(ds.Tables[1].Rows.Count ,TblResult1 );
- }
- catch(Exception ex) {exp = ex;}
- finally {EndCase(exp); exp = null;}
-
- try
- {
- BeginCase("Table 2 rows count");
- Compare(ds.Tables[2].Rows.Count ,TblResult2 );
- }
- catch(Exception ex) {exp = ex;}
- finally {EndCase(exp); exp = null;}
-
- }
-
-
- }
- }
-} \ No newline at end of file