private static string GetRowNumber(SqlString sql)
{
return(new StringBuilder()
.Append("rownumber() over(")
.Append(sql.SubstringStartingWithLast("order by"))
.Append(") as rownum, ")
.ToString());
}
public void SubstringStartingWithLastAndParameters()
{
SqlString sql =
new SqlString(
new object[] { "select x from y where z = ", Parameter.Placeholder, " order by ", Parameter.Placeholder });
Assert.AreEqual(new SqlString(new object[] { "order by ", Parameter.Placeholder }),
sql.SubstringStartingWithLast("order by"));
}
public void SubstringStartingWithLastMultiplePossibilities()
{
SqlString sql = new SqlString(new string[] { " order by x", " order by z" });
Assert.AreEqual("order by z", sql.SubstringStartingWithLast("order by").ToString());
}
public void NoSubstringStartingWithLast()
{
SqlString sql = new SqlString(new object[] { "select x from y where z = ", Parameter.Placeholder, " order by t" });
Assert.AreEqual("", sql.SubstringStartingWithLast("zzz").ToString());
}