1Starting test 'TvpTest' 2Starting Test using AsyncDebugScope 3Tests using AsyncDebugScope are only supported in Debug mode! 4Finished Test using AsyncDebugScope 5Test immediate cancel for binary stream 6PASS: Task is cancelled 7Test immediate cancel for text stream 8PASS: Task is cancelled 9Test immediate cancel for xml stream 10PASS: Task is cancelled 11Test command preparation PASS 12Test reuse of command after cancel 13PASS 14Test reuse of command after cancel 15PASS 16Test reuse of command after cancel 17PASS 18+++++++ Iteration 0 ++++++++ 19------IEnumerable<SqlDataRecord>--------- 20Matches = 168 21------DbDataReader--------- 22Matches = 168 23------DataTables--------- 24Matches = 14 25SqlException: String or binary data would be truncated. 26The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 27The statement has been terminated. 28SqlException: String or binary data would be truncated. 29The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 30The statement has been terminated. 31SqlException: String or binary data would be truncated. 32The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 33The statement has been terminated. 34SqlException: String or binary data would be truncated. 35The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 36The statement has been terminated. 37SqlException: String or binary data would be truncated. 38The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 39The statement has been terminated. 40SqlException: String or binary data would be truncated. 41The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 42The statement has been terminated. 43SqlException: String or binary data would be truncated. 44The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 45The statement has been terminated. 46SqlException: String or binary data would be truncated. 47The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 48The statement has been terminated. 49Matches = 14 50+++++++ Iteration 1 ++++++++ 51------IEnumerable<SqlDataRecord>--------- 52Matches = 168 53------DbDataReader--------- 54Matches = 168 55------DataTables--------- 56Matches = 14 57SqlException: String or binary data would be truncated. 58The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 59The statement has been terminated. 60SqlException: String or binary data would be truncated. 61The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 62The statement has been terminated. 63SqlException: String or binary data would be truncated. 64The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 65The statement has been terminated. 66SqlException: String or binary data would be truncated. 67The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 68The statement has been terminated. 69SqlException: String or binary data would be truncated. 70The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 71The statement has been terminated. 72SqlException: String or binary data would be truncated. 73The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 74The statement has been terminated. 75SqlException: String or binary data would be truncated. 76The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 77The statement has been terminated. 78SqlException: String or binary data would be truncated. 79The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 80The statement has been terminated. 81Matches = 14 82+++++++ Iteration 2 ++++++++ 83------IEnumerable<SqlDataRecord>--------- 84Matches = 168 85------DbDataReader--------- 86Matches = 168 87------DataTables--------- 88Matches = 14 89SqlException: String or binary data would be truncated. 90The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 91The statement has been terminated. 92SqlException: String or binary data would be truncated. 93The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 94The statement has been terminated. 95Matches = 28 96SqlException: String or binary data would be truncated. 97The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 98The statement has been terminated. 99SqlException: String or binary data would be truncated. 100The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 101The statement has been terminated. 102Matches = 14 103SqlException: String or binary data would be truncated. 104The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 105The statement has been terminated. 106SqlException: String or binary data would be truncated. 107The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 108The statement has been terminated. 109Matches = 14 110+++++++ Iteration 3 ++++++++ 111------IEnumerable<SqlDataRecord>--------- 112Matches = 168 113------DbDataReader--------- 114Matches = 168 115------DataTables--------- 116Matches = 14 117SqlException: String or binary data would be truncated. 118The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 119The statement has been terminated. 120SqlException: String or binary data would be truncated. 121The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 122The statement has been terminated. 123SqlException: String or binary data would be truncated. 124The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 125The statement has been terminated. 126SqlException: String or binary data would be truncated. 127The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 128The statement has been terminated. 129SqlException: String or binary data would be truncated. 130The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 131The statement has been terminated. 132Matches = 14 133SqlException: String or binary data would be truncated. 134The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 135The statement has been terminated. 136SqlException: String or binary data would be truncated. 137The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 138The statement has been terminated. 139Matches = 14 140+++++++ Iteration 4 ++++++++ 141------IEnumerable<SqlDataRecord>--------- 142Matches = 168 143------DbDataReader--------- 144Matches = 168 145------DataTables--------- 146Matches = 14 147SqlException: String or binary data would be truncated. 148The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 149The statement has been terminated. 150SqlException: String or binary data would be truncated. 151The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 152The statement has been terminated. 153SqlException: String or binary data would be truncated. 154The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 155The statement has been terminated. 156SqlException: String or binary data would be truncated. 157The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 158The statement has been terminated. 159SqlException: String or binary data would be truncated. 160The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 161The statement has been terminated. 162Matches = 14 163SqlException: String or binary data would be truncated. 164The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 165The statement has been terminated. 166SqlException: String or binary data would be truncated. 167The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 168The statement has been terminated. 169Matches = 14 170+++++++ Iteration 5 ++++++++ 171------IEnumerable<SqlDataRecord>--------- 172Matches = 168 173------DbDataReader--------- 174Matches = 168 175------DataTables--------- 176Matches = 14 177SqlException: String or binary data would be truncated. 178The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 179The statement has been terminated. 180SqlException: String or binary data would be truncated. 181The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 182The statement has been terminated. 183Matches = 28 184SqlException: String or binary data would be truncated. 185The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 186The statement has been terminated. 187SqlException: String or binary data would be truncated. 188The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 189The statement has been terminated. 190Matches = 14 191SqlException: String or binary data would be truncated. 192The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 193The statement has been terminated. 194SqlException: String or binary data would be truncated. 195The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 196The statement has been terminated. 197Matches = 14 198+++++++ Iteration 6 ++++++++ 199SqlException creating objects: 1701 200SqlException dropping objects: 3701 201+++++++ Iteration 7 ++++++++ 202------IEnumerable<SqlDataRecord>--------- 203Matches = 168 204------DbDataReader--------- 205Matches = 168 206------DataTables--------- 207Matches = 14 208SqlException: String or binary data would be truncated. 209The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 210The statement has been terminated. 211SqlException: String or binary data would be truncated. 212The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 213The statement has been terminated. 214Matches = 28 215SqlException: String or binary data would be truncated. 216The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 217The statement has been terminated. 218SqlException: String or binary data would be truncated. 219The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 220The statement has been terminated. 221Matches = 14 222SqlException: String or binary data would be truncated. 223The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 224The statement has been terminated. 225SqlException: String or binary data would be truncated. 226The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 227The statement has been terminated. 228Matches = 14 229+++++++ Iteration 8 ++++++++ 230------IEnumerable<SqlDataRecord>--------- 231Matches = 168 232------DbDataReader--------- 233Matches = 168 234------DataTables--------- 235Matches = 14 236SqlException: String or binary data would be truncated. 237The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 238The statement has been terminated. 239SqlException: String or binary data would be truncated. 240The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 241The statement has been terminated. 242Matches = 28 243SqlException: String or binary data would be truncated. 244The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 245The statement has been terminated. 246SqlException: String or binary data would be truncated. 247The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 248The statement has been terminated. 249Matches = 14 250SqlException: String or binary data would be truncated. 251The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 252The statement has been terminated. 253SqlException: String or binary data would be truncated. 254The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 255The statement has been terminated. 256Matches = 14 257+++++++ Iteration 9 ++++++++ 258------IEnumerable<SqlDataRecord>--------- 259Matches = 168 260------DbDataReader--------- 261Matches = 168 262------DataTables--------- 263Matches = 14 264SqlException: String or binary data would be truncated. 265The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 266The statement has been terminated. 267SqlException: String or binary data would be truncated. 268The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 269The statement has been terminated. 270SqlException: String or binary data would be truncated. 271The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 272The statement has been terminated. 273SqlException: String or binary data would be truncated. 274The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 275The statement has been terminated. 276SqlException: String or binary data would be truncated. 277The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 278The statement has been terminated. 279SqlException: String or binary data would be truncated. 280The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 281The statement has been terminated. 282SqlException: String or binary data would be truncated. 283The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 284The statement has been terminated. 285SqlException: String or binary data would be truncated. 286The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 287The statement has been terminated. 288Matches = 14 289+++++++ Iteration 10 ++++++++ 290------IEnumerable<SqlDataRecord>--------- 291Matches = 168 292------DbDataReader--------- 293Matches = 168 294------DataTables--------- 295Matches = 14 296SqlException: String or binary data would be truncated. 297The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 298The statement has been terminated. 299SqlException: String or binary data would be truncated. 300The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 301The statement has been terminated. 302SqlException: String or binary data would be truncated. 303The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 304The statement has been terminated. 305SqlException: String or binary data would be truncated. 306The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 307The statement has been terminated. 308SqlException: String or binary data would be truncated. 309The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 310The statement has been terminated. 311SqlException: String or binary data would be truncated. 312The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 313The statement has been terminated. 314SqlException: String or binary data would be truncated. 315The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 316The statement has been terminated. 317SqlException: String or binary data would be truncated. 318The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 319The statement has been terminated. 320Matches = 14 321+++++++ Iteration 11 ++++++++ 322------IEnumerable<SqlDataRecord>--------- 323Matches = 168 324------DbDataReader--------- 325Matches = 168 326------DataTables--------- 327Matches = 14 328SqlException: String or binary data would be truncated. 329The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 330The statement has been terminated. 331SqlException: String or binary data would be truncated. 332The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 333The statement has been terminated. 334Matches = 28 335SqlException: String or binary data would be truncated. 336The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 337The statement has been terminated. 338SqlException: String or binary data would be truncated. 339The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 340The statement has been terminated. 341Matches = 14 342SqlException: String or binary data would be truncated. 343The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 344The statement has been terminated. 345SqlException: String or binary data would be truncated. 346The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 347The statement has been terminated. 348Matches = 14 349+++++++ Iteration 12 ++++++++ 350------IEnumerable<SqlDataRecord>--------- 351Matches = 168 352------DbDataReader--------- 353Matches = 168 354------DataTables--------- 355Matches = 14 356SqlException: String or binary data would be truncated. 357The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 358The statement has been terminated. 359SqlException: String or binary data would be truncated. 360The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 361The statement has been terminated. 362SqlException: String or binary data would be truncated. 363The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 364The statement has been terminated. 365SqlException: String or binary data would be truncated. 366The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 367The statement has been terminated. 368SqlException: String or binary data would be truncated. 369The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 370The statement has been terminated. 371Matches = 14 372SqlException: String or binary data would be truncated. 373The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 374The statement has been terminated. 375SqlException: String or binary data would be truncated. 376The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 377The statement has been terminated. 378Matches = 14 379+++++++ Iteration 13 ++++++++ 380------IEnumerable<SqlDataRecord>--------- 381Matches = 168 382------DbDataReader--------- 383Matches = 168 384------DataTables--------- 385Matches = 14 386SqlException: String or binary data would be truncated. 387The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 388The statement has been terminated. 389SqlException: String or binary data would be truncated. 390The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 391The statement has been terminated. 392SqlException: String or binary data would be truncated. 393The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 394The statement has been terminated. 395SqlException: String or binary data would be truncated. 396The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 397The statement has been terminated. 398SqlException: String or binary data would be truncated. 399The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 400The statement has been terminated. 401Matches = 14 402SqlException: String or binary data would be truncated. 403The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 404The statement has been terminated. 405SqlException: String or binary data would be truncated. 406The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 407The statement has been terminated. 408Matches = 14 409+++++++ Iteration 14 ++++++++ 410SqlException creating objects: 1701 411SqlException dropping objects: 3701 412+++++++ Iteration 15 ++++++++ 413SqlException creating objects: 1701 414SqlException dropping objects: 3701 415+++++++ Iteration 16 ++++++++ 416------IEnumerable<SqlDataRecord>--------- 417Matches = 168 418------DbDataReader--------- 419Matches = 168 420------DataTables--------- 421Matches = 14 422SqlException: String or binary data would be truncated. 423The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 424The statement has been terminated. 425SqlException: String or binary data would be truncated. 426The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 427The statement has been terminated. 428Matches = 28 429SqlException: String or binary data would be truncated. 430The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 431The statement has been terminated. 432SqlException: String or binary data would be truncated. 433The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 434The statement has been terminated. 435Matches = 14 436SqlException: String or binary data would be truncated. 437The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 438The statement has been terminated. 439SqlException: String or binary data would be truncated. 440The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 441The statement has been terminated. 442Matches = 14 443+++++++ Iteration 17 ++++++++ 444------IEnumerable<SqlDataRecord>--------- 445Matches = 168 446------DbDataReader--------- 447Matches = 168 448------DataTables--------- 449Matches = 14 450SqlException: String or binary data would be truncated. 451The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 452The statement has been terminated. 453SqlException: String or binary data would be truncated. 454The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 455The statement has been terminated. 456Matches = 28 457SqlException: String or binary data would be truncated. 458The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 459The statement has been terminated. 460SqlException: String or binary data would be truncated. 461The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 462The statement has been terminated. 463Matches = 14 464SqlException: String or binary data would be truncated. 465The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 466The statement has been terminated. 467SqlException: String or binary data would be truncated. 468The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 469The statement has been terminated. 470Matches = 14 471+++++++ Iteration 18 ++++++++ 472------IEnumerable<SqlDataRecord>--------- 473Matches = 168 474------DbDataReader--------- 475Matches = 168 476------DataTables--------- 477Matches = 14 478SqlException: String or binary data would be truncated. 479The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 480The statement has been terminated. 481SqlException: String or binary data would be truncated. 482The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 483The statement has been terminated. 484SqlException: String or binary data would be truncated. 485The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 486The statement has been terminated. 487SqlException: String or binary data would be truncated. 488The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 489The statement has been terminated. 490SqlException: String or binary data would be truncated. 491The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 492The statement has been terminated. 493SqlException: String or binary data would be truncated. 494The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 495The statement has been terminated. 496SqlException: String or binary data would be truncated. 497The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 498The statement has been terminated. 499SqlException: String or binary data would be truncated. 500The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 501The statement has been terminated. 502Matches = 14 503+++++++ Iteration 19 ++++++++ 504------IEnumerable<SqlDataRecord>--------- 505Matches = 168 506------DbDataReader--------- 507Matches = 168 508------DataTables--------- 509Matches = 14 510SqlException: String or binary data would be truncated. 511The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 512The statement has been terminated. 513SqlException: String or binary data would be truncated. 514The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 515The statement has been terminated. 516SqlException: String or binary data would be truncated. 517The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 518The statement has been terminated. 519SqlException: String or binary data would be truncated. 520The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 521The statement has been terminated. 522SqlException: String or binary data would be truncated. 523The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 524The statement has been terminated. 525SqlException: String or binary data would be truncated. 526The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 527The statement has been terminated. 528SqlException: String or binary data would be truncated. 529The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 530The statement has been terminated. 531SqlException: String or binary data would be truncated. 532The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 533The statement has been terminated. 534Matches = 14 535+++++++ Iteration 20 ++++++++ 536------IEnumerable<SqlDataRecord>--------- 537Matches = 168 538------DbDataReader--------- 539Matches = 168 540------DataTables--------- 541Matches = 14 542Matches = 14 543SqlException: String or binary data would be truncated. 544The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 545The statement has been terminated. 546Matches = 28 547Matches = 14 548SqlException: String or binary data would be truncated. 549The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 550The statement has been terminated. 551Matches = 14 552Matches = 14 553SqlException: String or binary data would be truncated. 554The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 555The statement has been terminated. 556Matches = 14 557+++++++ Iteration 21 ++++++++ 558------IEnumerable<SqlDataRecord>--------- 559Matches = 168 560------DbDataReader--------- 561Matches = 168 562------DataTables--------- 563Matches = 14 564Matches = 14 565SqlException: String or binary data would be truncated. 566The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 567The statement has been terminated. 568SqlException: String or binary data would be truncated. 569The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 570The statement has been terminated. 571Matches = 14 572SqlException: String or binary data would be truncated. 573The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 574The statement has been terminated. 575Matches = 14 576SqlException: String or binary data would be truncated. 577The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 578The statement has been terminated. 579SqlException: String or binary data would be truncated. 580The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 581The statement has been terminated. 582Matches = 14 583+++++++ Iteration 22 ++++++++ 584SqlException creating objects: 1701 585SqlException dropping objects: 3701 586+++++++ Iteration 23 ++++++++ 587SqlException creating objects: 1701 588SqlException dropping objects: 3701 589+++++++ Iteration 24 ++++++++ 590SqlException creating objects: 1701 591SqlException dropping objects: 3701 592+++++++ Iteration 25 ++++++++ 593------IEnumerable<SqlDataRecord>--------- 594Failed Row[0]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 595Failed Row[1]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 596Failed Row[4]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 597Failed Row[5]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 598Failed Row[8]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 599Failed Row[9]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 600Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 601 Row=0, Column=5 602Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 603 Row=1, Column=5 604Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 605 Row=4, Column=5 606Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 607 Row=5, Column=5 608Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 609 Row=8, Column=5 610Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 611 Row=9, Column=5 612Matches = 162 613------DbDataReader--------- 614Failed Row[0]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 615Failed Row[1]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 616Failed Row[4]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 617Failed Row[5]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 618Failed Row[8]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 619Failed Row[9]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 620Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 621 Row=0, Column=5 622Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 623 Row=1, Column=5 624Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 625 Row=4, Column=5 626Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 627 Row=5, Column=5 628Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 629 Row=8, Column=5 630Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 631 Row=9, Column=5 632Matches = 162 633------DataTables--------- 634SqlException: The conversion of a datetime2 data type to a smalldatetime data type resulted in an out-of-range value. 635The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 636The statement has been terminated. 637SqlException: String or binary data would be truncated. 638The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 639The statement has been terminated. 640SqlException: String or binary data would be truncated. 641The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 642The statement has been terminated. 643Matches = 28 644SqlException: String or binary data would be truncated. 645The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 646The statement has been terminated. 647SqlException: String or binary data would be truncated. 648The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 649The statement has been terminated. 650Matches = 14 651SqlException: String or binary data would be truncated. 652The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 653The statement has been terminated. 654SqlException: String or binary data would be truncated. 655The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 656The statement has been terminated. 657Matches = 14 658+++++++ Iteration 26 ++++++++ 659------IEnumerable<SqlDataRecord>--------- 660Matches = 168 661------DbDataReader--------- 662Matches = 168 663------DataTables--------- 664Matches = 14 665SqlException: String or binary data would be truncated. 666The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 667The statement has been terminated. 668SqlException: String or binary data would be truncated. 669The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 670The statement has been terminated. 671Matches = 28 672SqlException: String or binary data would be truncated. 673The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 674The statement has been terminated. 675SqlException: String or binary data would be truncated. 676The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 677The statement has been terminated. 678Matches = 14 679SqlException: String or binary data would be truncated. 680The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 681The statement has been terminated. 682SqlException: String or binary data would be truncated. 683The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 684The statement has been terminated. 685Matches = 14 686+++++++ Iteration 27 ++++++++ 687------IEnumerable<SqlDataRecord>--------- 688Failed Row[0]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 689Failed Row[1]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 690Failed Row[1]Col[9] = -922337203685477: SqlDbType.SmallMoney overflow. Value '-922337203685477.0000' is out of range. Must be between -214,748.3648 and 214,748.3647. 691Failed Row[2]Col[9] = 922337203685477.5807: SqlDbType.SmallMoney overflow. Value '922337203685477.5807' is out of range. Must be between -214,748.3648 and 214,748.3647. 692Failed Row[4]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 693Failed Row[5]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 694Failed Row[8]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 695Failed Row[9]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 696Failed Row[10]Col[9] = -922337203685477: SqlDbType.SmallMoney overflow. Value '-922337203685477.0000' is out of range. Must be between -214,748.3648 and 214,748.3647. 697Failed Row[11]Col[9] = 922337203685477.5807: SqlDbType.SmallMoney overflow. Value '922337203685477.5807' is out of range. Must be between -214,748.3648 and 214,748.3647. 698Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 699 Row=0, Column=5 700Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 701 Row=1, Column=5 702Mismatch: Source = -922337203685477, result = , metadata=SteAttributeKey=SmallMoney 703 Row=1, Column=9 704Mismatch: Source = 922337203685477.5807, result = , metadata=SteAttributeKey=SmallMoney 705 Row=2, Column=9 706Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 707 Row=4, Column=5 708Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 709 Row=5, Column=5 710Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 711 Row=8, Column=5 712Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 713 Row=9, Column=5 714Mismatch: Source = -922337203685477, result = , metadata=SteAttributeKey=SmallMoney 715 Row=10, Column=9 716Mismatch: Source = 922337203685477.5807, result = , metadata=SteAttributeKey=SmallMoney 717 Row=11, Column=9 718Matches = 158 719------DbDataReader--------- 720Failed Row[0]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 721Failed Row[1]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 722Failed Row[1]Col[9] = -922337203685477: SqlDbType.SmallMoney overflow. Value '-922337203685477.0000' is out of range. Must be between -214,748.3648 and 214,748.3647. 723Failed Row[2]Col[9] = 922337203685477.5807: SqlDbType.SmallMoney overflow. Value '922337203685477.5807' is out of range. Must be between -214,748.3648 and 214,748.3647. 724Failed Row[4]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 725Failed Row[5]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 726Failed Row[8]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 727Failed Row[9]Col[5] = 1/1/1753 12:00:00 AM: Invalid value for this metadata. 728Failed Row[10]Col[9] = -922337203685477: SqlDbType.SmallMoney overflow. Value '-922337203685477.0000' is out of range. Must be between -214,748.3648 and 214,748.3647. 729Failed Row[11]Col[9] = 922337203685477.5807: SqlDbType.SmallMoney overflow. Value '922337203685477.5807' is out of range. Must be between -214,748.3648 and 214,748.3647. 730Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 731 Row=0, Column=5 732Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 733 Row=1, Column=5 734Mismatch: Source = -922337203685477, result = , metadata=SteAttributeKey=SmallMoney 735 Row=1, Column=9 736Mismatch: Source = 922337203685477.5807, result = , metadata=SteAttributeKey=SmallMoney 737 Row=2, Column=9 738Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 739 Row=4, Column=5 740Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 741 Row=5, Column=5 742Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 743 Row=8, Column=5 744Mismatch: Source = 1/1/1753 12:00:00 AM, result = , metadata=SteAttributeKey=SmallDateTime 745 Row=9, Column=5 746Mismatch: Source = -922337203685477, result = , metadata=SteAttributeKey=SmallMoney 747 Row=10, Column=9 748Mismatch: Source = 922337203685477.5807, result = , metadata=SteAttributeKey=SmallMoney 749 Row=11, Column=9 750Matches = 158 751------DataTables--------- 752SqlException: The conversion of a datetime2 data type to a smalldatetime data type resulted in an out-of-range value. 753The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 754The statement has been terminated. 755SqlException: String or binary data would be truncated. 756The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 757The statement has been terminated. 758SqlException: String or binary data would be truncated. 759The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 760The statement has been terminated. 761SqlException: String or binary data would be truncated. 762The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 763The statement has been terminated. 764SqlException: String or binary data would be truncated. 765The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 766The statement has been terminated. 767SqlException: String or binary data would be truncated. 768The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 769The statement has been terminated. 770SqlException: String or binary data would be truncated. 771The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 772The statement has been terminated. 773SqlException: String or binary data would be truncated. 774The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 775The statement has been terminated. 776SqlException: String or binary data would be truncated. 777The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 778The statement has been terminated. 779SqlException: Arithmetic overflow error converting numeric to data type smallmoney. 780The data for table-valued parameter "@tvp" doesn't conform to the table type of the parameter. 781The statement has been terminated. 782------- Sort order + uniqueness #1: simple ------- 783------------- 7840 Z-value 3/1/2000 12:00:00 AM 5 7851 X-value 1/1/2000 12:00:00 AM 7 786 787------------- 788------- Sort order + uniqueness #2: mixed order ------- 789------------- 7904 X-value 1/1/2000 12:00:00 AM 3 7915 X-value 3/1/2000 12:00:00 AM 3 792 793------------- 794------- default column #1: outer subset ------- 795------------- 796-1 Y-value 1/1/2000 12:00:00 AM -1 797-1 Z-value 1/1/2000 12:00:00 AM -1 798 799------------- 800------- default column #1: middle subset ------- 801------------- 8024 DEFUALT 1/1/2006 12:00:00 AM 3 8035 DEFUALT 1/1/2006 12:00:00 AM 3 804 805------------- 806------- default column #1: all ------- 807------------- 808-1 DEFUALT 1/1/2006 12:00:00 AM -1 809-1 DEFUALT 1/1/2006 12:00:00 AM -1 810 811------------- 812 813Starting test 'SqlVariantParam' 814SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlSingle:real 815SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlSingle:real 816SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlSingle:real 817SendVariantParam -> System.Data.SqlTypes.SqlSingle:real 818SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlSingle:real 819SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlSingle:real 820SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlSingle:real 821SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlSingle:real 822SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlSingle:real 823SendVariantParam -> System.Data.SqlTypes.SqlSingle:real 824SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlSingle:real 825SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlSingle:real 826SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlString:nvarchar 827SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlString:nvarchar 828SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlString:nvarchar 829SendVariantParam -> System.Data.SqlTypes.SqlString:nvarchar 830SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlString:nvarchar 831SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlString:nvarchar 832SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlDouble:float 833SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlDouble:float 834SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlDouble:float 835SendVariantParam -> System.Data.SqlTypes.SqlDouble:float 836SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlDouble:float 837SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlDouble:float 838SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlBinary:varbinary 839SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlBinary:varbinary 840SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlBinary:varbinary 841SendVariantParam -> System.Data.SqlTypes.SqlBinary:varbinary 842SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlBinary:varbinary 843SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlBinary:varbinary 844SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlGuid:uniqueidentifier 845SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlGuid:uniqueidentifier 846SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlGuid:uniqueidentifier 847SendVariantParam -> System.Data.SqlTypes.SqlGuid:uniqueidentifier 848SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlGuid:uniqueidentifier 849SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlGuid:uniqueidentifier 850SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlBoolean:bit 851SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlBoolean:bit 852SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlBoolean:bit 853SendVariantParam -> System.Data.SqlTypes.SqlBoolean:bit 854SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlBoolean:bit 855SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlBoolean:bit 856SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlBoolean:bit 857SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlBoolean:bit 858SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlBoolean:bit 859SendVariantParam -> System.Data.SqlTypes.SqlBoolean:bit 860SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlBoolean:bit 861SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlBoolean:bit 862SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlByte:tinyint 863SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlByte:tinyint 864SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlByte:tinyint 865SendVariantParam -> System.Data.SqlTypes.SqlByte:tinyint 866SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlByte:tinyint 867SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlByte:tinyint 868SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlInt16:smallint 869SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlInt16:smallint 870SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlInt16:smallint 871SendVariantParam -> System.Data.SqlTypes.SqlInt16:smallint 872SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlInt16:smallint 873SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlInt16:smallint 874SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlInt32:int 875SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlInt32:int 876SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlInt32:int 877SendVariantParam -> System.Data.SqlTypes.SqlInt32:int 878SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlInt32:int 879SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlInt32:int 880SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlInt64:bigint 881SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlInt64:bigint 882SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlInt64:bigint 883SendVariantParam -> System.Data.SqlTypes.SqlInt64:bigint 884SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlInt64:bigint 885SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlInt64:bigint 886SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlDecimal:numeric 887SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlDecimal:numeric 888SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlDecimal:numeric 889SendVariantParam -> System.Data.SqlTypes.SqlDecimal:numeric 890SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlDecimal:numeric 891SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlDecimal:numeric 892SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlDateTime:datetime 893SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlDateTime:datetime 894SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlDateTime:datetime 895SendVariantParam -> System.Data.SqlTypes.SqlDateTime:datetime 896SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlDateTime:datetime 897SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlDateTime:datetime 898SendVariantBulkCopy[SqlDataReader] -> System.Data.SqlTypes.SqlDecimal:numeric 899 --> ERROR: Expected type System.Data.SqlTypes.SqlMoney does not match actual type System.Data.SqlTypes.SqlDecimal 900 --> ERROR: Expected base type money does not match actual base type numeric 901SendVariantBulkCopy[DataTable] -> System.Data.SqlTypes.SqlDecimal:numeric 902 --> ERROR: Expected type System.Data.SqlTypes.SqlMoney does not match actual type System.Data.SqlTypes.SqlDecimal 903 --> ERROR: Expected base type money does not match actual base type numeric 904SendVariantBulkCopy[DataRow] -> System.Data.SqlTypes.SqlDecimal:numeric 905 --> ERROR: Expected type System.Data.SqlTypes.SqlMoney does not match actual type System.Data.SqlTypes.SqlDecimal 906 --> ERROR: Expected base type money does not match actual base type numeric 907SendVariantParam -> System.Data.SqlTypes.SqlMoney:money 908SendVariantTvp[SqlMetaData] -> System.Data.SqlTypes.SqlMoney:money 909SendVariantTvp[SqlDataReader] -> System.Data.SqlTypes.SqlMoney:money 910End test 'SqlVariantParam' 911 912------------------------------ TestSimpleParameter_Type [type: date value:1/1/0001 00:00:00] ------------------------------ 913Type => Expected : Actual == System.DateTime : System.DateTime 914Base Type => Expected : Actual == : 915Value => Expected : Actual == 0 : 0 916 917------------------------------ TestSimpleParameter_Variant [type: date value:1/1/0001 00:00:00] ------------------------------ 918TestSimpleParameter_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 919 920------------------------------ TestSqlDataRecordParameterToTVP_Type [type: date value:1/1/0001 00:00:00] ------------------------------ 921Type => Expected : Actual == System.DateTime : System.DateTime 922Base Type => Expected : Actual == : 923Value => Expected : Actual == 0 : 0 924 925------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: date value:1/1/0001 00:00:00] ------------------------------ 926TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 927 928------------------------------ TestSqlDataReaderParameterToTVP_Type [type: date value:1/1/0001 00:00:00] ------------------------------ 929Type => Expected : Actual == System.DateTime : System.DateTime 930Base Type => Expected : Actual == : 931Value => Expected : Actual == 0 : 0 932 933------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: date value:1/1/0001 00:00:00] ------------------------------ 934TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 935 936------------------------------ TestSqlDataReader_TVP_Type [type: date value:1/1/0001 00:00:00] ------------------------------ 937Type => Expected : Actual == System.DateTime : System.DateTime 938Base Type => Expected : Actual == : 939Value => Expected : Actual == 0 : 0 940 941------------------------------ TestSqlDataReader_TVP_Variant [type: date value:1/1/0001 00:00:00] ------------------------------ 942Type => Expected : Actual == System.DateTime : System.DateTime 943Base Type => Expected : Actual == date : date 944Value => Expected : Actual == 0 : 0 945 946------------------------------ TestSimpleDataReader_Type [type: date value:1/1/0001 00:00:00] ------------------------------ 947Type => Expected : Actual == System.DateTime : System.DateTime 948Base Type => Expected : Actual == : 949Value => Expected : Actual == 0 : 0 950 951------------------------------ TestSimpleDataReader_Variant [type: date value:1/1/0001 00:00:00] ------------------------------ 952Type => Expected : Actual == System.DateTime : System.DateTime 953Base Type => Expected : Actual == date : date 954Value => Expected : Actual == 0 : 0 955 956------------------------------ SqlBulkCopySqlDataReader_Type [type: date value:1/1/0001 00:00:00] ------------------------------ 957Type => Expected : Actual == System.DateTime : System.DateTime 958Base Type => Expected : Actual == : 959Value => Expected : Actual == 0 : 0 960 961------------------------------ SqlBulkCopySqlDataReader_Variant [type: date value:1/1/0001 00:00:00] ------------------------------ 962Type => Expected : Actual == System.DateTime : System.DateTime 963Base Type => Expected : Actual == date : date 964Value => Expected : Actual == 0 : 0 965 966------------------------------ SqlBulkCopyDataTable_Type [type: date value:1/1/0001 00:00:00] ------------------------------ 967Type => Expected : Actual == System.DateTime : System.DateTime 968Base Type => Expected : Actual == : 969Value => Expected : Actual == 0 : 0 970 971------------------------------ SqlBulkCopyDataTable_Variant [type: date value:1/1/0001 00:00:00] ------------------------------ 972SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 973 974------------------------------ SqlBulkCopyDataRow_Type [type: date value:1/1/0001 00:00:00] ------------------------------ 975Type => Expected : Actual == System.DateTime : System.DateTime 976Base Type => Expected : Actual == : 977Value => Expected : Actual == 0 : 0 978 979------------------------------ SqlBulkCopyDataRow_Variant [type: date value:1/1/0001 00:00:00] ------------------------------ 980SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 981 982------------------------------ TestSimpleParameter_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 983Type => Expected : Actual == System.DateTime : System.DateTime 984Base Type => Expected : Actual == : 985Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 986Test Simple Parameter [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 987 988------------------------------ TestSimpleParameter_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 989Type => Expected : Actual == System.DateTime : System.DateTime 990Base Type => Expected : Actual == date : datetime 991Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 992Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date] 993Test Simple Parameter [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 994 995------------------------------ TestSqlDataRecordParameterToTVP_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 996Type => Expected : Actual == System.DateTime : System.DateTime 997Base Type => Expected : Actual == : 998Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 999Test SqlDataRecord Parameter To TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1000 1001------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1002Type => Expected : Actual == System.DateTime : System.DateTime 1003Base Type => Expected : Actual == date : datetime 1004Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1005Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date] 1006Test SqlDataRecord Parameter To TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1007 1008------------------------------ TestSqlDataReaderParameterToTVP_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1009Type => Expected : Actual == System.DateTime : System.DateTime 1010Base Type => Expected : Actual == : 1011Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1012Test SqlDataReader Parameter To TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1013 1014------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1015Type => Expected : Actual == System.DateTime : System.DateTime 1016Base Type => Expected : Actual == date : datetime 1017Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1018Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date] 1019Test SqlDataReader Parameter To TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1020 1021------------------------------ TestSqlDataReader_TVP_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1022Type => Expected : Actual == System.DateTime : System.DateTime 1023Base Type => Expected : Actual == : 1024Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1025Test SqlDataReader TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1026 1027------------------------------ TestSqlDataReader_TVP_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1028Type => Expected : Actual == System.DateTime : System.DateTime 1029Base Type => Expected : Actual == date : date 1030Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1031Test SqlDataReader TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1032 1033------------------------------ TestSimpleDataReader_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1034Type => Expected : Actual == System.DateTime : System.DateTime 1035Base Type => Expected : Actual == : 1036Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1037Test Simple Data Reader [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1038 1039------------------------------ TestSimpleDataReader_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1040Type => Expected : Actual == System.DateTime : System.DateTime 1041Base Type => Expected : Actual == date : date 1042Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1043Test Simple Data Reader [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1044 1045------------------------------ SqlBulkCopySqlDataReader_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1046Type => Expected : Actual == System.DateTime : System.DateTime 1047Base Type => Expected : Actual == : 1048Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1049SqlBulkCopy From SqlDataReader [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1050 1051------------------------------ SqlBulkCopySqlDataReader_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1052Type => Expected : Actual == System.DateTime : System.DateTime 1053Base Type => Expected : Actual == date : date 1054Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1055SqlBulkCopy From SqlDataReader [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1056 1057------------------------------ SqlBulkCopyDataTable_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1058Type => Expected : Actual == System.DateTime : System.DateTime 1059Base Type => Expected : Actual == : 1060Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1061SqlBulkCopy From Data Table [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1062 1063------------------------------ SqlBulkCopyDataTable_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1064Type => Expected : Actual == System.DateTime : System.DateTime 1065Base Type => Expected : Actual == date : datetime 1066Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1067SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date] 1068SqlBulkCopy From Data Table [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1069 1070------------------------------ SqlBulkCopyDataRow_Type [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1071Type => Expected : Actual == System.DateTime : System.DateTime 1072Base Type => Expected : Actual == : 1073Value => Expected : Actual == 3155378975999999999 : 3155378112000000000 1074SqlBulkCopy From Data Row [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 12:00:00 AM] [Expected = 12/31/9999 11:59:59 PM] 1075 1076------------------------------ SqlBulkCopyDataRow_Variant [type: date value:12/31/9999 23:59:59.9999999] ------------------------------ 1077Type => Expected : Actual == System.DateTime : System.DateTime 1078Base Type => Expected : Actual == date : datetime 1079Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1080SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = date] 1081SqlBulkCopy From Data Row [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1082 1083------------------------------ TestSimpleParameter_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1084Type => Expected : Actual == System.DateTime : System.DateTime 1085Base Type => Expected : Actual == : 1086Value => Expected : Actual == 0 : 0 1087 1088------------------------------ TestSimpleParameter_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1089TestSimpleParameter_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1090 1091------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1092Type => Expected : Actual == System.DateTime : System.DateTime 1093Base Type => Expected : Actual == : 1094Value => Expected : Actual == 0 : 0 1095 1096------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1097TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1098 1099------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1100Type => Expected : Actual == System.DateTime : System.DateTime 1101Base Type => Expected : Actual == : 1102Value => Expected : Actual == 0 : 0 1103 1104------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1105TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1106 1107------------------------------ TestSqlDataReader_TVP_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1108Type => Expected : Actual == System.DateTime : System.DateTime 1109Base Type => Expected : Actual == : 1110Value => Expected : Actual == 0 : 0 1111 1112------------------------------ TestSqlDataReader_TVP_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1113Type => Expected : Actual == System.DateTime : System.DateTime 1114Base Type => Expected : Actual == datetime2 : datetime2 1115Value => Expected : Actual == 0 : 0 1116 1117------------------------------ TestSimpleDataReader_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1118Type => Expected : Actual == System.DateTime : System.DateTime 1119Base Type => Expected : Actual == : 1120Value => Expected : Actual == 0 : 0 1121 1122------------------------------ TestSimpleDataReader_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1123Type => Expected : Actual == System.DateTime : System.DateTime 1124Base Type => Expected : Actual == datetime2 : datetime2 1125Value => Expected : Actual == 0 : 0 1126 1127------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1128Type => Expected : Actual == System.DateTime : System.DateTime 1129Base Type => Expected : Actual == : 1130Value => Expected : Actual == 0 : 0 1131 1132------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1133Type => Expected : Actual == System.DateTime : System.DateTime 1134Base Type => Expected : Actual == datetime2 : datetime2 1135Value => Expected : Actual == 0 : 0 1136 1137------------------------------ SqlBulkCopyDataTable_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1138Type => Expected : Actual == System.DateTime : System.DateTime 1139Base Type => Expected : Actual == : 1140Value => Expected : Actual == 0 : 0 1141 1142------------------------------ SqlBulkCopyDataTable_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1143SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1144 1145------------------------------ SqlBulkCopyDataRow_Type [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1146Type => Expected : Actual == System.DateTime : System.DateTime 1147Base Type => Expected : Actual == : 1148Value => Expected : Actual == 0 : 0 1149 1150------------------------------ SqlBulkCopyDataRow_Variant [type: datetime2 value:1/1/0001 00:00:00] ------------------------------ 1151SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1152 1153------------------------------ TestSimpleParameter_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1154Type => Expected : Actual == System.DateTime : System.DateTime 1155Base Type => Expected : Actual == : 1156Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1157 1158------------------------------ TestSimpleParameter_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1159Type => Expected : Actual == System.DateTime : System.DateTime 1160Base Type => Expected : Actual == datetime2 : datetime 1161Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1162Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1163Test Simple Parameter [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1164 1165------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1166Type => Expected : Actual == System.DateTime : System.DateTime 1167Base Type => Expected : Actual == : 1168Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1169 1170------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1171Type => Expected : Actual == System.DateTime : System.DateTime 1172Base Type => Expected : Actual == datetime2 : datetime 1173Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1174Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1175Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1176 1177------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1178Type => Expected : Actual == System.DateTime : System.DateTime 1179Base Type => Expected : Actual == : 1180Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1181 1182------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1183Type => Expected : Actual == System.DateTime : System.DateTime 1184Base Type => Expected : Actual == datetime2 : datetime 1185Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1186Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1187Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1188 1189------------------------------ TestSqlDataReader_TVP_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1190Type => Expected : Actual == System.DateTime : System.DateTime 1191Base Type => Expected : Actual == : 1192Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1193 1194------------------------------ TestSqlDataReader_TVP_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1195Type => Expected : Actual == System.DateTime : System.DateTime 1196Base Type => Expected : Actual == datetime2 : datetime2 1197Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1198 1199------------------------------ TestSimpleDataReader_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1200Type => Expected : Actual == System.DateTime : System.DateTime 1201Base Type => Expected : Actual == : 1202Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1203 1204------------------------------ TestSimpleDataReader_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1205Type => Expected : Actual == System.DateTime : System.DateTime 1206Base Type => Expected : Actual == datetime2 : datetime2 1207Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1208 1209------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1210Type => Expected : Actual == System.DateTime : System.DateTime 1211Base Type => Expected : Actual == : 1212Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1213 1214------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1215Type => Expected : Actual == System.DateTime : System.DateTime 1216Base Type => Expected : Actual == datetime2 : datetime2 1217Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1218 1219------------------------------ SqlBulkCopyDataTable_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1220Type => Expected : Actual == System.DateTime : System.DateTime 1221Base Type => Expected : Actual == : 1222Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1223 1224------------------------------ SqlBulkCopyDataTable_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1225Type => Expected : Actual == System.DateTime : System.DateTime 1226Base Type => Expected : Actual == datetime2 : datetime 1227Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1228SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1229SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1230 1231------------------------------ SqlBulkCopyDataRow_Type [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1232Type => Expected : Actual == System.DateTime : System.DateTime 1233Base Type => Expected : Actual == : 1234Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1235 1236------------------------------ SqlBulkCopyDataRow_Variant [type: datetime2 value:12/31/9999 23:59:59.9999999] ------------------------------ 1237Type => Expected : Actual == System.DateTime : System.DateTime 1238Base Type => Expected : Actual == datetime2 : datetime 1239Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1240SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1241SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1242 1243------------------------------ TestSimpleParameter_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1244TestSimpleParameter_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1245 1246------------------------------ TestSimpleParameter_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1247TestSimpleParameter_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1248 1249------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1250TestSqlDataRecordParameterToTVP_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1251 1252------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1253TestSqlDataRecordParameterToTVP_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1254 1255------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1256TestSqlDataReaderParameterToTVP_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1257 1258------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1259TestSqlDataReaderParameterToTVP_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1260 1261------------------------------ TestSqlDataReader_TVP_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1262TestSqlDataReader_TVP_Type[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 1263The statement has been terminated. 1264 1265------------------------------ TestSqlDataReader_TVP_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1266TestSqlDataReader_TVP_Variant[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 1267The statement has been terminated. 1268 1269------------------------------ TestSimpleDataReader_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1270TestSimpleDataReader_Type[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 1271The statement has been terminated. 1272 1273------------------------------ TestSimpleDataReader_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1274TestSimpleDataReader_Variant[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 1275The statement has been terminated. 1276 1277------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1278SqlBulkCopySqlDataReader_Type[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 1279The statement has been terminated. 1280 1281------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1282SqlBulkCopySqlDataReader_Variant[EXPECTED EXPECTION] The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 1283The statement has been terminated. 1284 1285------------------------------ SqlBulkCopyDataTable_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1286SqlBulkCopyDataTable_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1287 1288------------------------------ SqlBulkCopyDataTable_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1289SqlBulkCopyDataTable_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1290 1291------------------------------ SqlBulkCopyDataRow_Type [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1292SqlBulkCopyDataRow_Type[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1293 1294------------------------------ SqlBulkCopyDataRow_Variant [type: datetime value:1/1/0001 00:00:00] ------------------------------ 1295SqlBulkCopyDataRow_Variant[EXPECTED EXPECTION] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1296 1297------------------------------ TestSimpleParameter_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1298Type => Expected : Actual == System.DateTime : System.DateTime 1299Base Type => Expected : Actual == : 1300Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1301Test Simple Parameter [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1302 1303------------------------------ TestSimpleParameter_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1304Type => Expected : Actual == System.DateTime : System.DateTime 1305Base Type => Expected : Actual == datetime : datetime 1306Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1307Test Simple Parameter [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1308 1309------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1310Type => Expected : Actual == System.DateTime : System.DateTime 1311Base Type => Expected : Actual == : 1312Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1313Test SqlDataRecord Parameter To TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1314 1315------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1316Type => Expected : Actual == System.DateTime : System.DateTime 1317Base Type => Expected : Actual == datetime : datetime 1318Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1319Test SqlDataRecord Parameter To TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1320 1321------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1322Type => Expected : Actual == System.DateTime : System.DateTime 1323Base Type => Expected : Actual == : 1324Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1325Test SqlDataReader Parameter To TVP [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1326 1327------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1328Type => Expected : Actual == System.DateTime : System.DateTime 1329Base Type => Expected : Actual == datetime : datetime 1330Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1331Test SqlDataReader Parameter To TVP [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1332 1333------------------------------ TestSqlDataReader_TVP_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1334TestSqlDataReader_TVP_Type[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string. 1335 1336------------------------------ TestSqlDataReader_TVP_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1337TestSqlDataReader_TVP_Variant[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string. 1338 1339------------------------------ TestSimpleDataReader_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1340TestSimpleDataReader_Type[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string. 1341 1342------------------------------ TestSimpleDataReader_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1343TestSimpleDataReader_Variant[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string. 1344 1345------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1346SqlBulkCopySqlDataReader_Type[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string. 1347 1348------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1349SqlBulkCopySqlDataReader_Variant[EXPECTED EXPECTION] Conversion failed when converting date and/or time from character string. 1350 1351------------------------------ SqlBulkCopyDataTable_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1352Type => Expected : Actual == System.DateTime : System.DateTime 1353Base Type => Expected : Actual == : 1354Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1355SqlBulkCopy From Data Table [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1356 1357------------------------------ SqlBulkCopyDataTable_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1358Type => Expected : Actual == System.DateTime : System.DateTime 1359Base Type => Expected : Actual == datetime : datetime 1360Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1361SqlBulkCopy From Data Table [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1362 1363------------------------------ SqlBulkCopyDataRow_Type [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1364Type => Expected : Actual == System.DateTime : System.DateTime 1365Base Type => Expected : Actual == : 1366Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1367SqlBulkCopy From Data Row [Data Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1368 1369------------------------------ SqlBulkCopyDataRow_Variant [type: datetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1370Type => Expected : Actual == System.DateTime : System.DateTime 1371Base Type => Expected : Actual == datetime : datetime 1372Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1373SqlBulkCopy From Data Row [Variant Type][EXPECTED ERROR]: VALUE MISMATCH - [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1374 1375------------------------------ TestSimpleParameter_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1376Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1377Base Type => Expected : Actual == : 1378Value => Expected : Actual == 0 : 0 1379 1380------------------------------ TestSimpleParameter_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1381Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1382Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1383Value => Expected : Actual == 0 : 0 1384 1385------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1386Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1387Base Type => Expected : Actual == : 1388Value => Expected : Actual == 0 : 0 1389 1390------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1391Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1392Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1393Value => Expected : Actual == 0 : 0 1394 1395------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1396Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1397Base Type => Expected : Actual == : 1398Value => Expected : Actual == 0 : 0 1399 1400------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1401Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1402Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1403Value => Expected : Actual == 0 : 0 1404 1405------------------------------ TestSqlDataReader_TVP_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1406Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1407Base Type => Expected : Actual == : 1408Value => Expected : Actual == 0 : 0 1409 1410------------------------------ TestSqlDataReader_TVP_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1411Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1412Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1413Value => Expected : Actual == 0 : 0 1414 1415------------------------------ TestSimpleDataReader_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1416Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1417Base Type => Expected : Actual == : 1418Value => Expected : Actual == 0 : 0 1419 1420------------------------------ TestSimpleDataReader_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1421Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1422Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1423Value => Expected : Actual == 0 : 0 1424 1425------------------------------ SqlBulkCopySqlDataReader_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1426Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1427Base Type => Expected : Actual == : 1428Value => Expected : Actual == 0 : 0 1429 1430------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1431Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1432Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1433Value => Expected : Actual == 0 : 0 1434 1435------------------------------ SqlBulkCopyDataTable_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1436Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1437Base Type => Expected : Actual == : 1438Value => Expected : Actual == 0 : 0 1439 1440------------------------------ SqlBulkCopyDataTable_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1441Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1442Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1443Value => Expected : Actual == 0 : 0 1444 1445------------------------------ SqlBulkCopyDataRow_Type [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1446Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1447Base Type => Expected : Actual == : 1448Value => Expected : Actual == 0 : 0 1449 1450------------------------------ SqlBulkCopyDataRow_Variant [type: datetimeoffset value:1/1/0001 00:00:00 00:00:00] ------------------------------ 1451Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1452Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1453Value => Expected : Actual == 0 : 0 1454 1455------------------------------ TestSimpleParameter_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1456Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1457Base Type => Expected : Actual == : 1458Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1459 1460------------------------------ TestSimpleParameter_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1461Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1462Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1463Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1464 1465------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1466Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1467Base Type => Expected : Actual == : 1468Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1469 1470------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1471Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1472Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1473Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1474 1475------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1476Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1477Base Type => Expected : Actual == : 1478Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1479 1480------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1481Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1482Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1483Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1484 1485------------------------------ TestSqlDataReader_TVP_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1486Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1487Base Type => Expected : Actual == : 1488Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1489 1490------------------------------ TestSqlDataReader_TVP_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1491Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1492Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1493Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1494 1495------------------------------ TestSimpleDataReader_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1496Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1497Base Type => Expected : Actual == : 1498Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1499 1500------------------------------ TestSimpleDataReader_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1501Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1502Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1503Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1504 1505------------------------------ SqlBulkCopySqlDataReader_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1506Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1507Base Type => Expected : Actual == : 1508Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1509 1510------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1511Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1512Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1513Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1514 1515------------------------------ SqlBulkCopyDataTable_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1516Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1517Base Type => Expected : Actual == : 1518Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1519 1520------------------------------ SqlBulkCopyDataTable_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1521Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1522Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1523Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1524 1525------------------------------ SqlBulkCopyDataRow_Type [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1526Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1527Base Type => Expected : Actual == : 1528Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1529 1530------------------------------ SqlBulkCopyDataRow_Variant [type: datetimeoffset value:12/31/9999 23:59:59.9999999 00:00:00] ------------------------------ 1531Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1532Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1533Value => Expected : Actual == 3155378975999999999 : 3155378975999999999 1534 1535------------------------------ TestSimpleParameter_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1536Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1537Base Type => Expected : Actual == : 1538Value => Expected : Actual == 630822815999999999 : 630822815999999999 1539 1540------------------------------ TestSimpleParameter_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1541Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1542Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1543Value => Expected : Actual == 630822815999999999 : 630822815999999999 1544 1545------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1546Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1547Base Type => Expected : Actual == : 1548Value => Expected : Actual == 630822815999999999 : 630822815999999999 1549 1550------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1551Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1552Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1553Value => Expected : Actual == 630822815999999999 : 630822815999999999 1554 1555------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1556Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1557Base Type => Expected : Actual == : 1558Value => Expected : Actual == 630822815999999999 : 630822815999999999 1559 1560------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1561Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1562Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1563Value => Expected : Actual == 630822815999999999 : 630822815999999999 1564 1565------------------------------ TestSqlDataReader_TVP_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1566Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1567Base Type => Expected : Actual == : 1568Value => Expected : Actual == 630822815999999999 : 630823121999999999 1569 1570------------------------------ TestSqlDataReader_TVP_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1571Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1572Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1573Value => Expected : Actual == 630822815999999999 : 630823121999999999 1574 1575------------------------------ TestSimpleDataReader_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1576Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1577Base Type => Expected : Actual == : 1578Value => Expected : Actual == 630822815999999999 : 630823121999999999 1579 1580------------------------------ TestSimpleDataReader_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1581Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1582Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1583Value => Expected : Actual == 630822815999999999 : 630823121999999999 1584 1585------------------------------ SqlBulkCopySqlDataReader_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1586Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1587Base Type => Expected : Actual == : 1588Value => Expected : Actual == 630822815999999999 : 630823121999999999 1589 1590------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1591Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1592Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1593Value => Expected : Actual == 630822815999999999 : 630823121999999999 1594 1595------------------------------ SqlBulkCopyDataTable_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1596Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1597Base Type => Expected : Actual == : 1598Value => Expected : Actual == 630822815999999999 : 630822815999999999 1599 1600------------------------------ SqlBulkCopyDataTable_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1601Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1602Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1603Value => Expected : Actual == 630822815999999999 : 630822815999999999 1604 1605------------------------------ SqlBulkCopyDataRow_Type [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1606Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1607Base Type => Expected : Actual == : 1608Value => Expected : Actual == 630822815999999999 : 630822815999999999 1609 1610------------------------------ SqlBulkCopyDataRow_Variant [type: datetimeoffset value:12/31/1999 23:59:59.9999999 -08:30:00] ------------------------------ 1611Type => Expected : Actual == System.DateTimeOffset : System.DateTimeOffset 1612Base Type => Expected : Actual == datetimeoffset : datetimeoffset 1613Value => Expected : Actual == 630822815999999999 : 630822815999999999 1614 1615------------------------------ TestSimpleParameter_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1616Type => Expected : Actual == System.DateTime : System.DateTime 1617Base Type => Expected : Actual == : 1618Value => Expected : Actual == 630192959999950000 : 630192959999950000 1619 1620------------------------------ TestSimpleParameter_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1621Type => Expected : Actual == System.DateTime : System.DateTime 1622Base Type => Expected : Actual == datetime2 : datetime 1623Value => Expected : Actual == 630192959999950000 : 630192959999970000 1624Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1625Test Simple Parameter [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM] 1626 1627------------------------------ TestSqlDataRecordParameterToTVP_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1628Type => Expected : Actual == System.DateTime : System.DateTime 1629Base Type => Expected : Actual == : 1630Value => Expected : Actual == 630192959999950000 : 630192959999950000 1631 1632------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1633Type => Expected : Actual == System.DateTime : System.DateTime 1634Base Type => Expected : Actual == datetime2 : datetime 1635Value => Expected : Actual == 630192959999950000 : 630192959999970000 1636Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1637Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM] 1638 1639------------------------------ TestSqlDataReaderParameterToTVP_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1640Type => Expected : Actual == System.DateTime : System.DateTime 1641Base Type => Expected : Actual == : 1642Value => Expected : Actual == 630192959999950000 : 630192959999950000 1643 1644------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1645Type => Expected : Actual == System.DateTime : System.DateTime 1646Base Type => Expected : Actual == datetime2 : datetime 1647Value => Expected : Actual == 630192959999950000 : 630192959999970000 1648Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1649Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM] 1650 1651------------------------------ TestSqlDataReader_TVP_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1652Type => Expected : Actual == System.DateTime : System.DateTime 1653Base Type => Expected : Actual == : 1654Value => Expected : Actual == 630192959999950000 : 630192959999950000 1655 1656------------------------------ TestSqlDataReader_TVP_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1657Type => Expected : Actual == System.DateTime : System.DateTime 1658Base Type => Expected : Actual == datetime2 : datetime2 1659Value => Expected : Actual == 630192959999950000 : 630192959999950000 1660 1661------------------------------ TestSimpleDataReader_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1662Type => Expected : Actual == System.DateTime : System.DateTime 1663Base Type => Expected : Actual == : 1664Value => Expected : Actual == 630192959999950000 : 630192959999950000 1665 1666------------------------------ TestSimpleDataReader_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1667Type => Expected : Actual == System.DateTime : System.DateTime 1668Base Type => Expected : Actual == datetime2 : datetime2 1669Value => Expected : Actual == 630192959999950000 : 630192959999950000 1670 1671------------------------------ SqlBulkCopySqlDataReader_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1672Type => Expected : Actual == System.DateTime : System.DateTime 1673Base Type => Expected : Actual == : 1674Value => Expected : Actual == 630192959999950000 : 630192959999950000 1675 1676------------------------------ SqlBulkCopySqlDataReader_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1677Type => Expected : Actual == System.DateTime : System.DateTime 1678Base Type => Expected : Actual == datetime2 : datetime2 1679Value => Expected : Actual == 630192959999950000 : 630192959999950000 1680 1681------------------------------ SqlBulkCopyDataTable_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1682Type => Expected : Actual == System.DateTime : System.DateTime 1683Base Type => Expected : Actual == : 1684Value => Expected : Actual == 630192959999950000 : 630192959999950000 1685 1686------------------------------ SqlBulkCopyDataTable_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1687Type => Expected : Actual == System.DateTime : System.DateTime 1688Base Type => Expected : Actual == datetime2 : datetime 1689Value => Expected : Actual == 630192959999950000 : 630192959999970000 1690SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1691SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM] 1692 1693------------------------------ SqlBulkCopyDataRow_Type [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1694Type => Expected : Actual == System.DateTime : System.DateTime 1695Base Type => Expected : Actual == : 1696Value => Expected : Actual == 630192959999950000 : 630192959999950000 1697 1698------------------------------ SqlBulkCopyDataRow_Variant [type: datetime2 value:1/1/1998 23:59:59.9950000] ------------------------------ 1699Type => Expected : Actual == System.DateTime : System.DateTime 1700Base Type => Expected : Actual == datetime2 : datetime 1701Value => Expected : Actual == 630192959999950000 : 630192959999970000 1702SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = datetime2] 1703SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 1/1/1998 11:59:59 PM] [Expected = 1/1/1998 11:59:59 PM] 1704 1705------------------------------ TestSimpleParameter_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1706TestSimpleParameter_Type>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1707 1708------------------------------ TestSimpleParameter_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1709TestSimpleParameter_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1710 1711------------------------------ TestSqlDataRecordParameterToTVP_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1712TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.ArgumentException] Invalid value for this metadata. 1713 1714------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1715TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1716 1717------------------------------ TestSqlDataReaderParameterToTVP_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1718TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1719 1720------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1721TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1722 1723------------------------------ TestSqlDataReader_TVP_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1724TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. 1725The statement has been terminated. 1726 1727------------------------------ TestSqlDataReader_TVP_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1728TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. 1729The statement has been terminated. 1730 1731------------------------------ TestSimpleDataReader_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1732TestSimpleDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. 1733The statement has been terminated. 1734 1735------------------------------ TestSimpleDataReader_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1736TestSimpleDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. 1737The statement has been terminated. 1738 1739------------------------------ SqlBulkCopySqlDataReader_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1740SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. 1741The statement has been terminated. 1742 1743------------------------------ SqlBulkCopySqlDataReader_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1744SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range value. 1745The statement has been terminated. 1746 1747------------------------------ SqlBulkCopyDataTable_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1748SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1749 1750------------------------------ SqlBulkCopyDataTable_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1751SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1752 1753------------------------------ SqlBulkCopyDataRow_Type [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1754SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1755 1756------------------------------ SqlBulkCopyDataRow_Variant [type: smalldatetime value:1/1/0001 00:00:00] ------------------------------ 1757SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1758 1759------------------------------ TestSimpleParameter_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1760TestSimpleParameter_Type>>> EXCEPTION: [System.ArgumentOutOfRangeException] The added or subtracted value results in an un-representable DateTime. 1761Parameter name: value 1762 1763------------------------------ TestSimpleParameter_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1764Type => Expected : Actual == System.DateTime : System.DateTime 1765Base Type => Expected : Actual == smalldatetime : datetime 1766Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1767Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime] 1768Test Simple Parameter [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1769 1770------------------------------ TestSqlDataRecordParameterToTVP_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1771TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.ArgumentException] Invalid value for this metadata. 1772 1773------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1774Type => Expected : Actual == System.DateTime : System.DateTime 1775Base Type => Expected : Actual == smalldatetime : datetime 1776Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1777Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime] 1778Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1779 1780------------------------------ TestSqlDataReaderParameterToTVP_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1781TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.ArgumentOutOfRangeException] The added or subtracted value results in an un-representable DateTime. 1782Parameter name: value 1783 1784------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1785Type => Expected : Actual == System.DateTime : System.DateTime 1786Base Type => Expected : Actual == smalldatetime : datetime 1787Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1788Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime] 1789Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1790 1791------------------------------ TestSqlDataReader_TVP_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1792TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type. 1793 1794------------------------------ TestSqlDataReader_TVP_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1795TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type. 1796 1797------------------------------ TestSimpleDataReader_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1798TestSimpleDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type. 1799 1800------------------------------ TestSimpleDataReader_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1801TestSimpleDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type. 1802 1803------------------------------ SqlBulkCopySqlDataReader_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1804SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type. 1805 1806------------------------------ SqlBulkCopySqlDataReader_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1807SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting character string to smalldatetime data type. 1808 1809------------------------------ SqlBulkCopyDataTable_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1810SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.ArgumentOutOfRangeException] The added or subtracted value results in an un-representable DateTime. 1811Parameter name: value 1812 1813------------------------------ SqlBulkCopyDataTable_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1814Type => Expected : Actual == System.DateTime : System.DateTime 1815Base Type => Expected : Actual == smalldatetime : datetime 1816Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1817SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime] 1818SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1819 1820------------------------------ SqlBulkCopyDataRow_Type [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1821SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.ArgumentOutOfRangeException] The added or subtracted value results in an un-representable DateTime. 1822Parameter name: value 1823 1824------------------------------ SqlBulkCopyDataRow_Variant [type: smalldatetime value:12/31/9999 23:59:59.9999999] ------------------------------ 1825Type => Expected : Actual == System.DateTime : System.DateTime 1826Base Type => Expected : Actual == smalldatetime : datetime 1827Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1828SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = smalldatetime] 1829SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1830 1831------------------------------ TestSimpleParameter_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1832TestSimpleParameter_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '-10675199.02:48:05.4775808' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1833 1834------------------------------ TestSimpleParameter_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1835TestSimpleParameter_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '-10675199.02:48:05.4775808' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1836 1837------------------------------ TestSqlDataRecordParameterToTVP_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1838TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.ArgumentException] Invalid value for this metadata. 1839 1840------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1841Type => Expected : Actual == System.TimeSpan : System.TimeSpan 1842Base Type => Expected : Actual == time : time 1843Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 00:00:00] [Expected = -10675199.02:48:05.4775808] 1844 1845------------------------------ TestSqlDataReaderParameterToTVP_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1846TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '-10675199.02:48:05.4775808' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1847 1848------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1849TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '-10675199.02:48:05.4775808' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1850 1851------------------------------ TestSqlDataReader_TVP_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1852TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1853 1854------------------------------ TestSqlDataReader_TVP_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1855TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1856 1857------------------------------ TestSimpleDataReader_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1858TestSimpleDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1859 1860------------------------------ TestSimpleDataReader_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1861TestSimpleDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1862 1863------------------------------ SqlBulkCopySqlDataReader_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1864SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1865 1866------------------------------ SqlBulkCopySqlDataReader_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1867SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1868 1869------------------------------ SqlBulkCopyDataTable_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1870SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '-10675199.02:48:05.4775808' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1871 1872------------------------------ SqlBulkCopyDataTable_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1873SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '-10675199.02:48:05.4775808' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1874 1875------------------------------ SqlBulkCopyDataRow_Type [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1876SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '-10675199.02:48:05.4775808' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1877 1878------------------------------ SqlBulkCopyDataRow_Variant [type: time value:-10675199.02:48:05.4775808] ------------------------------ 1879SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '-10675199.02:48:05.4775808' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1880 1881------------------------------ TestSimpleParameter_Type [type: time value:10675199.02:48:05.4775807] ------------------------------ 1882TestSimpleParameter_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '10675199.02:48:05.4775807' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1883 1884------------------------------ TestSimpleParameter_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------ 1885TestSimpleParameter_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '10675199.02:48:05.4775807' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1886 1887------------------------------ TestSqlDataRecordParameterToTVP_Type [type: time value:10675199.02:48:05.4775807] ------------------------------ 1888TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.ArgumentException] Invalid value for this metadata. 1889 1890------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------ 1891TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter 0 (""), row 1, column 1: The supplied value is not a valid instance of data type sql_variant. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. 1892The statement has been terminated. 1893 1894------------------------------ TestSqlDataReaderParameterToTVP_Type [type: time value:10675199.02:48:05.4775807] ------------------------------ 1895TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '10675199.02:48:05.4775807' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1896 1897------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------ 1898TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '10675199.02:48:05.4775807' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1899 1900------------------------------ TestSqlDataReader_TVP_Type [type: time value:10675199.02:48:05.4775807] ------------------------------ 1901TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1902 1903------------------------------ TestSqlDataReader_TVP_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------ 1904TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1905 1906------------------------------ TestSimpleDataReader_Type [type: time value:10675199.02:48:05.4775807] ------------------------------ 1907TestSimpleDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1908 1909------------------------------ TestSimpleDataReader_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------ 1910TestSimpleDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1911 1912------------------------------ SqlBulkCopySqlDataReader_Type [type: time value:10675199.02:48:05.4775807] ------------------------------ 1913SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1914 1915------------------------------ SqlBulkCopySqlDataReader_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------ 1916SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.Data.SqlClient.SqlException] Conversion failed when converting date and/or time from character string. 1917 1918------------------------------ SqlBulkCopyDataTable_Type [type: time value:10675199.02:48:05.4775807] ------------------------------ 1919SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '10675199.02:48:05.4775807' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1920 1921------------------------------ SqlBulkCopyDataTable_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------ 1922SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '10675199.02:48:05.4775807' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1923 1924------------------------------ SqlBulkCopyDataRow_Type [type: time value:10675199.02:48:05.4775807] ------------------------------ 1925SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '10675199.02:48:05.4775807' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1926 1927------------------------------ SqlBulkCopyDataRow_Variant [type: time value:10675199.02:48:05.4775807] ------------------------------ 1928SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.OverflowException] SqlDbType.Time overflow. Value '10675199.02:48:05.4775807' is out of range. Must be between 00:00:00.0000000 and 23:59:59.9999999. 1929 1930------------------------------ TestSimpleParameter_Type [type: time value:1/1/0001 00:00:00] ------------------------------ 1931TestSimpleParameter_Type>>> EXCEPTION: [System.InvalidCastException] Failed to convert parameter value from a DateTime to a TimeSpan. 1932 1933------------------------------ TestSimpleParameter_Variant [type: time value:1/1/0001 00:00:00] ------------------------------ 1934TestSimpleParameter_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1935 1936------------------------------ TestSqlDataRecordParameterToTVP_Type [type: time value:1/1/0001 00:00:00] ------------------------------ 1937TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.InvalidCastException] Specified cast is not valid. 1938 1939------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: time value:1/1/0001 00:00:00] ------------------------------ 1940TestSqlDataRecordParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1941 1942------------------------------ TestSqlDataReaderParameterToTVP_Type [type: time value:1/1/0001 00:00:00] ------------------------------ 1943TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.InvalidCastException] Failed to convert parameter value from a DateTime to a TimeSpan. 1944 1945------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: time value:1/1/0001 00:00:00] ------------------------------ 1946TestSqlDataReaderParameterToTVP_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1947 1948------------------------------ TestSqlDataReader_TVP_Type [type: time value:1/1/0001 00:00:00] ------------------------------ 1949Type => Expected : Actual == System.DateTime : System.TimeSpan 1950Base Type => Expected : Actual == : 1951TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 1952 1953------------------------------ TestSqlDataReader_TVP_Variant [type: time value:1/1/0001 00:00:00] ------------------------------ 1954Type => Expected : Actual == System.DateTime : System.TimeSpan 1955Base Type => Expected : Actual == time : time 1956TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 1957 1958------------------------------ TestSimpleDataReader_Type [type: time value:1/1/0001 00:00:00] ------------------------------ 1959Type => Expected : Actual == System.DateTime : System.TimeSpan 1960Base Type => Expected : Actual == : 1961TestSimpleDataReader_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 1962 1963------------------------------ TestSimpleDataReader_Variant [type: time value:1/1/0001 00:00:00] ------------------------------ 1964Type => Expected : Actual == System.DateTime : System.TimeSpan 1965Base Type => Expected : Actual == time : time 1966TestSimpleDataReader_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 1967 1968------------------------------ SqlBulkCopySqlDataReader_Type [type: time value:1/1/0001 00:00:00] ------------------------------ 1969Type => Expected : Actual == System.DateTime : System.TimeSpan 1970Base Type => Expected : Actual == : 1971SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 1972 1973------------------------------ SqlBulkCopySqlDataReader_Variant [type: time value:1/1/0001 00:00:00] ------------------------------ 1974Type => Expected : Actual == System.DateTime : System.TimeSpan 1975Base Type => Expected : Actual == time : time 1976SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 1977 1978------------------------------ SqlBulkCopyDataTable_Type [type: time value:1/1/0001 00:00:00] ------------------------------ 1979SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.InvalidOperationException] The given value of type DateTime from the data source cannot be converted to type time of the specified target column. 1980 1981------------------------------ SqlBulkCopyDataTable_Variant [type: time value:1/1/0001 00:00:00] ------------------------------ 1982SqlBulkCopyDataTable_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1983 1984------------------------------ SqlBulkCopyDataRow_Type [type: time value:1/1/0001 00:00:00] ------------------------------ 1985SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.InvalidOperationException] The given value of type DateTime from the data source cannot be converted to type time of the specified target column. 1986 1987------------------------------ SqlBulkCopyDataRow_Variant [type: time value:1/1/0001 00:00:00] ------------------------------ 1988SqlBulkCopyDataRow_Variant>>> EXCEPTION: [System.Data.SqlTypes.SqlTypeException] SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. 1989 1990------------------------------ TestSimpleParameter_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 1991TestSimpleParameter_Type>>> EXCEPTION: [System.InvalidCastException] Failed to convert parameter value from a DateTime to a TimeSpan. 1992 1993------------------------------ TestSimpleParameter_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 1994Type => Expected : Actual == System.DateTime : System.DateTime 1995Base Type => Expected : Actual == time : datetime 1996Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 1997Test Simple Parameter [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time] 1998Test Simple Parameter [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 1999 2000------------------------------ TestSqlDataRecordParameterToTVP_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2001TestSqlDataRecordParameterToTVP_Type>>> EXCEPTION: [System.InvalidCastException] Specified cast is not valid. 2002 2003------------------------------ TestSqlDataRecordParameterToTVP_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2004Type => Expected : Actual == System.DateTime : System.DateTime 2005Base Type => Expected : Actual == time : datetime 2006Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 2007Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time] 2008Test SqlDataRecord Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 2009 2010------------------------------ TestSqlDataReaderParameterToTVP_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2011TestSqlDataReaderParameterToTVP_Type>>> EXCEPTION: [System.InvalidCastException] Failed to convert parameter value from a DateTime to a TimeSpan. 2012 2013------------------------------ TestSqlDataReaderParameterToTVP_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2014Type => Expected : Actual == System.DateTime : System.DateTime 2015Base Type => Expected : Actual == time : datetime 2016Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 2017Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time] 2018Test SqlDataReader Parameter To TVP [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 2019 2020------------------------------ TestSqlDataReader_TVP_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2021Type => Expected : Actual == System.DateTime : System.TimeSpan 2022Base Type => Expected : Actual == : 2023TestSqlDataReader_TVP_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 2024 2025------------------------------ TestSqlDataReader_TVP_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2026Type => Expected : Actual == System.DateTime : System.TimeSpan 2027Base Type => Expected : Actual == time : time 2028TestSqlDataReader_TVP_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 2029 2030------------------------------ TestSimpleDataReader_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2031Type => Expected : Actual == System.DateTime : System.TimeSpan 2032Base Type => Expected : Actual == : 2033TestSimpleDataReader_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 2034 2035------------------------------ TestSimpleDataReader_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2036Type => Expected : Actual == System.DateTime : System.TimeSpan 2037Base Type => Expected : Actual == time : time 2038TestSimpleDataReader_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 2039 2040------------------------------ SqlBulkCopySqlDataReader_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2041Type => Expected : Actual == System.DateTime : System.TimeSpan 2042Base Type => Expected : Actual == : 2043SqlBulkCopySqlDataReader_Type>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 2044 2045------------------------------ SqlBulkCopySqlDataReader_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2046Type => Expected : Actual == System.DateTime : System.TimeSpan 2047Base Type => Expected : Actual == time : time 2048SqlBulkCopySqlDataReader_Variant>>> EXCEPTION: [System.InvalidCastException] Unable to cast object of type 'System.TimeSpan' to type 'System.DateTime'. 2049 2050------------------------------ SqlBulkCopyDataTable_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2051SqlBulkCopyDataTable_Type>>> EXCEPTION: [System.InvalidOperationException] The given value of type DateTime from the data source cannot be converted to type time of the specified target column. 2052 2053------------------------------ SqlBulkCopyDataTable_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2054Type => Expected : Actual == System.DateTime : System.DateTime 2055Base Type => Expected : Actual == time : datetime 2056Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 2057SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time] 2058SqlBulkCopy From Data Table [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 2059 2060------------------------------ SqlBulkCopyDataRow_Type [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2061SqlBulkCopyDataRow_Type>>> EXCEPTION: [System.InvalidOperationException] The given value of type DateTime from the data source cannot be converted to type time of the specified target column. 2062 2063------------------------------ SqlBulkCopyDataRow_Variant [type: time value:12/31/9999 23:59:59.9999999] ------------------------------ 2064Type => Expected : Actual == System.DateTime : System.DateTime 2065Base Type => Expected : Actual == time : datetime 2066Value => Expected : Actual == 3155378975999999999 : 3155378975999970000 2067SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VARIANT BASE TYPE MISMATCH!!! [Actual = datetime] [Expected = time] 2068SqlBulkCopy From Data Row [Variant Type]>>> ERROR: VALUE MISMATCH!!! [Actual = 12/31/9999 11:59:59 PM] [Expected = 12/31/9999 11:59:59 PM] 2069Starting 'OutputParameter' tests 2070Test setting output SqlParameter to an invalid value 2071Done 2072