本文整理匯總了C#中NHibernate.SqlCommand.SqlString.SubstringStartingWithLast方法的典型用法代碼示例。如果您正苦於以下問題：C# SqlString.SubstringStartingWithLast方法的具體用法？C# SqlString.SubstringStartingWithLast怎麽用？C# SqlString.SubstringStartingWithLast使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類NHibernate.SqlCommand.SqlString的用法示例。
在下文中一共展示了SqlString.SubstringStartingWithLast方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: SubstringStartingWithLastMultiplePossibilities
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());
}示例2: NoSubstringStartingWithLast
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());
}示例3: SubstringStartingWithLastAndParameters
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"));
}示例4: GetRowNumber
private static string GetRowNumber(SqlString sql)
{
return new StringBuilder()
.Append("rownumber() over(")
.Append(sql.SubstringStartingWithLast("order by"))
.Append(") as rownum, ")
.ToString();
}