本文整理汇总了C#中SqlBuilder.ToString方法的典型用法代码示例。如果您正苦于以下问题：C# SqlBuilder.ToString方法的具体用法？C# SqlBuilder.ToString怎么用？C# SqlBuilder.ToString使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SqlBuilder的用法示例。
在下文中一共展示了SqlBuilder.ToString方法的12个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Execute
public override void Execute(IDatabase database)
{
if (!Table.Columns.Any())
{
throw new InvalidOperationException("Cannot create a table with no columns.");
}
var sql = new SqlBuilder();
sql.Append("if not ({0}) begin create table {1} (",
GetTableExistsSql(database, Table.Name),
database.FormatTableNameAndEscape(Table.Name));
var i = 0;
foreach (var column in Table.Columns)
{
var sqlBuilder = new SqlBuilder()
.Append(i > 0, ",")
.Append(database.Escape(column.Name))
.Append(GetColumnSqlType(column, i.ToString()));
sql.Append(sqlBuilder);
i++;
}
sql.Append("); end;");
database.RawExecute(sql.ToString());
}示例2: Execute
public override void Execute(IDatabase database)
{
var sql = new SqlBuilder();
sql.Append("alter table {0} add {1}", database.FormatTableNameAndEscape(Tablename), database.Escape(Column.Name));
sql.Append(GetColumnSqlType(Column));
database.RawExecute(sql.ToString());
}示例3: DeleteRecord
public string DeleteRecord(DatasetInfo table)
{
var sql = new SqlBuilder(adapter);
sql.Delete(new SchemaObject(table.Name), GetKeyFilter(table));
return sql.ToString();
}示例4: InsertRecord
public string InsertRecord(DatasetInfo table)
{
var sql = new SqlBuilder(adapter);
var insertColumns = table.Members.Where(c => !c.IsGenerated);
sql.InsertInto(new SchemaObject(table.Name), members: table.Members.Where(c => !c.IsGenerated));
return sql.ToString();
}示例5: UpdateRecord
public string UpdateRecord(DatasetInfo table)
{
var updateColumns = table.Members.Where(c => c.IsMutable || c.IsVersion).ToArray();
var sql = new SqlBuilder(adapter);
sql.Update(
table : new SchemaObject(table.Name),
columns : updateColumns,
condition : GetKeyFilter(table)
);
return sql.ToString();
}示例6: SqlEquals
public static bool SqlEquals(SqlSet set, SqlBuilder query)
{
return String.Equals(Regex.Replace(set.ToString(), "dbex_set[0-9]+", "_"), query.ToString(), StringComparison.Ordinal);
}示例7: QueryFirst
public SqlQuery QueryFirst(DatasetInfo dataset, Expression expression)
{
var sql = new SqlBuilder(adapter)
.Select(dataset.Members)
.From(dataset.Name)
.Where(expression)
.Limit(1);
return new SqlQuery(sql.ToString(), sql.Parameters);
}示例8: QueryRecords
public SqlQuery QueryRecords(DatasetInfo dataset, Expression expression)
{
var builder = new SqlBuilder(adapter)
.Select(dataset.Members)
.From(dataset.Name)
.Where(expression);
return new SqlQuery(builder.ToString(), builder.Parameters);
}示例9: QueryVersions
public SqlQuery QueryVersions(DatasetInfo baseTable, DatasetInfo versionedTable, Expression expression)
{
var sql = new SqlBuilder(adapter);
var v = new SchemaObject(versionedTable.Name, "v");
var a = new SchemaObject(baseTable.Name, "a");
sql.Append("SELECT ");
sql.WriteColumns(versionedTable.Members, prefix: "v"); // mutable values, primary keys, ...
sql.Append(", ");
sql.WriteColumns(baseTable.Members.Where(m => !m.IsVersion && !m.IsKey && !m.IsMutable), prefix: "a"); // immutable values from base table
sql.From(v); // SELECT from v
var keyName = baseTable.PrimaryKey[0].Name;
// join the base (immutable) values with the versioned values
sql.InnerJoin(
baseTable : v, // versioned values
joinedTable : a, // base values
baseColumn : keyName,
joinedColumn : keyName
);
sql.Where(Expand(expression, baseTable));
return new SqlQuery(sql.ToString(), sql.Parameters);
}示例10: 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());
}示例11: GetAlterTableStatement
string GetAlterTableStatement(string formattedAndEscapedTableName, string escapedColumnName)
{
var builder = new SqlBuilder();
var sqlColumn = SqlTypeMap.Convert(Column);
builder
.Append("ALTER TABLE {0} ALTER COLUMN {1}", formattedAndEscapedTableName, escapedColumnName)
.Append(new SqlParameter {DbType = sqlColumn.DbType}.SqlDbType.ToString())
.Append(sqlColumn.Length != null, "(" + sqlColumn.Length + ")")
.Append(Column.Nullable, "NULL").Or("NOT NULL")
.Append(";");
return builder.ToString();
}示例12: Execute
public sealed override void Execute(IDatabase database)
{
var sql = new SqlBuilder();
builder(sql, database);
database.RawExecute(sql.ToString());
}