public void Test_GetLimitClauseForBegin_HasNotClauseSet()
{
//---------------Set up test pack-------------------
const string limitClauseAtBeginning = "";
SqlFormatter sqlFormatter = new SqlFormatter("", "", limitClauseAtBeginning, "");
//---------------Assert Precondition----------------
Assert.AreEqual("", sqlFormatter.LimitClauseAtBeginning);
//---------------Execute Test ----------------------
string limitClauseForBegin = sqlFormatter.GetLimitClauseCriteriaForBegin(10);
//---------------Test Result -----------------------
Assert.AreEqual("", limitClauseForBegin);
}
public void Test_GetLimitClauseForBegin()
{
//---------------Set up test pack-------------------
const string limitClauseAtBeginning = "TOP";
SqlFormatter sqlFormatter = new SqlFormatter("", "", limitClauseAtBeginning, "");
//---------------Assert Precondition----------------
Assert.AreEqual(limitClauseAtBeginning, sqlFormatter.LimitClauseAtBeginning);
//---------------Execute Test ----------------------
string limitClauseForBegin = sqlFormatter.GetLimitClauseCriteriaForBegin(10);
//---------------Test Result -----------------------
const string expectedLimitClauseForEnd = limitClauseAtBeginning + " 10";
Assert.AreEqual(expectedLimitClauseForEnd, limitClauseForBegin);
}
