C# (CSharp) SqlFormat.ForeignKeyFormat Examples

Example #1

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

        public void TestForeignKey()
        {
            string v;
            int    d;

            d = -1;
            v = SqlFormat.ForeignKeyFormat(d);
            AssertAreEqual(v, "NULL", "ForeignKey int 1");

            d = 0;
            v = SqlFormat.ForeignKeyFormat(d);
            AssertAreEqual(v, "NULL", "ForeignKey int 2");

            d = 56;
            v = SqlFormat.ForeignKeyFormat(d);
            AssertAreEqual(v, "56", "ForeignKey int 3");

            long l;

            l = -1;
            v = SqlFormat.ForeignKeyFormat(l);
            AssertAreEqual(v, "NULL", "ForeignKey long 4");

            l = 0;
            v = SqlFormat.ForeignKeyFormat(l);
            AssertAreEqual(v, "NULL", "ForeignKey int 5");

            l = 56;
            v = SqlFormat.ForeignKeyFormat(l);
            AssertAreEqual(v, "56", "ForeignKey int 6");
        }