diff options
Diffstat (limited to 'mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/OleDbDataAdapter/OleDbDataAdapter_Fill_3.cs')
-rwxr-xr-x | mcs/class/System.Data/Test/ProviderTests/System.Data.OleDb.jvm/OleDbDataAdapter/OleDbDataAdapter_Fill_3.cs | 139 |
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 |