本文整理汇总了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();
}