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()); }