本文整理汇总了C#中Dialect.AppendLockHint方法的典型用法代码示例。如果您正苦于以下问题：C# Dialect.AppendLockHint方法的具体用法？C# Dialect.AppendLockHint怎么用？C# Dialect.AppendLockHint使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Dialect的用法示例。
在下文中一共展示了Dialect.AppendLockHint方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: TableStructure
public TableStructure(Dialect.Dialect dialect, string tableName, string valueColumnName, int initialValue,
int incrementSize)
{
this.tableName = tableName;
this.valueColumnName = valueColumnName;
this.initialValue = initialValue;
this.incrementSize = incrementSize;
SqlStringBuilder b = new SqlStringBuilder();
b.Add("select ").Add(valueColumnName).Add(" id_val").Add(" from ").Add(dialect.AppendLockHint(LockMode.Upgrade,
tableName)).Add(
dialect.ForUpdateString);
select = b.ToSqlString();
b = new SqlStringBuilder();
b.Add("update ").Add(tableName).Add(" set ").Add(valueColumnName).Add(" = ").Add(Parameter.Placeholder).Add(" where ")
.Add(valueColumnName).Add(" = ").Add(Parameter.Placeholder);
update = b.ToSqlString();
}示例2: TableStructure
public TableStructure(Dialect.Dialect dialect, string tableName, string valueColumnName, int initialValue, int incrementSize)
{
_tableName = tableName;
_valueColumnName = valueColumnName;
_initialValue = initialValue;
_incrementSize = incrementSize;
_selectQuery = new SqlString(
"select ", valueColumnName, " as id_val from ",
dialect.AppendLockHint(LockMode.Upgrade, tableName),
dialect.ForUpdateString);
_updateQuery = new SqlString(
"update ", tableName,
" set ", valueColumnName, " = ", Parameter.Placeholder,
" where ", valueColumnName, " = ", Parameter.Placeholder);
_updateParameterTypes = new[]
{
SqlTypeFactory.Int64,
SqlTypeFactory.Int64,
};
}示例3: TableStructure
public TableStructure(Dialect.Dialect dialect, string tableName, string valueColumnName, int initialValue, int incrementSize)
{
_tableName = tableName;
_valueColumnName = valueColumnName;
_initialValue = initialValue;
_incrementSize = incrementSize;
var b = new SqlStringBuilder();
b.Add("select ").Add(valueColumnName).Add(" as id_val").Add(" from ").Add(dialect.AppendLockHint(LockMode.Upgrade, tableName))
.Add(dialect.ForUpdateString);
_selectQuery = b.ToSqlString();
b = new SqlStringBuilder();
b.Add("update ").Add(tableName).Add(" set ").Add(valueColumnName).Add(" = ").Add(Parameter.Placeholder).Add(" where ")
.Add(valueColumnName).Add(" = ").Add(Parameter.Placeholder);
_updateQuery = b.ToSqlString();
_updateParameterTypes = new[]
{
SqlTypeFactory.Int64,
SqlTypeFactory.Int64,
};
}