C# (CSharp) SqlFormat.DecimalFormat Examples

Example #1

File: TestSqlFormat.cs Project: slewden/BaseSaver.Data

        public void TestDecimalFormat()
        {
            decimal?d;
            string  v;

            d = null;
            v = SqlFormat.DecimalFormat(d);
            AssertAreEqual(v, "NULL", "Décimal? null");

            d = 4.5m;
            v = SqlFormat.DecimalFormat(d);
            AssertAreEqual(v, "4.5", "Décimal 4,5");

            v = SqlFormat.DecimalFormat(decimal.MinValue, false);
            AssertAreEqual(v, "0", "Décimal min non null");

            v = SqlFormat.DecimalFormat(decimal.MaxValue, false);
            AssertAreEqual(v, "0", "Décimal min non null");

            v = SqlFormat.DecimalFormat(decimal.MinValue, true);
            AssertAreEqual(v, "NULL", "Décimal min null");
        }