public void GetIfNullExpressionTest()
        {
            MSSQLDataService ds = CreateMSSQLDataServiceForTests();

            string exp = ds.GetIfNullExpression("identifier1", "identifier2");

            Assert.Equal("ISNULL(identifier1, identifier2)", exp);

            exp = ds.GetIfNullExpression("identifier3", "identifier4", "identifier5");
            Assert.Equal("ISNULL(identifier3, ISNULL(identifier4, identifier5))", exp);

            exp = ds.GetIfNullExpression("identifier6");
            Assert.Equal("identifier6", exp);

            exp = ds.GetIfNullExpression(string.Empty);
            Assert.Equal(string.Empty, exp);
        }
        public void GetIfNullExpressionEmptyArrayTest()
        {
            var exception = Xunit.Record.Exception(() =>
            {
                MSSQLDataService ds = CreateMSSQLDataServiceForTests();
                ds.GetIfNullExpression(new string[] { });
            });

            Assert.IsType(typeof(ArgumentException), exception);
        }
        public void GetIfNullExpressionNullTest()
        {
            var exception = Xunit.Record.Exception(() =>
            {
                MSSQLDataService ds = CreateMSSQLDataServiceForTests();
                ds.GetIfNullExpression(null);
            });

            Assert.IsType(typeof(ArgumentNullException), exception);
        }