Files
Rolf Bjarne Kvinge 5780d872ad [System*] Throw a PlatformNotSupported exception when using the managed networking stack on watchOS. (#3683)
* [System.Data] System.Data.SqlClient is not supported in watchOS.

System.Data.SqlClient is not supported in watchOS, because it depends on a
working managed networking stack, which we don't have on watchOS.

* [System] Throw PlatformNotSupportedExceptions in the networking stack for watchOS.

* [System] Don't reference/build Mono.Security.dll when building for watchOS.

This means we can't build Mono.Data.Tds.dll either, since it uses
Mono.Security.dll extensively. In any case Mono.Data.Tds.dll is useless
without a working networking stack, and since it's a Mono-only dll (i.e. not
part of netstandard or facades), just remove the entire assembly from the
watchOS profile.

System.Security.dll uses Mono.Security.dll as well, but the required classes
are available inside mscorlib.dll (as internal classes), so just open up
mscorlib internals to System.Security.dll.

* [System] Update tests after API change for watchOS.

* [System.Data] Update tests after API change in watchOS.

* Revert "Fix build break from 81fb20737f810def6dde88d87a1b2f23cdb736c3"

This reverts commit f4475ff013.

* Fix missing trailing newline in monotouch_watch_System.dll.sources 

It breaks the build on Linux if the newline is missing.
2016-10-03 13:00:16 +02:00

1650 lines
62 KiB
C#

//
// SqlParameterTest.cs - NUnit Test Cases for testing the
// SqlParameter class
// Author:
// Senganal T ([email protected])
// Amit Biswas ([email protected])
// Gert Driesen ([email protected])
//
// Copyright (c) 2004 Novell Inc., and the individuals listed
// on the ChangeLog entries.
//
// Permission is hereby granted, free of charge, to any person obtaining
// a copy of this software and associated documentation files (the
// "Software"), to deal in the Software without restriction, including
// without limitation the rights to use, copy, modify, merge, publish,
// distribute, sublicense, and/or sell copies of the Software, and to
// permit persons to whom the Software is furnished to do so, subject to
// the following conditions:
//
// The above copyright notice and this permission notice shall be
// included in all copies or substantial portions of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
// EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
// MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
// NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
// LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
// OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
// WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
//
using System;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.IO;
using System.Xml;
using NUnit.Framework;
namespace MonoTests.System.Data.SqlClient
{
[TestFixture]
public class SqlParameterTest
{
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void Constructor1 ()
{
SqlParameter p = new SqlParameter ();
Assert.AreEqual (DbType.String, p.DbType, "DbType");
Assert.AreEqual (ParameterDirection.Input, p.Direction, "Direction");
Assert.IsFalse (p.IsNullable, "IsNullable");
Assert.AreEqual (0, p.LocaleId, "LocaleId");
Assert.AreEqual (string.Empty, p.ParameterName, "ParameterName");
Assert.AreEqual (0, p.Precision, "Precision");
Assert.AreEqual (0, p.Scale, "Scale");
Assert.AreEqual (0, p.Size, "Size");
Assert.AreEqual (string.Empty, p.SourceColumn, "SourceColumn");
Assert.IsFalse (p.SourceColumnNullMapping, "SourceColumnNullMapping");
Assert.AreEqual (DataRowVersion.Current, p.SourceVersion, "SourceVersion");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "SqlDbType");
Assert.IsNull (p.SqlValue, "SqlValue");
Assert.IsNull (p.Value, "Value");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionDatabase, "XmlSchemaCollectionDatabase");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionName, "XmlSchemaCollectionName");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionOwningSchema, "XmlSchemaCollectionOwningSchema");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void Constructor2_Value_DateTime ()
{
DateTime value = new DateTime (2004, 8, 24);
SqlParameter p = new SqlParameter ("address", value);
Assert.AreEqual (DbType.DateTime, p.DbType, "B:DbType");
Assert.AreEqual (ParameterDirection.Input, p.Direction, "B:Direction");
Assert.IsFalse (p.IsNullable, "B:IsNullable");
Assert.AreEqual (0, p.LocaleId, "B:LocaleId");
Assert.AreEqual ("address", p.ParameterName, "B:ParameterName");
Assert.AreEqual (0, p.Precision, "B:Precision");
Assert.AreEqual (0, p.Scale, "B:Scale");
//Assert.AreEqual (0, p.Size, "B:Size");
Assert.AreEqual (string.Empty, p.SourceColumn, "B:SourceColumn");
Assert.IsFalse (p.SourceColumnNullMapping, "B:SourceColumnNullMapping");
Assert.AreEqual (DataRowVersion.Current, p.SourceVersion, "B:SourceVersion");
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "B:SqlDbType");
// FIXME
//Assert.AreEqual (new SqlDateTime (value), p.SqlValue, "B:SqlValue");
Assert.AreEqual (value, p.Value, "B:Value");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionDatabase, "B:XmlSchemaCollectionDatabase");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionName, "B:XmlSchemaCollectionName");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionOwningSchema, "B:XmlSchemaCollectionOwningSchema");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void Constructor2_Value_DBNull ()
{
SqlParameter p = new SqlParameter ("address", DBNull.Value);
Assert.AreEqual (DbType.String, p.DbType, "B:DbType");
Assert.AreEqual (ParameterDirection.Input, p.Direction, "B:Direction");
Assert.IsFalse (p.IsNullable, "B:IsNullable");
Assert.AreEqual (0, p.LocaleId, "B:LocaleId");
Assert.AreEqual ("address", p.ParameterName, "B:ParameterName");
Assert.AreEqual (0, p.Precision, "B:Precision");
Assert.AreEqual (0, p.Scale, "B:Scale");
Assert.AreEqual (0, p.Size, "B:Size");
Assert.AreEqual (string.Empty, p.SourceColumn, "B:SourceColumn");
Assert.IsFalse (p.SourceColumnNullMapping, "B:SourceColumnNullMapping");
Assert.AreEqual (DataRowVersion.Current, p.SourceVersion, "B:SourceVersion");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "B:SqlDbType");
// FIXME
//Assert.AreEqual (SqlString.Null, p.SqlValue, "B:SqlValue");
Assert.AreEqual (DBNull.Value, p.Value, "B:Value");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionDatabase, "B:XmlSchemaCollectionDatabase");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionName, "B:XmlSchemaCollectionName");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionOwningSchema, "B:XmlSchemaCollectionOwningSchema");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void Constructor2_Value_Null ()
{
SqlParameter p = new SqlParameter ("address", (Object) null);
Assert.AreEqual (DbType.String, p.DbType, "A:DbType");
Assert.AreEqual (ParameterDirection.Input, p.Direction, "A:Direction");
Assert.IsFalse (p.IsNullable, "A:IsNullable");
Assert.AreEqual (0, p.LocaleId, "A:LocaleId");
Assert.AreEqual ("address", p.ParameterName, "A:ParameterName");
Assert.AreEqual (0, p.Precision, "A:Precision");
Assert.AreEqual (0, p.Scale, "A:Scale");
Assert.AreEqual (0, p.Size, "A:Size");
Assert.AreEqual (string.Empty, p.SourceColumn, "A:SourceColumn");
Assert.IsFalse (p.SourceColumnNullMapping, "A:SourceColumnNullMapping");
Assert.AreEqual (DataRowVersion.Current, p.SourceVersion, "A:SourceVersion");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "A:SqlDbType");
Assert.IsNull (p.SqlValue, "A:SqlValue");
Assert.IsNull (p.Value, "A:Value");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionDatabase, "A:XmlSchemaCollectionDatabase");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionName, "A:XmlSchemaCollectionName");
Assert.AreEqual (string.Empty, p.XmlSchemaCollectionOwningSchema, "A:XmlSchemaCollectionOwningSchema");
}
[Test] // .ctor (String, SqlDbType, Int32, ParameterDirection, Byte, Byte, String, DataRowVersion, Boolean, Object, String, String, String)
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void Constructor7 ()
{
SqlParameter p1 = new SqlParameter ("p1Name", SqlDbType.VarChar, 20,
ParameterDirection.InputOutput, 0, 0,
"srcCol", DataRowVersion.Original, false,
"foo", "database", "schema", "name");
Assert.AreEqual (DbType.AnsiString, p1.DbType, "DbType");
Assert.AreEqual (ParameterDirection.InputOutput, p1.Direction, "Direction");
Assert.AreEqual (false, p1.IsNullable, "IsNullable");
//Assert.AreEqual (999, p1.LocaleId, "#");
Assert.AreEqual ("p1Name", p1.ParameterName, "ParameterName");
Assert.AreEqual (0, p1.Precision, "Precision");
Assert.AreEqual (0, p1.Scale, "Scale");
Assert.AreEqual (20, p1.Size, "Size");
Assert.AreEqual ("srcCol", p1.SourceColumn, "SourceColumn");
Assert.AreEqual (false, p1.SourceColumnNullMapping, "SourceColumnNullMapping");
Assert.AreEqual (DataRowVersion.Original, p1.SourceVersion, "SourceVersion");
Assert.AreEqual (SqlDbType.VarChar, p1.SqlDbType, "SqlDbType");
//Assert.AreEqual (3210, p1.SqlValue, "#");
Assert.AreEqual ("foo", p1.Value, "Value");
Assert.AreEqual ("database", p1.XmlSchemaCollectionDatabase, "XmlSchemaCollectionDatabase");
Assert.AreEqual ("name", p1.XmlSchemaCollectionName, "XmlSchemaCollectionName");
Assert.AreEqual ("schema", p1.XmlSchemaCollectionOwningSchema, "XmlSchemaCollectionOwningSchema");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void CompareInfo ()
{
SqlParameter parameter = new SqlParameter ();
Assert.AreEqual (SqlCompareOptions.None, parameter.CompareInfo, "#1");
parameter.CompareInfo = SqlCompareOptions.IgnoreNonSpace;
Assert.AreEqual (SqlCompareOptions.IgnoreNonSpace, parameter.CompareInfo, "#2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Byte ()
{
Byte value = 0x0a;
SqlParameter param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.TinyInt, param.SqlDbType, "#1");
Assert.AreEqual (DbType.Byte, param.DbType, "#2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_ByteArray ()
{
Byte [] value = new Byte [] { 0x0a, 0x0d };
SqlParameter param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.VarBinary, param.SqlDbType, "#1");
Assert.AreEqual (DbType.Binary, param.DbType, "#2");
}
[Test]
[Category ("NotWorking")]
public void InferType_Char ()
{
Char value = 'X';
String string_value = "X";
SqlParameter p = new SqlParameter ();
p.Value = value;
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (DbType.String, p.DbType, "#A:DbType");
Assert.AreEqual (string_value, p.Value, "#A:Value");
p = new SqlParameter ();
p.Value = value;
Assert.AreEqual (value, p.Value, "#B:Value1");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (string_value, p.Value, "#B:Value2");
p = new SqlParameter ();
p.Value = value;
Assert.AreEqual (value, p.Value, "#C:Value1");
Assert.AreEqual (DbType.String, p.DbType, "#C:DbType");
Assert.AreEqual (string_value, p.Value, "#C:Value2");
p = new SqlParameter ("name", value);
Assert.AreEqual (value, p.Value, "#D:Value1");
Assert.AreEqual (DbType.String, p.DbType, "#D:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#D:SqlDbType");
Assert.AreEqual (string_value, p.Value, "#D:Value2");
p = new SqlParameter ("name", 5);
p.Value = value;
Assert.AreEqual (value, p.Value, "#E:Value1");
Assert.AreEqual (DbType.String, p.DbType, "#E:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#E:SqlDbType");
Assert.AreEqual (string_value, p.Value, "#E:Value2");
p = new SqlParameter ("name", SqlDbType.NVarChar);
p.Value = value;
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#F:SqlDbType");
Assert.AreEqual (value, p.Value, "#F:Value");
}
[Test]
[Category ("NotWorking")]
public void InferType_CharArray ()
{
Char [] value = new Char [] { 'A', 'X' };
String string_value = "AX";
SqlParameter p = new SqlParameter ();
p.Value = value;
Assert.AreEqual (value, p.Value, "#A:Value1");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (DbType.String, p.DbType, "#A:DbType");
Assert.AreEqual (string_value, p.Value, "#A:Value2");
p = new SqlParameter ();
p.Value = value;
Assert.AreEqual (value, p.Value, "#B:Value1");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (string_value, p.Value, "#B:Value2");
p = new SqlParameter ();
p.Value = value;
Assert.AreEqual (value, p.Value, "#C:Value1");
Assert.AreEqual (DbType.String, p.DbType, "#C:DbType");
Assert.AreEqual (string_value, p.Value, "#C:Value2");
p = new SqlParameter ("name", value);
Assert.AreEqual (value, p.Value, "#D:Value1");
Assert.AreEqual (DbType.String, p.DbType, "#D:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#D:SqlDbType");
Assert.AreEqual (string_value, p.Value, "#D:Value2");
p = new SqlParameter ("name", 5);
p.Value = value;
Assert.AreEqual (value, p.Value, "#E:Value1");
Assert.AreEqual (DbType.String, p.DbType, "#E:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#E:SqlDbType");
Assert.AreEqual (string_value, p.Value, "#E:Value2");
p = new SqlParameter ("name", SqlDbType.NVarChar);
p.Value = value;
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#F:SqlDbType");
Assert.AreEqual (value, p.Value, "#F:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_DateTime ()
{
DateTime value;
SqlParameter param;
value = DateTime.Now;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.DateTime, param.SqlDbType, "#A1");
Assert.AreEqual (DbType.DateTime, param.DbType, "#A2");
value = DateTime.Now;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.DateTime, param.SqlDbType, "#B1");
Assert.AreEqual (DbType.DateTime, param.DbType, "#B2");
value = new DateTime (1973, 8, 13);
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.DateTime, param.SqlDbType, "#C1");
Assert.AreEqual (DbType.DateTime, param.DbType, "#C2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Decimal ()
{
Decimal value;
SqlParameter param;
value = Decimal.MaxValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Decimal, param.SqlDbType, "#A1");
Assert.AreEqual (DbType.Decimal, param.DbType, "#A2");
value = Decimal.MinValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Decimal, param.SqlDbType, "#B1");
Assert.AreEqual (DbType.Decimal, param.DbType, "#B2");
value = 214748.364m;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Decimal, param.SqlDbType, "#C1");
Assert.AreEqual (DbType.Decimal, param.DbType, "#C2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Double ()
{
Double value;
SqlParameter param;
value = Double.MaxValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Float, param.SqlDbType, "#A1");
Assert.AreEqual (DbType.Double, param.DbType, "#A2");
value = Double.MinValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Float, param.SqlDbType, "#B1");
Assert.AreEqual (DbType.Double, param.DbType, "#B2");
value = 0d;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Float, param.SqlDbType, "#C1");
Assert.AreEqual (DbType.Double, param.DbType, "#C2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Enum ()
{
SqlParameter param;
param = new SqlParameter ();
param.Value = ByteEnum.A;
Assert.AreEqual (SqlDbType.TinyInt, param.SqlDbType, "#A1");
Assert.AreEqual (DbType.Byte, param.DbType, "#A2");
param = new SqlParameter ();
param.Value = Int64Enum.A;
Assert.AreEqual (SqlDbType.BigInt, param.SqlDbType, "#B1");
Assert.AreEqual (DbType.Int64, param.DbType, "#B2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Guid ()
{
Guid value = Guid.NewGuid ();
SqlParameter param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.UniqueIdentifier, param.SqlDbType, "#1");
Assert.AreEqual (DbType.Guid, param.DbType, "#2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Int16 ()
{
Int16 value;
SqlParameter param;
value = Int16.MaxValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.SmallInt, param.SqlDbType, "#A1");
Assert.AreEqual (DbType.Int16, param.DbType, "#A2");
value = Int16.MinValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.SmallInt, param.SqlDbType, "#B1");
Assert.AreEqual (DbType.Int16, param.DbType, "#B2");
value = (Int16) 0;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.SmallInt, param.SqlDbType, "#C1");
Assert.AreEqual (DbType.Int16, param.DbType, "#C2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Int32 ()
{
Int32 value;
SqlParameter param;
value = Int32.MaxValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Int, param.SqlDbType, "#A1");
Assert.AreEqual (DbType.Int32, param.DbType, "#A2");
value = Int32.MinValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Int, param.SqlDbType, "#B1");
Assert.AreEqual (DbType.Int32, param.DbType, "#B2");
value = 0;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Int, param.SqlDbType, "#C1");
Assert.AreEqual (DbType.Int32, param.DbType, "#C2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Int64 ()
{
Int64 value;
SqlParameter param;
value = Int64.MaxValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.BigInt, param.SqlDbType, "#A1");
Assert.AreEqual (DbType.Int64, param.DbType, "#A2");
value = Int64.MinValue;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.BigInt, param.SqlDbType, "#B1");
Assert.AreEqual (DbType.Int64, param.DbType, "#B2");
value = 0L;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.BigInt, param.SqlDbType, "#C1");
Assert.AreEqual (DbType.Int64, param.DbType, "#C2");
}
[Test]
[Category ("NotWorking")]
public void InferType_Invalid ()
{
object [] notsupported = new object [] {
UInt16.MaxValue,
UInt32.MaxValue,
UInt64.MaxValue,
SByte.MaxValue,
new SqlParameter ()
};
SqlParameter param = new SqlParameter ();
for (int i = 0; i < notsupported.Length; i++) {
param.Value = notsupported [i];
try {
SqlDbType type = param.SqlDbType;
Assert.Fail ("#A1:" + i + " (" + type + ")");
} catch (ArgumentException ex) {
// The parameter data type of ... is invalid
Assert.AreEqual (typeof (ArgumentException), ex.GetType (), "#A2");
Assert.IsNull (ex.InnerException, "#A3");
Assert.IsNotNull (ex.Message, "#A4");
Assert.IsNull (ex.ParamName, "#A5");
}
try {
DbType type = param.DbType;
Assert.Fail ("#B1:" + i + " (" + type + ")");
} catch (ArgumentException ex) {
// The parameter data type of ... is invalid
Assert.AreEqual (typeof (ArgumentException), ex.GetType (), "#B2");
Assert.IsNull (ex.InnerException, "#B3");
Assert.IsNotNull (ex.Message, "#B4");
Assert.IsNull (ex.ParamName, "#B5");
}
}
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Object ()
{
Object value = new Object ();
SqlParameter param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Variant, param.SqlDbType, "#1");
Assert.AreEqual (DbType.Object, param.DbType, "#2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Single ()
{
Single value = Single.MaxValue;
SqlParameter param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Real, param.SqlDbType, "#1");
Assert.AreEqual (DbType.Single, param.DbType, "#2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_String ()
{
String value = "some text";
SqlParameter param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.NVarChar, param.SqlDbType, "#1");
Assert.AreEqual (DbType.String, param.DbType, "#2");
}
[Test]
[Category ("NotWorking")]
public void InferType_TimeSpan ()
{
TimeSpan value = new TimeSpan (4, 6, 23);
SqlParameter param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Time, param.SqlDbType, "#1");
Assert.AreEqual (DbType.Time, param.DbType, "#2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void LocaleId ()
{
SqlParameter parameter = new SqlParameter ();
Assert.AreEqual (0, parameter.LocaleId, "#1");
parameter.LocaleId = 15;
Assert.AreEqual(15, parameter.LocaleId, "#2");
}
[Test] // bug #320196
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void ParameterNullTest ()
{
SqlParameter param = new SqlParameter ("param", SqlDbType.Decimal);
Assert.AreEqual (0, param.Scale, "#A1");
param.Value = DBNull.Value;
Assert.AreEqual (0, param.Scale, "#A2");
param = new SqlParameter ("param", SqlDbType.Int);
Assert.AreEqual (0, param.Scale, "#B1");
param.Value = DBNull.Value;
Assert.AreEqual (0, param.Scale, "#B2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void ParameterType ()
{
SqlParameter p;
// If Type is not set, then type is inferred from the value
// assigned. The Type should be inferred everytime Value is assigned
// If value is null or DBNull, then the current Type should be reset to NVarChar.
p = new SqlParameter ();
Assert.AreEqual (DbType.String, p.DbType, "#A1");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#A2");
p.Value = DBNull.Value;
Assert.AreEqual (DbType.String, p.DbType, "#B1");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#B2");
p.Value = 1;
Assert.AreEqual (DbType.Int32, p.DbType, "#C1");
Assert.AreEqual (SqlDbType.Int, p.SqlDbType, "#C2");
p.Value = DBNull.Value;
Assert.AreEqual (DbType.String, p.DbType, "#D1");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#D2");
p.Value = new byte [] { 0x0a };
Assert.AreEqual (DbType.Binary, p.DbType, "#E1");
Assert.AreEqual (SqlDbType.VarBinary, p.SqlDbType, "#E2");
p.Value = null;
Assert.AreEqual (DbType.String, p.DbType, "#F1");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#F2");
p.Value = DateTime.Now;
Assert.AreEqual (DbType.DateTime, p.DbType, "#G1");
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#G2");
p.Value = null;
Assert.AreEqual (DbType.String, p.DbType, "#H1");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#H2");
// If DbType is set, then the SqlDbType should not be
// inferred from the value assigned.
p = new SqlParameter ();
p.DbType = DbType.DateTime;
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#I1");
p.Value = 1;
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#I2");
p.Value = null;
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#I3");
p.Value = DBNull.Value;
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#I4");
// If SqlDbType is set, then the DbType should not be
// inferred from the value assigned.
p = new SqlParameter ();
p.SqlDbType = SqlDbType.VarBinary;
Assert.AreEqual (SqlDbType.VarBinary, p.SqlDbType, "#J1");
p.Value = 1;
Assert.AreEqual (SqlDbType.VarBinary, p.SqlDbType, "#J2");
p.Value = null;
Assert.AreEqual (SqlDbType.VarBinary, p.SqlDbType, "#J3");
p.Value = DBNull.Value;
Assert.AreEqual (SqlDbType.VarBinary, p.SqlDbType, "#J4");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void InferType_Boolean ()
{
Boolean value;
SqlParameter param;
value = false;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Bit, param.SqlDbType, "#A1");
Assert.AreEqual (DbType.Boolean, param.DbType, "#A2");
value = true;
param = new SqlParameter ();
param.Value = value;
Assert.AreEqual (SqlDbType.Bit, param.SqlDbType, "#B1");
Assert.AreEqual (DbType.Boolean, param.DbType, "#B2");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void ParameterName ()
{
SqlParameter p = new SqlParameter ();
p.ParameterName = "name";
Assert.AreEqual ("name", p.ParameterName, "#A:ParameterName");
Assert.AreEqual (string.Empty, p.SourceColumn, "#A:SourceColumn");
p.ParameterName = null;
Assert.AreEqual (string.Empty, p.ParameterName, "#B:ParameterName");
Assert.AreEqual (string.Empty, p.SourceColumn, "#B:SourceColumn");
p.ParameterName = " ";
Assert.AreEqual (" ", p.ParameterName, "#C:ParameterName");
Assert.AreEqual (string.Empty, p.SourceColumn, "#C:SourceColumn");
p.ParameterName = " name ";
Assert.AreEqual (" name ", p.ParameterName, "#D:ParameterName");
Assert.AreEqual (string.Empty, p.SourceColumn, "#D:SourceColumn");
p.ParameterName = string.Empty;
Assert.AreEqual (string.Empty, p.ParameterName, "#E:ParameterName");
Assert.AreEqual (string.Empty, p.SourceColumn, "#E:SourceColumn");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void ResetDbType ()
{
SqlParameter p;
//Parameter with an assigned value but no DbType specified
p = new SqlParameter ("foo", 42);
p.ResetDbType ();
Assert.AreEqual (DbType.Int32, p.DbType, "#A:DbType");
Assert.AreEqual (SqlDbType.Int, p.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (42, p.Value, "#A:Value");
p.DbType = DbType.DateTime; //assigning a DbType
Assert.AreEqual (DbType.DateTime, p.DbType, "#B:DbType1");
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#B:SqlDbType1");
p.ResetDbType ();
Assert.AreEqual (DbType.Int32, p.DbType, "#B:DbType2");
Assert.AreEqual (SqlDbType.Int, p.SqlDbType, "#B:SqlDbtype2");
//Parameter with an assigned SqlDbType but no specified value
p = new SqlParameter ("foo", SqlDbType.Int);
p.ResetDbType ();
Assert.AreEqual (DbType.String, p.DbType, "#C:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#C:SqlDbType");
p.DbType = DbType.DateTime; //assigning a SqlDbType
Assert.AreEqual (DbType.DateTime, p.DbType, "#D:DbType1");
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#D:SqlDbType1");
p.ResetDbType ();
Assert.AreEqual (DbType.String, p.DbType, "#D:DbType2");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#D:SqlDbType2");
p = new SqlParameter ();
p.Value = DateTime.MaxValue;
Assert.AreEqual (DbType.DateTime, p.DbType, "#E:DbType1");
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#E:SqlDbType1");
p.Value = null;
p.ResetDbType ();
Assert.AreEqual (DbType.String, p.DbType, "#E:DbType2");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#E:SqlDbType2");
p = new SqlParameter ("foo", SqlDbType.VarChar);
p.Value = DateTime.MaxValue;
p.ResetDbType ();
Assert.AreEqual (DbType.DateTime, p.DbType, "#F:DbType");
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#F:SqlDbType");
Assert.AreEqual (DateTime.MaxValue, p.Value, "#F:Value");
p = new SqlParameter ("foo", SqlDbType.VarChar);
p.Value = DBNull.Value;
p.ResetDbType ();
Assert.AreEqual (DbType.String, p.DbType, "#G:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#G:SqlDbType");
Assert.AreEqual (DBNull.Value, p.Value, "#G:Value");
p = new SqlParameter ("foo", SqlDbType.VarChar);
p.Value = null;
p.ResetDbType ();
Assert.AreEqual (DbType.String, p.DbType, "#G:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#G:SqlDbType");
Assert.IsNull (p.Value, "#G:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void ResetSqlDbType ()
{
//Parameter with an assigned value but no SqlDbType specified
SqlParameter p1 = new SqlParameter ("foo", 42);
Assert.AreEqual (42, p1.Value, "#1");
Assert.AreEqual (DbType.Int32, p1.DbType, "#2");
Assert.AreEqual (SqlDbType.Int, p1.SqlDbType, "#3");
p1.ResetSqlDbType ();
Assert.AreEqual (DbType.Int32, p1.DbType, "#4 The parameter with value 42 must have DbType as Int32");
Assert.AreEqual (SqlDbType.Int, p1.SqlDbType, "#5 The parameter with value 42 must have SqlDbType as Int");
p1.SqlDbType = SqlDbType.DateTime; //assigning a SqlDbType
Assert.AreEqual (DbType.DateTime, p1.DbType, "#6");
Assert.AreEqual (SqlDbType.DateTime, p1.SqlDbType, "#7");
p1.ResetSqlDbType (); //Resetting SqlDbType
Assert.AreEqual (DbType.Int32, p1.DbType, "#8 Resetting SqlDbType must infer the type from the value");
Assert.AreEqual (SqlDbType.Int, p1.SqlDbType, "#9 Resetting SqlDbType must infer the type from the value");
//Parameter with an assigned SqlDbType but no specified value
SqlParameter p2 = new SqlParameter ("foo", SqlDbType.Int);
Assert.AreEqual (null, p2.Value, "#10");
Assert.AreEqual (DbType.Int32, p2.DbType, "#11");
Assert.AreEqual (SqlDbType.Int, p2.SqlDbType, "#12");
//Although a SqlDbType is specified, calling ResetSqlDbType resets
//the SqlDbType and DbType properties to default values
p2.ResetSqlDbType ();
Assert.AreEqual (DbType.String, p2.DbType, "#13 Resetting SqlDbType must infer the type from the value");
Assert.AreEqual (SqlDbType.NVarChar, p2.SqlDbType, "#14 Resetting SqlDbType must infer the type from the value");
p2.SqlDbType = SqlDbType.DateTime; //assigning a SqlDbType
Assert.AreEqual (DbType.DateTime, p2.DbType, "#15");
Assert.AreEqual (SqlDbType.DateTime, p2.SqlDbType, "#16");
p2.ResetSqlDbType (); //Resetting SqlDbType
Assert.AreEqual (DbType.String, p2.DbType, "#17 Resetting SqlDbType must infer the type from the value");
Assert.AreEqual (SqlDbType.NVarChar, p2.SqlDbType, "#18 Resetting SqlDbType must infer the type from the value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SourceColumn ()
{
SqlParameter p = new SqlParameter ();
p.SourceColumn = "name";
Assert.AreEqual (string.Empty, p.ParameterName, "#A:ParameterName");
Assert.AreEqual ("name", p.SourceColumn, "#A:SourceColumn");
p.SourceColumn = null;
Assert.AreEqual (string.Empty, p.ParameterName, "#B:ParameterName");
Assert.AreEqual (string.Empty, p.SourceColumn, "#B:SourceColumn");
p.SourceColumn = " ";
Assert.AreEqual (string.Empty, p.ParameterName, "#C:ParameterName");
Assert.AreEqual (" ", p.SourceColumn, "#C:SourceColumn");
p.SourceColumn = " name ";
Assert.AreEqual (string.Empty, p.ParameterName, "#D:ParameterName");
Assert.AreEqual (" name ", p.SourceColumn, "#D:SourceColumn");
p.SourceColumn = string.Empty;
Assert.AreEqual (string.Empty, p.ParameterName, "#E:ParameterName");
Assert.AreEqual (string.Empty, p.SourceColumn, "#E:SourceColumn");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SourceColumnNullMapping ()
{
SqlParameter p = new SqlParameter ();
Assert.IsFalse (p.SourceColumnNullMapping, "#1");
p.SourceColumnNullMapping = true;
Assert.IsTrue (p.SourceColumnNullMapping, "#2");
p.SourceColumnNullMapping = false;
Assert.IsFalse (p.SourceColumnNullMapping, "#3");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlDbTypeTest ()
{
SqlParameter p = new SqlParameter ("zipcode", 3510);
p.SqlDbType = SqlDbType.DateTime;
Assert.AreEqual (DbType.DateTime, p.DbType, "#A:DbType");
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (3510, p.Value, "#A:Value");
p.SqlDbType = SqlDbType.VarChar;
Assert.AreEqual (DbType.AnsiString, p.DbType, "#B:DbType");
Assert.AreEqual (SqlDbType.VarChar, p.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (3510, p.Value, "#B:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlDbTypeTest_Value_Invalid ()
{
SqlParameter p = new SqlParameter ("zipcode", 3510);
try {
p.SqlDbType = (SqlDbType) 666;
Assert.Fail ("#1");
} catch (ArgumentOutOfRangeException ex) {
// The SqlDbType enumeration value, 666, is
// invalid
Assert.AreEqual (typeof (ArgumentOutOfRangeException), ex.GetType (), "#2");
Assert.IsNull (ex.InnerException, "#3");
Assert.IsNotNull (ex.Message, "#4");
Assert.IsTrue (ex.Message.IndexOf ("666") != -1, "#5:" + ex.Message);
Assert.AreEqual ("SqlDbType", ex.ParamName, "#6");
}
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlValue ()
{
SqlParameter parameter = new SqlParameter ();
Assert.IsNull (parameter.SqlValue, "#A1");
object value;
value = "Char";
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "String:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "String:SqlValue1");
Assert.AreEqual (typeof (SqlString), parameter.SqlValue.GetType (), "String:SqlValue2");
Assert.AreEqual (value, ((SqlString) parameter.SqlValue).Value, "String:SqlValue3");
Assert.AreEqual (value, parameter.Value, "String:Value");
value = true;
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Bit, parameter.SqlDbType, "Boolean:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Boolean:SqlValue1");
Assert.AreEqual (typeof (SqlBoolean), parameter.SqlValue.GetType (), "Boolean:SqlValue2");
Assert.AreEqual (value, ((SqlBoolean) parameter.SqlValue).Value, "Boolean:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Boolean:Value");
value = (byte) 0x0a;
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.TinyInt, parameter.SqlDbType, "Boolean:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Boolean:SqlValue1");
Assert.AreEqual (typeof (SqlByte), parameter.SqlValue.GetType (), "Boolean:SqlValue2");
Assert.AreEqual (value, ((SqlByte) parameter.SqlValue).Value, "Boolean:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Boolean:Value");
value = new DateTime (2008, 6, 4);
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.DateTime, parameter.SqlDbType, "DateTime:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "DateTime:SqlValue1");
Assert.AreEqual (typeof (SqlDateTime), parameter.SqlValue.GetType (), "DateTime:SqlValue2");
Assert.AreEqual (value, ((SqlDateTime) parameter.SqlValue).Value, "DateTime:SqlValue3");
Assert.AreEqual (value, parameter.Value, "DateTime:Value");
value = Guid.NewGuid ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.UniqueIdentifier, parameter.SqlDbType, "Guid:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Guid:SqlValue1");
Assert.AreEqual (typeof (SqlGuid), parameter.SqlValue.GetType (), "Guid:SqlValue2");
Assert.AreEqual (value, ((SqlGuid) parameter.SqlValue).Value, "Guid:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Guid:Value");
value = (short) 5;
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.SmallInt, parameter.SqlDbType, "Int16:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Int16:SqlValue1");
Assert.AreEqual (typeof (SqlInt16), parameter.SqlValue.GetType (), "Int16:SqlValue2");
Assert.AreEqual (value, ((SqlInt16) parameter.SqlValue).Value, "Int16:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Int16:Value");
value = 10;
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Int, parameter.SqlDbType, "Int32:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Int32:SqlValue1");
Assert.AreEqual (typeof (SqlInt32), parameter.SqlValue.GetType (), "Int32:SqlValue2");
Assert.AreEqual (value, ((SqlInt32) parameter.SqlValue).Value, "Int32:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Int32:Value");
value = 56L;
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.BigInt, parameter.SqlDbType, "Int64:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Int64:SqlValue1");
Assert.AreEqual (typeof (SqlInt64), parameter.SqlValue.GetType (), "Int64:SqlValue2");
Assert.AreEqual (value, ((SqlInt64) parameter.SqlValue).Value, "Int64:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Int64:Value");
parameter.SqlValue = 45.5D;
Assert.AreEqual (SqlDbType.Float, parameter.SqlDbType, "Double:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Double:SqlValue1");
Assert.AreEqual (typeof (SqlDouble), parameter.SqlValue.GetType (), "Double:SqlValue2");
Assert.AreEqual (45.5D, ((SqlDouble) parameter.SqlValue).Value, "Double:SqlValue3");
Assert.AreEqual (45.5D, parameter.Value, "Double:Value");
value = 45m;
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Decimal, parameter.SqlDbType, "Decimal:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Decimal:SqlValue1");
Assert.AreEqual (typeof (SqlDecimal), parameter.SqlValue.GetType (), "Decimal:SqlValue2");
Assert.AreEqual (value, ((SqlDecimal) parameter.SqlValue).Value, "Decimal:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Decimal:Value");
value = 45f;
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Real, parameter.SqlDbType, "Decimal:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Decimal:SqlValue1");
Assert.AreEqual (typeof (SqlSingle), parameter.SqlValue.GetType (), "Decimal:SqlValue2");
Assert.AreEqual (value, ((SqlSingle) parameter.SqlValue).Value, "Decimal:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Decimal:Value");
value = new byte [] { 0x0d, 0x0a };
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.VarBinary, parameter.SqlDbType, "Bytes:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Bytes:SqlValue1");
Assert.AreEqual (typeof (SqlBinary), parameter.SqlValue.GetType (), "Bytes:SqlValue2");
Assert.AreEqual (value, ((SqlBinary) parameter.SqlValue).Value, "Bytes:SqlValue3");
Assert.AreEqual (value, parameter.Value, "Bytes:Value");
parameter = new SqlParameter ();
value = 'X';
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "Chars:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Chars:SqlValue1");
Assert.AreEqual (typeof (SqlString), parameter.SqlValue.GetType (), "Chars:SqlValue2");
Assert.AreEqual ("X", ((SqlString) parameter.SqlValue).Value, "Chars:SqlValue3");
// FIXME bug #525321
//Assert.AreEqual ("X", parameter.Value, "Chars:Value");
value = new char [] { 'X', 'A' };
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "Chars:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "Chars:SqlValue1");
Assert.AreEqual (typeof (SqlString), parameter.SqlValue.GetType (), "Chars:SqlValue2");
Assert.AreEqual ("XA", ((SqlString) parameter.SqlValue).Value, "Chars:SqlValue3");
// FIXME bug #525321
//Assert.AreEqual ("XA", parameter.Value, "Chars:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlBinary ()
{
SqlParameter parameter;
SqlBinary value = new SqlBinary (new byte [] { 0x0d, 0x0a });
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.VarBinary, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlBinary.Null;
Assert.AreEqual (SqlDbType.VarBinary, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlBinary.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlBinary.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.VarBinary, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlBoolean ()
{
SqlParameter parameter;
SqlBoolean value = new SqlBoolean (false);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Bit, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlBoolean.Null;
Assert.AreEqual (SqlDbType.Bit, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlBoolean.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlBoolean.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.Bit, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlByte ()
{
SqlParameter parameter;
SqlByte value = new SqlByte (0x0d);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.TinyInt, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlByte.Null;
Assert.AreEqual (SqlDbType.TinyInt, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlByte.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlByte.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.TinyInt, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
[Category ("NotWorking")]
// This doesn't work as SqlBytes are represented as SqlBinary
public void SqlTypes_SqlBytes ()
{
SqlParameter parameter;
SqlBytes value = new SqlBytes (new byte [] { 0x0d, 0x0a });
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.VarBinary, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreSame (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreSame (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlBytes.Null;
Assert.AreEqual (SqlDbType.VarBinary, parameter.SqlDbType, "#B:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "#B:SqlValue1");
Assert.AreEqual (typeof (SqlBytes), parameter.SqlValue.GetType (), "#B:SqlValue2");
Assert.IsTrue (((SqlBytes) parameter.SqlValue).IsNull, "#B:SqlValue3");
Assert.IsNotNull (parameter.Value, "#B:Value1");
Assert.AreEqual (typeof (SqlBytes), parameter.Value.GetType (), "#B:Value2");
Assert.IsTrue (((SqlBytes) parameter.Value).IsNull, "#B:Value3");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.VarBinary, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
[Category ("NotWorking")]
// This doesn't work as SqlChars are represented as SqlString
public void SqlTypes_SqlChars ()
{
SqlParameter parameter;
SqlChars value = new SqlChars (new char [] { 'X', 'A' });
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreSame (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreSame (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlChars.Null;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "#B:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "#B:SqlValue1");
Assert.AreEqual (typeof (SqlChars), parameter.SqlValue.GetType (), "#B:SqlValue2");
Assert.IsTrue (((SqlChars) parameter.SqlValue).IsNull, "#B:SqlValue3");
Assert.IsNotNull (parameter.Value, "#B:Value1");
Assert.AreEqual (typeof (SqlChars), parameter.Value.GetType (), "#B:Value2");
Assert.IsTrue (((SqlChars) parameter.Value).IsNull, "#B:Value3");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreSame (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreSame (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlDateTime ()
{
SqlParameter parameter;
SqlDateTime value = new SqlDateTime (DateTime.Now);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.DateTime, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlDateTime.Null;
Assert.AreEqual (SqlDbType.DateTime, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlDateTime.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlDateTime.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.DateTime, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlDecimal ()
{
SqlParameter parameter;
SqlDecimal value = new SqlDecimal (45m);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Decimal, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlDecimal.Null;
Assert.AreEqual (SqlDbType.Decimal, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlDecimal.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlDecimal.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.Decimal, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlDouble ()
{
SqlParameter parameter;
SqlDouble value = new SqlDouble (4.5D);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Float, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlDouble.Null;
Assert.AreEqual (SqlDbType.Float, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlDouble.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlDouble.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.Float, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlGuid ()
{
SqlParameter parameter;
SqlGuid value = new SqlGuid (Guid.NewGuid ());
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.UniqueIdentifier, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlGuid.Null;
Assert.AreEqual (SqlDbType.UniqueIdentifier, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlGuid.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlGuid.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.UniqueIdentifier, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlInt16 ()
{
SqlParameter parameter;
SqlInt16 value = new SqlInt16 ((short) 5);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.SmallInt, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlInt16.Null;
Assert.AreEqual (SqlDbType.SmallInt, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlInt16.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlInt16.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.SmallInt, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlInt32 ()
{
SqlParameter parameter;
SqlInt32 value = new SqlInt32 (5);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Int, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlInt32.Null;
Assert.AreEqual (SqlDbType.Int, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlInt32.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlInt32.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.Int, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlInt64 ()
{
SqlParameter parameter;
SqlInt64 value = new SqlInt64 (5L);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.BigInt, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlInt64.Null;
Assert.AreEqual (SqlDbType.BigInt, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlInt64.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlInt64.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.BigInt, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlMoney ()
{
SqlParameter parameter;
SqlMoney value = new SqlMoney (45m);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Money, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlMoney.Null;
Assert.AreEqual (SqlDbType.Money, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlMoney.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlMoney.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.Money, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlSingle ()
{
SqlParameter parameter;
SqlSingle value = new SqlSingle (45f);
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Real, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlSingle.Null;
Assert.AreEqual (SqlDbType.Real, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlSingle.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlSingle.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.Real, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlString ()
{
SqlParameter parameter;
SqlString value = new SqlString ("XA");
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreEqual (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlString.Null;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (SqlString.Null, parameter.SqlValue, "#B:SqlValue");
Assert.AreEqual (SqlString.Null, parameter.Value, "#B:Value");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.NVarChar, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreEqual (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void SqlTypes_SqlXml ()
{
SqlParameter parameter;
SqlXml value = new SqlXml (new XmlTextReader (new StringReader ("<test>Mono</test>")));
parameter = new SqlParameter ();
parameter.SqlValue = value;
Assert.AreEqual (SqlDbType.Xml, parameter.SqlDbType, "#A:SqlDbType");
Assert.AreSame (value, parameter.SqlValue, "#A:SqlValue");
Assert.AreSame (value, parameter.Value, "#A:Value");
parameter = new SqlParameter ();
parameter.SqlValue = SqlXml.Null;
Assert.AreEqual (SqlDbType.Xml, parameter.SqlDbType, "#B:SqlDbType");
Assert.IsNotNull (parameter.SqlValue, "#B:SqlValue1");
Assert.AreEqual (typeof (SqlXml), parameter.SqlValue.GetType (), "#B:SqlValue2");
Assert.IsTrue (((SqlXml) parameter.SqlValue).IsNull, "#B:SqlValue3");
Assert.IsNotNull (parameter.Value, "#B:Value1");
Assert.AreEqual (typeof (SqlXml), parameter.Value.GetType (), "#B:Value2");
Assert.IsTrue (((SqlXml) parameter.Value).IsNull, "#B:Value3");
parameter = new SqlParameter ();
parameter.Value = value;
Assert.AreEqual (SqlDbType.Xml, parameter.SqlDbType, "#C:SqlDbType");
Assert.AreSame (value, parameter.SqlValue, "#C:SqlValue");
Assert.AreSame (value, parameter.Value, "#C:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void Value ()
{
SqlParameter p;
p = new SqlParameter ("name", (Object) null);
p.Value = 42;
Assert.AreEqual (DbType.Int32, p.DbType, "#A:DbType");
Assert.AreEqual (SqlDbType.Int, p.SqlDbType, "#A:SqlDbType");
Assert.AreEqual (42, p.Value, "#A:Value");
p.Value = DBNull.Value;
Assert.AreEqual (DbType.String, p.DbType, "#B:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#B:SqlDbType");
Assert.AreEqual (DBNull.Value, p.Value, "#B:Value");
p.Value = DateTime.MaxValue;
Assert.AreEqual (DbType.DateTime, p.DbType, "#C:DbType");
Assert.AreEqual (SqlDbType.DateTime, p.SqlDbType, "#C:SqlDbType");
Assert.AreEqual (DateTime.MaxValue, p.Value, "#C:Value");
p.Value = null;
Assert.AreEqual (DbType.String, p.DbType, "#D:DbType");
Assert.AreEqual (SqlDbType.NVarChar, p.SqlDbType, "#D:SqlDbType");
Assert.IsNull (p.Value, "#D:Value");
p = new SqlParameter ("zipcode", SqlDbType.Int);
p.Value = DateTime.MaxValue;
Assert.AreEqual (DbType.Int32, p.DbType, "#E:DbType");
Assert.AreEqual (SqlDbType.Int, p.SqlDbType, "#E:SqlDbType");
Assert.AreEqual (DateTime.MaxValue, p.Value, "#E:Value");
p.Value = null;
Assert.AreEqual (DbType.Int32, p.DbType, "#F:DbType");
Assert.AreEqual (SqlDbType.Int, p.SqlDbType, "#F:SqlDbType");
Assert.IsNull (p.Value, "#F:Value");
p.Value = DBNull.Value;
Assert.AreEqual (DbType.Int32, p.DbType, "#G:DbType");
Assert.AreEqual (SqlDbType.Int, p.SqlDbType, "#G:SqlDbType");
Assert.AreEqual (DBNull.Value, p.Value, "#G:Value");
}
[Test]
#if FEATURE_NO_BSD_SOCKETS
[ExpectedException (typeof (PlatformNotSupportedException))]
#endif
public void XmlSchemaTest ()
{
SqlParameter p1 = new SqlParameter ();
//Testing default values
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionDatabase,
"#1 Default value for XmlSchemaCollectionDatabase is an empty string");
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionName,
"#2 Default value for XmlSchemaCollectionName is an empty string");
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionOwningSchema,
"#3 Default value for XmlSchemaCollectionOwningSchema is an empty string");
//Changing one property should not affect the remaining two properties
p1.XmlSchemaCollectionDatabase = "database";
Assert.AreEqual ("database", p1.XmlSchemaCollectionDatabase,
"#4 Default value for XmlSchemaCollectionDatabase is an empty string");
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionName,
"#5 Default value for XmlSchemaCollectionName is an empty string");
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionOwningSchema,
"#6 Default value for XmlSchemaCollectionOwningSchema is an empty string");
p1.XmlSchemaCollectionName = "name";
Assert.AreEqual ("database", p1.XmlSchemaCollectionDatabase,
"#7 Default value for XmlSchemaCollectionDatabase is an empty string");
Assert.AreEqual ("name", p1.XmlSchemaCollectionName,
"#8 Default value for XmlSchemaCollectionName is an empty string");
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionOwningSchema,
"#9 Default value for XmlSchemaCollectionOwningSchema is an empty string");
p1.XmlSchemaCollectionOwningSchema = "schema";
Assert.AreEqual ("database", p1.XmlSchemaCollectionDatabase,
"#10 Default value for XmlSchemaCollectionDatabase is an empty string");
Assert.AreEqual ("name", p1.XmlSchemaCollectionName,
"#11 Default value for XmlSchemaCollectionName is an empty string");
Assert.AreEqual ("schema", p1.XmlSchemaCollectionOwningSchema,
"#12 Default value for XmlSchemaCollectionOwningSchema is an empty string");
//assigning null value stores default empty string
p1.XmlSchemaCollectionDatabase = null;
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionDatabase,
"#13 Default value for XmlSchemaCollectionDatabase is an empty string");
Assert.AreEqual ("name", p1.XmlSchemaCollectionName,
"#14 Default value for XmlSchemaCollectionName is an empty string");
Assert.AreEqual ("schema", p1.XmlSchemaCollectionOwningSchema,
"#15 Default value for XmlSchemaCollectionOwningSchema is an empty string");
p1.XmlSchemaCollectionName = "";
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionDatabase,
"#16 Default value for XmlSchemaCollectionDatabase is an empty string");
Assert.AreEqual ("", p1.XmlSchemaCollectionName,
"#17 Default value for XmlSchemaCollectionName is an empty string");
Assert.AreEqual ("schema", p1.XmlSchemaCollectionOwningSchema,
"#18 Default value for XmlSchemaCollectionOwningSchema is an empty string");
//values are not trimmed
p1.XmlSchemaCollectionOwningSchema = " a ";
Assert.AreEqual (String.Empty, p1.XmlSchemaCollectionDatabase,
"#19 Default value for XmlSchemaCollectionDatabase is an empty string");
Assert.AreEqual ("", p1.XmlSchemaCollectionName,
"#20 Default value for XmlSchemaCollectionName is an empty string");
Assert.AreEqual (" a ", p1.XmlSchemaCollectionOwningSchema,
"#21 Default value for XmlSchemaCollectionOwningSchema is an empty string");
}
private enum ByteEnum : byte
{
A = 0x0a,
B = 0x0d
}
private enum Int64Enum : long
{
A = long.MinValue,
B = long.MaxValue
}
}
}