public void GetLimitClauseCriteriaForBegin_ShouldFormatTopWithBrackets()
{
//---------------Set up test pack-------------------
var sqlFormatter = new SqlFormatterForSqlServerCe("[", "]", "TOP", "");
int limit = TestUtil.GetRandomInt();
//---------------Assert Precondition----------------
Assert.AreEqual("TOP", sqlFormatter.LimitClauseAtBeginning);
//---------------Execute Test ----------------------
string limitClauseCriteriaForBegin = sqlFormatter.GetLimitClauseCriteriaForBegin(limit);
//---------------Test Result -----------------------
string expected = string.Format("TOP({0})", limit);
Assert.AreEqual(expected,limitClauseCriteriaForBegin);
}
/// <summary>
/// Constructor to initialise the connection object with an
/// assembly name, class name and connection string
/// </summary>
/// <param name="assemblyName">The assembly name</param>
/// <param name="className">The class name</param>
/// <param name="connectString">The connection string, which can be
/// generated using ConnectionStringSqlServerFactory.CreateConnectionString()
/// </param>
public DatabaseConnectionSqlServerCe(string assemblyName, string className, string connectString)
: base(assemblyName, className, connectString)
{
_sqlFormatter = new SqlFormatterForSqlServerCe("[", "]", "TOP", "");
}
/// <summary>
/// Constructor to initialise the connection object with an
/// assembly name, class name and connection string
/// </summary>
/// <param name="assemblyName">The assembly name</param>
/// <param name="className">The class name</param>
/// <param name="connectString">The connection string, which can be
/// generated using ConnectionStringSqlServerFactory.CreateConnectionString()
/// </param>
public DatabaseConnectionSqlServerCe(string assemblyName, string className, string connectString)
: base(assemblyName, className, connectString)
{
_sqlFormatter = new SqlFormatterForSqlServerCe("[", "]", "TOP", "");
}