本文整理汇总了C#中Aurora.Framework.ColumnDefinition.Where方法的典型用法代码示例。如果您正苦于以下问题：C# ColumnDefinition.Where方法的具体用法？C# ColumnDefinition.Where怎么用？C# ColumnDefinition.Where使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Aurora.Framework.ColumnDefinition的用法示例。
在下文中一共展示了ColumnDefinition.Where方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: UpdateTable
public override void UpdateTable(string table, ColumnDefinition[] columns,
Dictionary<string, string> renameColumns)
{
if (!TableExists(table))
{
throw new DataManagerException("Trying to update a table with name of one that does not exist.");
}
List<ColumnDefinition> oldColumns = ExtractColumnsFromTable(table);
Dictionary<string, ColumnDefinition> sameColumns = new Dictionary<string, ColumnDefinition>();
foreach (ColumnDefinition column in oldColumns)
{
#if (!ISWIN)
foreach (ColumnDefinition innercolumn in columns)
{
if (innercolumn.Name.ToLower() == column.Name.ToLower() || renameColumns.ContainsKey(column.Name) && renameColumns[column.Name].ToLower() == innercolumn.Name.ToLower())
{
sameColumns.Add(column.Name, column);
break;
}
}
#else
if (columns.Any(innercolumn => innercolumn.Name.ToLower() == column.Name.ToLower() ||
renameColumns.ContainsKey(column.Name) &&
renameColumns[column.Name].ToLower() == innercolumn.Name.ToLower()))
{
sameColumns.Add(column.Name, column);
}
#endif
}
string renamedTempTableColumnDefinition = string.Empty;
string renamedTempTableColumn = string.Empty;
foreach (ColumnDefinition column in oldColumns)
{
if (renamedTempTableColumnDefinition != string.Empty)
{
renamedTempTableColumnDefinition += ", ";
renamedTempTableColumn += ", ";
}
renamedTempTableColumn += column.Name;
renamedTempTableColumnDefinition += column.Name + " " + GetColumnTypeStringSymbol(column.Type);
}
string query = "CREATE TABLE " + table + "__temp(" + renamedTempTableColumnDefinition + ");";
var cmd = new SQLiteCommand {CommandText = query};
ExecuteNonQuery(cmd);
CloseReaderCommand(cmd);
query = "INSERT INTO " + table + "__temp SELECT " + renamedTempTableColumn + " from " + table + ";";
cmd = new SQLiteCommand {CommandText = query};
ExecuteNonQuery(cmd);
CloseReaderCommand(cmd);
query = "drop table " + table;
cmd = new SQLiteCommand {CommandText = query};
ExecuteNonQuery(cmd);
CloseReaderCommand(cmd);
string newTableColumnDefinition = string.Empty;
#if (!ISWIN)
List<ColumnDefinition> primaryColumns = new List<ColumnDefinition>();
foreach (ColumnDefinition column in columns)
{
if (column.IsPrimary) primaryColumns.Add(column);
}
#else
List<ColumnDefinition> primaryColumns = columns.Where(column => column.IsPrimary).ToList();
#endif
bool multiplePrimary = primaryColumns.Count > 1;
foreach (ColumnDefinition column in columns)
{
if (newTableColumnDefinition != string.Empty)
{
newTableColumnDefinition += ", ";
}
newTableColumnDefinition += column.Name + " " + GetColumnTypeStringSymbol(column.Type) +
((column.IsPrimary && !multiplePrimary) ? " PRIMARY KEY" : string.Empty);
}
string multiplePrimaryString = string.Empty;
if (multiplePrimary)
{
string listOfPrimaryNamesString = string.Empty;
foreach (ColumnDefinition column in primaryColumns)
{
if (listOfPrimaryNamesString != string.Empty)
{
listOfPrimaryNamesString += ", ";
}
listOfPrimaryNamesString += column.Name;
}
multiplePrimaryString = string.Format(", PRIMARY KEY ({0}) ", listOfPrimaryNamesString);
}
query = string.Format("create table " + table + " ( {0} {1}) ", newTableColumnDefinition,
multiplePrimaryString);
//.........这里部分代码省略.........
示例2: UpdateTable
public override void UpdateTable(string table, ColumnDefinition[] columns, IndexDefinition[] indices, Dictionary<string, string> renameColumns)
{
table = table.ToLower();
if (!TableExists(table))
{
throw new DataManagerException("Trying to update a table with name of one that does not exist.");
}
List<ColumnDefinition> oldColumns = ExtractColumnsFromTable(table);
Dictionary<string, ColumnDefinition> removedColumns = new Dictionary<string, ColumnDefinition>();
Dictionary<string, ColumnDefinition> modifiedColumns = new Dictionary<string, ColumnDefinition>();
#if (!ISWIN)
Dictionary<string, ColumnDefinition> addedColumns = new Dictionary<string, ColumnDefinition>();
foreach (ColumnDefinition column in columns)
{
if (!oldColumns.Contains(column)) addedColumns.Add(column.Name.ToLower(), column);
}
foreach (ColumnDefinition column in oldColumns)
{
if (!columns.Contains(column))
{
if (addedColumns.ContainsKey(column.Name.ToLower()))
{
if (column.Name.ToLower() != addedColumns[column.Name.ToLower()].Name.ToLower() || column.Type != addedColumns[column.Name.ToLower()].Type)
{
modifiedColumns.Add(column.Name.ToLower(), addedColumns[column.Name.ToLower()]);
}
addedColumns.Remove(column.Name.ToLower());
}
else
{
removedColumns.Add(column.Name.ToLower(), column);
}
}
}
#else
Dictionary<string, ColumnDefinition> addedColumns = columns.Where(column => !oldColumns.Contains(column)).ToDictionary(column => column.Name.ToLower());
foreach (ColumnDefinition column in oldColumns.Where(column => !columns.Contains(column)))
{
if (addedColumns.ContainsKey(column.Name.ToLower()))
{
if (column.Name.ToLower() != addedColumns[column.Name.ToLower()].Name.ToLower() || column.Type != addedColumns[column.Name.ToLower()].Type)
{
modifiedColumns.Add(column.Name.ToLower(), addedColumns[column.Name.ToLower()]);
}
addedColumns.Remove(column.Name.ToLower());
}
else{
removedColumns.Add(column.Name.ToLower(), column);
}
}
#endif
try
{
#if (!ISWIN)
foreach (ColumnDefinition column in addedColumns.Values)
{
string addedColumnsQuery = "add `" + column.Name + "` " + GetColumnTypeStringSymbol(column.Type) + " ";
string query = string.Format("alter table " + table + " " + addedColumnsQuery);
ExecuteNonQuery(query, new Dictionary<string, object>());
}
foreach (ColumnDefinition column in modifiedColumns.Values)
{
string modifiedColumnsQuery = "modify column `" + column.Name + "` " + GetColumnTypeStringSymbol(column.Type) + " ";
string query = string.Format("alter table " + table + " " + modifiedColumnsQuery);
ExecuteNonQuery(query, new Dictionary<string, object>());
}
foreach (ColumnDefinition column in removedColumns.Values)
{
string droppedColumnsQuery = "drop `" + column.Name + "` ";
string query = string.Format("alter table " + table + " " + droppedColumnsQuery);
ExecuteNonQuery(query, new Dictionary<string, object>());
}
#else
foreach (string query in addedColumns.Values.Select(column => "add `" + column.Name + "` " + GetColumnTypeStringSymbol(column.Type) +
" ").Select(addedColumnsQuery => string.Format("alter table " + table + " " + addedColumnsQuery)))
{
ExecuteNonQuery(query, new Dictionary<string, object>());
}
foreach (string query in modifiedColumns.Values.Select(column => "modify column `" + column.Name + "` " +
GetColumnTypeStringSymbol(column.Type) + " ").Select(modifiedColumnsQuery => string.Format("alter table " + table + " " + modifiedColumnsQuery)))
{
ExecuteNonQuery(query, new Dictionary<string, object>());
}
foreach (string query in removedColumns.Values.Select(column => "drop `" + column.Name + "` ").Select(droppedColumnsQuery => string.Format("alter table " + table + " " + droppedColumnsQuery)))
{
ExecuteNonQuery(query, new Dictionary<string, object>());
}
#endif
}
catch (Exception e)
{
MainConsole.Instance.Error("[MySQLDataLoader] UpdateTable", e);
}
Dictionary<string, IndexDefinition> oldIndicesDict = ExtractIndicesFromTable(table);
//.........这里部分代码省略.........
示例3: UpdateTable
public override void UpdateTable(string table, ColumnDefinition[] columns)
{
table = table.ToLower ();
if (!TableExists (table))
{
throw new DataManagerException ("Trying to update a table with name of one that does not exist.");
}
List<ColumnDefinition> oldColumns = ExtractColumnsFromTable (table);
Dictionary<string, ColumnDefinition> removedColumns = new Dictionary<string, ColumnDefinition> ();
Dictionary<string, ColumnDefinition> modifiedColumns = new Dictionary<string, ColumnDefinition> ();
Dictionary<string, ColumnDefinition> addedColumns = columns.Where (column => !oldColumns.Contains (column)).ToDictionary (column => column.Name);
foreach (ColumnDefinition column in oldColumns.Where (column => !columns.Contains (column)))
{
if (addedColumns.ContainsKey (column.Name))
{
modifiedColumns.Add (column.Name, addedColumns[column.Name]);
addedColumns.Remove (column.Name);
}
else
removedColumns.Add (column.Name, column);
}
try
{
foreach (ColumnDefinition column in addedColumns.Values)
{
string addedColumnsQuery = "add `" + column.Name + "` " + GetColumnTypeStringSymbol (column.Type) + " ";
string query = string.Format ("alter table " + table + " " + addedColumnsQuery);
ExecuteNonQuery (query, new Dictionary<string, object> ());
}
foreach (ColumnDefinition column in modifiedColumns.Values)
{
string modifiedColumnsQuery = "modify column `" + column.Name + "` " + GetColumnTypeStringSymbol (column.Type) + " ";
string query = string.Format ("alter table " + table + " " + modifiedColumnsQuery);
ExecuteNonQuery (query, new Dictionary<string, object> ());
}
foreach (ColumnDefinition column in removedColumns.Values)
{
string droppedColumnsQuery = "drop `" + column.Name + "` ";
string query = string.Format ("alter table " + table + " " + droppedColumnsQuery);
ExecuteNonQuery (query, new Dictionary<string, object> ());
}
}
catch(Exception e)
{
m_log.Debug("[MySQLDataLoader] UpdateTable", e);
}
}示例4: UpdateTable
public override void UpdateTable(string table, ColumnDefinition[] columns,
Dictionary<string, string> renameColumns)
{
table = table.ToLower();
if (!TableExists(table))
{
throw new DataManagerException("Trying to update a table with name of one that does not exist.");
}
List<ColumnDefinition> oldColumns = ExtractColumnsFromTable(table);
Dictionary<string, ColumnDefinition> removedColumns = new Dictionary<string, ColumnDefinition>();
Dictionary<string, ColumnDefinition> modifiedColumns = new Dictionary<string, ColumnDefinition>();
#if (!ISWIN)
Dictionary<string, ColumnDefinition> addedColumns = new Dictionary<string, ColumnDefinition>();
foreach (ColumnDefinition column in columns)
{
if (!oldColumns.Contains(column)) addedColumns.Add(column.Name.ToLower(), column);
}
foreach (ColumnDefinition column in oldColumns)
{
if (!columns.Contains(column))
{
if (addedColumns.ContainsKey(column.Name.ToLower()))
{
if (column.Name.ToLower() != addedColumns[column.Name.ToLower()].Name.ToLower() || column.Type != addedColumns[column.Name.ToLower()].Type)
modifiedColumns.Add(column.Name.ToLower(), addedColumns[column.Name.ToLower()]);
addedColumns.Remove(column.Name.ToLower());
}
else
removedColumns.Add(column.Name.ToLower(), column);
}
}
#else
Dictionary<string, ColumnDefinition> addedColumns =
columns.Where(column => !oldColumns.Contains(column)).ToDictionary(column => column.Name.ToLower());
foreach (ColumnDefinition column in oldColumns.Where(column => !columns.Contains(column)))
{
if (addedColumns.ContainsKey(column.Name.ToLower()))
{
if (column.Name.ToLower() != addedColumns[column.Name.ToLower()].Name.ToLower() ||
column.Type != addedColumns[column.Name.ToLower()].Type)
modifiedColumns.Add(column.Name.ToLower(), addedColumns[column.Name.ToLower()]);
addedColumns.Remove(column.Name.ToLower());
}
else
removedColumns.Add(column.Name.ToLower(), column);
}
#endif
try
{
#if (!ISWIN)
foreach (ColumnDefinition column in addedColumns.Values)
{
string addedColumnsQuery = "add `" + column.Name + "` " + GetColumnTypeStringSymbol(column.Type) + " ";
string query = string.Format("alter table " + table + " " + addedColumnsQuery);
ExecuteNonQuery(query, new Dictionary<string, object>());
}
foreach (ColumnDefinition column in modifiedColumns.Values)
{
string modifiedColumnsQuery = "modify column `" + column.Name + "` " + GetColumnTypeStringSymbol(column.Type) + " ";
string query = string.Format("alter table " + table + " " + modifiedColumnsQuery);
ExecuteNonQuery(query, new Dictionary<string, object>());
}
foreach (ColumnDefinition column in removedColumns.Values)
{
string droppedColumnsQuery = "drop `" + column.Name + "` ";
string query = string.Format("alter table " + table + " " + droppedColumnsQuery);
ExecuteNonQuery(query, new Dictionary<string, object>());
}
#else
foreach (string query in addedColumns.Values.Select(column => "add `" + column.Name + "` " + GetColumnTypeStringSymbol(column.Type) +
" ").Select(addedColumnsQuery => string.Format("alter table " + table + " " + addedColumnsQuery)))
{
ExecuteNonQuery(query, new Dictionary<string, object>());
}
foreach (string query in modifiedColumns.Values.Select(column => "modify column `" + column.Name + "` " +
GetColumnTypeStringSymbol(column.Type) + " ").Select(modifiedColumnsQuery => string.Format("alter table " + table + " " + modifiedColumnsQuery)))
{
ExecuteNonQuery(query, new Dictionary<string, object>());
}
foreach (string query in removedColumns.Values.Select(column => "drop `" + column.Name + "` ").Select(droppedColumnsQuery => string.Format("alter table " + table + " " + droppedColumnsQuery)))
{
ExecuteNonQuery(query, new Dictionary<string, object>());
}
#endif
}
catch (Exception e)
{
MainConsole.Instance.Error("[MySQLDataLoader] UpdateTable", e);
}
}