internal static string GetRemappedLinqSql(string sql, string parentAlias, LinqSQLFromClauseCollection childTables)
{
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[lastcommunication\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Machine") + "].[lastcommunication]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[machineid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Machine") + "].[machineid]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[name\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Machine") + "].[name]", RegexOptions.IgnoreCase);
return(sql);
}
internal static string GetRemappedLinqSql(string sql, string parentAlias, LinqSQLFromClauseCollection childTables)
{
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[isready\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "DeleteQueue") + "].[isready]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[repositoryid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "DeleteQueue") + "].[repositoryid]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[rowid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "DeleteQueue") + "].[rowid]", RegexOptions.IgnoreCase);
return(sql);
}
internal static string GetRemappedLinqSql(string sql, string parentAlias, LinqSQLFromClauseCollection childTables)
{
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[id\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "ConfigurationSetting") + "].[id]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[name\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "ConfigurationSetting") + "].[name]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[value\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "ConfigurationSetting") + "].[value]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[timestamp\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "ConfigurationSetting") + "].[timestamp]", RegexOptions.IgnoreCase);
return(sql);
}
internal static string GetRemappedLinqSql(string sql, string parentAlias, LinqSQLFromClauseCollection childTables)
{
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[city\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CanadaPostalCode") + "].[city]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[latitude\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CanadaPostalCode") + "].[latitude]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[longitude\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CanadaPostalCode") + "].[longitude]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[postalcode\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CanadaPostalCode") + "].[postalcode]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[rowid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CanadaPostalCode") + "].[rowid]", RegexOptions.IgnoreCase);
return(sql);
}
internal static string GetRemappedLinqSql(string sql, string parentAlias, LinqSQLFromClauseCollection childTables)
{
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[intention\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Lock") + "].[intention]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[isread\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Lock") + "].[isread]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[lockid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Lock") + "].[lockid]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[locktime\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Lock") + "].[locktime]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[machineid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Lock") + "].[machineid]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[repositoryid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Lock") + "].[repositoryid]", RegexOptions.IgnoreCase);
return(sql);
}
internal static string GetRemappedLinqSql(string sql, string parentAlias, LinqSQLFromClauseCollection childTables)
{
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[addeddate\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CacheInvalidate") + "].[addeddate]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[count\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CacheInvalidate") + "].[count]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[reason\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CacheInvalidate") + "].[reason]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[repositoryid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CacheInvalidate") + "].[repositoryid]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[rowid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CacheInvalidate") + "].[rowid]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[subkey\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "CacheInvalidate") + "].[subkey]", RegexOptions.IgnoreCase);
return(sql);
}
internal static string GetRemappedLinqSql(string sql, string parentAlias, LinqSQLFromClauseCollection childTables)
{
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[name\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Server") + "].[name]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[serverid\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Server") + "].[serverid]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[createdby\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Server") + "].[createdby]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[createddate\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Server") + "].[createddate]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[modifiedby\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Server") + "].[modifiedby]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[modifieddate\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Server") + "].[modifieddate]", RegexOptions.IgnoreCase);
sql = System.Text.RegularExpressions.Regex.Replace(sql, "\\[" + parentAlias + "\\]\\.\\[timestamp\\]", "[" + childTables.GetBaseAliasTable(parentAlias, "Server") + "].[timestamp]", RegexOptions.IgnoreCase);
return(sql);
}
