using Microsoft.VisualStudio.TestTools.UnitTesting;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using FluentAssertions;

namespace UnitTestProject1
{
    public class Foo
    {
        public string Bar => "FOOBAR";
        public List<SqlParameter> Parameters => new List<SqlParameter> {
            new SqlParameter("@inBar", DBNull.Value),
            new SqlParameter("@inSettings", Bar),
        };

    }

    [TestClass]
    public class UnitTest1
    {
        [TestMethod]
        public void TestMethod1()
        {
            var sut = new Foo();

            sut.Parameters.Should().ContainEquivalentOf(new SqlParameter("@inBar", DBNull.Value));

            if (!string.IsNullOrEmpty(sut.Bar))
                sut.Parameters.Should().ContainEquivalentOf(new SqlParameter("@inSettings", sut.Bar));
        }
    }
}