public void Test_On_13() { //结果 var result = new Str(); result.Append("Join [Sample] As [t] "); result.AppendLine("On [a].[id]=@_p_0 "); result.Append("Join [Sample2] As [t2] "); result.Append("On [t].[ShortValue]>[t2].[IntValue] And [t].[IntValue]=@_p_1"); //操作 _clause.Join <Sample>("t"); _clause.On("a.id", "b"); _clause.Join <Sample2>("t2"); _clause.On <Sample, Sample2>((l, r) => l.ShortValue > r.IntValue && l.IntValue == 1); //验证 Assert.Equal(result.ToString(), GetSql()); Assert.Equal("b", _parameterManager.GetParams()["@_p_0"]); Assert.Equal(1, _parameterManager.GetParams()["@_p_1"]); }
public void TestBetween_1() { //结果 var result = new String(); result.Append("Where [a].[B]>=@_p_0 And [a].[B]<=@_p_1"); //执行 _clause.Between("a.B", 1, 2, Boundary.Both); //验证 Assert.Equal(1, _parameterManager.GetParams()["@_p_0"]); Assert.Equal(2, _parameterManager.GetParams()["@_p_1"]); Assert.Equal(result.ToString(), GetSql()); }
public void TestResolve_2() { Expression <Func <Sample, bool> > expression = t => t.Email == "a"; Assert.Equal("[Email]=@_p_0", _resolver.Resolve(expression).GetCondition()); Assert.Equal("a", _parameterManager.GetParams()["@_p_0"]); }