Tests.InsightTests.Test1 C# (CSharp) Method

        public void Test1()
        {
            var b = new SqlBuilder();
            var p = new { a = 123 };
            var t = b.AddTemplate("select @a {{WHERE}}", p);

            b.Where("@b = @c", new { b = "abc", c = "abc" });


            int res;
            using (var db = new SqlConnection(ConnectionStrings.Default))
            {
                res = db.SingleSql<int>(t.RawSql, t.Parameters);
            }
            Assert.AreEqual(p.a, res);
        }