本文整理汇总了C#中IDatabase.FormatTableName方法的典型用法代码示例。如果您正苦于以下问题：C# IDatabase.FormatTableName方法的具体用法？C# IDatabase.FormatTableName怎么用？C# IDatabase.FormatTableName使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IDatabase的用法示例。
在下文中一共展示了IDatabase.FormatTableName方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetTableExistsSql
protected string GetTableExistsSql(IDatabase db, string tablename)
{
return string.Format(db is SqlServerUsingRealTables || db is SqlServerUsingTempDb
? "object_id('{0}', 'U') is not null"
: "OBJECT_ID('tempdb..{0}') is not null",
db.FormatTableName(tablename));
}示例2: GetTableExistsSql
protected string GetTableExistsSql(IDatabase db, string tablename)
{
return string.Format(db is SqlServerUsingRealTables || db is SqlServerUsingTempDb
? "exists (select * from information_schema.tables where table_catalog = db_name() and table_name = '{0}')"
: "OBJECT_ID('tempdb..{0}') is not null",
db.FormatTableName(tablename));
}示例3: Execute
public override void Execute(IDatabase database)
{
var builder = new SqlBuilder();
var formattedAndEscapedTableName = database.FormatTableNameAndEscape(TableName);
var escapedColumnName = database.Escape(Column.Name);
//DROP CONSTRAINTS
foreach (var constraintName in (database is SqlServerUsingTempTables ? tempTablesConstraintQueries : constraintQueries)
.Select(x => database.RawQuery<string>(x, new { TableName = database.FormatTableName(TableName), ColumnName = Column.Name }))
.Select(x => x.SingleOrDefault())
.Where(x => x != null))
{
builder.Append("ALTER TABLE {0} DROP CONSTRAINT {1};", formattedAndEscapedTableName, database.Escape(constraintName));
}
builder
//ALTER TABLE
.Append(GetAlterTableStatement(formattedAndEscapedTableName, escapedColumnName))
//DEFAULT CONSTRAINT
.Append(Column.DefaultValue != null, "ALTER TABLE {0} ADD DEFAULT '{1}' FOR {2};", formattedAndEscapedTableName, Column.DefaultValue, escapedColumnName)
//PRIMAY KEY
.Append(Column.IsPrimaryKey, @"ALTER TABLE {0} ADD PRIMARY KEY ({1});", formattedAndEscapedTableName, escapedColumnName);
database.RawExecute(builder.ToString());
}