public void ResolveSqlNoParams() { var query = new ActiveEmployees(); string sql = QueryUtil.ResolveSql(query.Sql, query); Assert.IsTrue(sql.Equals("SELECT * FROM [Employee] WHERE [IsActive]=@isActive ORDER BY [Nothing]")); }
public void ResolveSqlWithQuery() { var query = new ActiveEmployees() { LastName = "hello" }; string sql = QueryUtil.ResolveSql(query.Sql, query); Assert.IsTrue(sql.Equals("SELECT * FROM [Employee] WHERE [IsActive]=@isActive AND [LastName] LIKE @lastName ORDER BY [Nothing]")); }
public void ResolveSqlWithParams() { var query = new ActiveEmployees() { LastName = "hello", IsActive = true }; string sql = QueryUtil.ResolveSql(query.Sql, query, out DynamicParameters queryParams); Assert.IsTrue(queryParams.Get <string>("LastName").Equals("hello")); Assert.IsTrue(queryParams.Get <bool>("IsActive").Equals(true)); }