[pgsqlclient-checkins] pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source PGDataAdapterTest.cs,1.5,1.6

[<car...@us...>]

Update of /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source
In directory sc8-pr-cvs1:/tmp/cvs-serv17365

Modified Files:
	PGDataAdapterTest.cs 
Log Message:
Removed non standard constructor from PGParameter and added a new one.

Index: PGDataAdapterTest.cs
===================================================================
RCS file: /cvsroot/pgsqlclient/pgsqlclient/PostgreSql.Data.PGSqlClient.UnitTests/source/PGDataAdapterTest.cs,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** PGDataAdapterTest.cs	26 Jul 2003 12:30:31 -0000	1.5
--- PGDataAdapterTest.cs	27 Jul 2003 21:19:39 -0000	1.6
***************
*** 33,37 ****
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@date_field", PGDbType.Date, "date_field").Value = DateTime.Now;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 33,37 ----
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@date_field", PGDbType.Date, 4, "date_field").Value = DateTime.Now;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 74,78 ****
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@date_field", PGDbType.Date, "date_field").Value = DateTime.Now;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 74,78 ----
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@date_field", PGDbType.Date, 4, "date_field").Value = DateTime.Now;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 130,134 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 1;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 130,134 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 1;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 154,158 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 10;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 154,158 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 10;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 178,182 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 40;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 178,182 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 40;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 195,199 ****
  
  			command = new PGCommand("SELECT int2_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 40;
  
  			short val = (short)command.ExecuteScalar();
--- 195,199 ----
  
  			command = new PGCommand("SELECT int2_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 40;
  
  			short val = (short)command.ExecuteScalar();
***************
*** 209,213 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 20;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 209,213 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 20;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 226,230 ****
  
  			command = new PGCommand("SELECT int8_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 20;
  
  			long val = (long)command.ExecuteScalar();
--- 226,230 ----
  
  			command = new PGCommand("SELECT int8_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 20;
  
  			long val = (long)command.ExecuteScalar();
***************
*** 240,244 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 50;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 240,244 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 50;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 257,261 ****
  
  			command = new PGCommand("SELECT double_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 50;
  
  			double val = (double)command.ExecuteScalar();
--- 257,261 ----
  
  			command = new PGCommand("SELECT double_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 50;
  
  			double val = (double)command.ExecuteScalar();
***************
*** 271,275 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 27;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 271,275 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 27;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 288,292 ****
  
  			command = new PGCommand("SELECT money_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 27;
  
  			float val = (float)command.ExecuteScalar();
--- 288,292 ----
  
  			command = new PGCommand("SELECT money_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 27;
  
  			float val = (float)command.ExecuteScalar();
***************
*** 302,306 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 60;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 302,306 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 60;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 319,323 ****
  
  			command = new PGCommand("SELECT numeric_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 60;
  
  			decimal val = (decimal)command.ExecuteScalar();
--- 319,323 ----
  
  			command = new PGCommand("SELECT numeric_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 60;
  
  			decimal val = (decimal)command.ExecuteScalar();
***************
*** 336,340 ****
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 70;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 336,340 ----
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 70;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 355,359 ****
  
  			command = new PGCommand("SELECT date_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 70;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
--- 355,359 ----
  
  			command = new PGCommand("SELECT date_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 70;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 371,375 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 80;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 371,375 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 80;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 390,394 ****
  
  			command = new PGCommand("SELECT time_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 80;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
--- 390,394 ----
  
  			command = new PGCommand("SELECT time_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 80;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 406,410 ****
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 90;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 406,410 ----
  			PGDataAdapter	adapter		= new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 90;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
***************
*** 425,429 ****
  
  			command = new PGCommand("SELECT timestamp_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 90;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
--- 425,429 ----
  
  			command = new PGCommand("SELECT timestamp_field FROM public.test_table WHERE int4_field = @int4_field", Connection);
! 			command.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 90;
  
  			DateTime val = (DateTime)command.ExecuteScalar();
***************
*** 444,448 ****
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, "int4_field").Value = 35;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);
--- 444,448 ----
  			PGDataAdapter	adapter = new PGDataAdapter(command);
  
! 			adapter.SelectCommand.Parameters.Add("@int4_field", PGDbType.Int4, 4, "int4_field").Value = 35;
  			
  			PGCommandBuilder builder = new PGCommandBuilder(adapter);