System.Data.SqlTypes.SqlInt64.ToSqlDouble C# (CSharp) Method

ToSqlDouble() public method

public ToSqlDouble ( ) : SqlDouble
return SqlDouble
        public SqlDouble ToSqlDouble()
        {
            return this;
        }

Usage Example

Ejemplo n.º 1
0
		public void Conversions ()
		{
			SqlInt64 Test12 = new SqlInt64 (12);
			SqlInt64 Test0 = new SqlInt64 (0);
			SqlInt64 TestNull = SqlInt64.Null;
			SqlInt64 Test1000 = new SqlInt64 (1000);
			SqlInt64 Test288 = new SqlInt64 (288);

			// ToSqlBoolean ()
			Assert.IsTrue (Test12.ToSqlBoolean ().Value, "#P01");
			Assert.IsTrue (!Test0.ToSqlBoolean ().Value, "#P02");
			Assert.IsTrue (TestNull.ToSqlBoolean ().IsNull, "#P03");

			// ToSqlByte ()
			Assert.AreEqual ((byte) 12, Test12.ToSqlByte ().Value, "#P04");
			Assert.AreEqual ((byte) 0, Test0.ToSqlByte ().Value, "#P05");

			try {
				SqlByte b = (byte) Test1000.ToSqlByte ();
				Assert.Fail ("#P06");
			} catch (OverflowException e) {
				Assert.AreEqual (typeof (OverflowException), e.GetType (), "#P07");
			}

			// ToSqlDecimal ()
			Assert.AreEqual ((decimal) 12, Test12.ToSqlDecimal ().Value, "#P08");
			Assert.AreEqual ((decimal) 0, Test0.ToSqlDecimal ().Value, "#P09");
			Assert.AreEqual ((decimal) 288, Test288.ToSqlDecimal ().Value, "#P10");

			// ToSqlDouble ()
			Assert.AreEqual ((double) 12, Test12.ToSqlDouble ().Value, "#P11");
			Assert.AreEqual ((double) 0, Test0.ToSqlDouble ().Value, "#P12");
			Assert.AreEqual ((double) 1000, Test1000.ToSqlDouble ().Value, "#P13");

			// ToSqlInt32 ()
			Assert.AreEqual ((int) 12, Test12.ToSqlInt32 ().Value, "#P14");
			Assert.AreEqual ((int) 0, Test0.ToSqlInt32 ().Value, "#P15");
			Assert.AreEqual ((int) 288, Test288.ToSqlInt32 ().Value, "#P16");

			// ToSqlInt16 ()
			Assert.AreEqual ((short) 12, Test12.ToSqlInt16 ().Value, "#P17");
			Assert.AreEqual ((short) 0, Test0.ToSqlInt16 ().Value, "#P18");
			Assert.AreEqual ((short) 288, Test288.ToSqlInt16 ().Value, "#P19");

			// ToSqlMoney ()
			Assert.AreEqual (12.0000M, Test12.ToSqlMoney ().Value, "#P20");
			Assert.AreEqual ((decimal) 0, Test0.ToSqlMoney ().Value, "#P21");
			Assert.AreEqual (288.0000M, Test288.ToSqlMoney ().Value, "#P22");

			// ToSqlSingle ()
			Assert.AreEqual ((float) 12, Test12.ToSqlSingle ().Value, "#P23");
			Assert.AreEqual ((float) 0, Test0.ToSqlSingle ().Value, "#P24");
			Assert.AreEqual ((float) 288, Test288.ToSqlSingle ().Value, "#P25");

			// ToSqlString ()
			Assert.AreEqual ("12", Test12.ToSqlString ().Value, "#P26");
			Assert.AreEqual ("0", Test0.ToSqlString ().Value, "#P27");
			Assert.AreEqual ("288", Test288.ToSqlString ().Value, "#P28");

			// ToString ()
			Assert.AreEqual ("12", Test12.ToString (), "#P29");
			Assert.AreEqual ("0", Test0.ToString (), "#P30");
			Assert.AreEqual ("288", Test288.ToString (), "#P31");
		}
All Usage Examples Of System.Data.SqlTypes.SqlInt64::ToSqlDouble