本文整理匯總了C#中Columns.Any方法的典型用法代碼示例。如果您正苦於以下問題：C# Columns.Any方法的具體用法？C# Columns.Any怎麽用？C# Columns.Any使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Columns的用法示例。
在下文中一共展示了Columns.Any方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: ConfigureCreateCommand
/// <summary>
/// 添加數據。
/// </summary>
/// <param name="command">SQL命令執行對象</param>
/// <param name="tableName">表名稱</param>
/// <param name="allColumns">所有列信息</param>
/// <returns>命令執行對象</returns>
protected override void ConfigureCreateCommand(DbCommand command, string tableName, Columns allColumns)
{
var index = 1;
var insertColumns = allColumns.Where(c => !c.IsIdentity);
var commandTextBuilder = new StringBuilder();
commandTextBuilder.AppendFormat("INSERT INTO {0} (", this.GetSafeTableName(tableName));
foreach (var column in insertColumns)
{
commandTextBuilder.AppendFormat(index++ == insertColumns.Count() ? "\"{0}\"" : "\"{0}\",", column.Name);
}
commandTextBuilder.AppendFormat(") VALUES (");
index = 1;
foreach (var item in insertColumns)
{
var format = index++ == insertColumns.Count() ? ":{0}" : ":{0}, ";
commandTextBuilder.AppendFormat(format, item.Name);
command.AddParameter($":{item.Name}", item.Value, this._dbTypeResolve.GetDbType(item.DataType));
}
commandTextBuilder.Append(")");
if (allColumns.Any(c => c.IsIdentity))
{
var identity = allColumns.First(i => i.IsIdentity);
commandTextBuilder.AppendFormat(";SELECT currval(pg_get_serial_sequence('{0}', '{1}'));", this.GetSafeTableName(tableName), identity.Name);
}
command.CommandType = CommandType.Text;
command.CommandText = commandTextBuilder.ToString();
this.RecordCommandInfo("添加記錄", command);
}示例2: ConfigureCreateCommand
/// <summary>
/// 添加數據。
/// </summary>
/// <param name="command">SQL命令執行對象</param>
/// <param name="tableName">表名稱</param>
/// <param name="allColumns">所有列信息</param>
/// <returns>命令執行對象</returns>
protected override void ConfigureCreateCommand(DbCommand command, string tableName, Columns allColumns)
{
var index = 1;
var insertColumns = allColumns.Where(c => !c.IsIdentity);
var commandTextBuilder = new StringBuilder();
commandTextBuilder.AppendFormat("INSERT INTO {0} (", this.GetSafeTableName(tableName));
foreach (var column in insertColumns)
{
commandTextBuilder.AppendFormat(index++ == insertColumns.Count() ? "[{0}]" : "[{0}],", column.Name);
}
commandTextBuilder.AppendFormat(") VALUES (");
index = 1;
foreach (var item in insertColumns)
{
var format = index++ == insertColumns.Count() ? "@{0}" : "@{0}, ";
commandTextBuilder.AppendFormat(format, item.Name);
command.AddParameter($"@{item.Name}", item.Value);
}
commandTextBuilder.Append(")");
if (allColumns.Any(c => c.IsIdentity))
{
commandTextBuilder.Append(";SELECT @@IDENTITY;");
}
command.CommandType = CommandType.Text;
command.CommandText = commandTextBuilder.ToString();
this.RecordCommandInfo("添加記錄", command);
}