/// <summary>
/// Gets ValidFrom column (sql formatted)
/// </summary>
/// <param name="tableName">If not empty table name is part of column name</param>
/// <param name="scdColumn">SCD ValidFrom Column</param>
/// <param name="prefix">column prefix</param>
/// <param name="postfix">column postfix</param>
/// <param name="spaces">Number of space at the beginnung of a row</param>
/// <returns>ValidFrom column</returns>
public static string GetSqlValidFrom(string tableName, SCDColumn scdColumn, string prefix, string postfix, int spaces)
{
string result = "";
string columnName = tableName == "" ? scdColumn.ColumnName : tableName + "_" + scdColumn.ColumnName;
AddBrackets(ref prefix, ref postfix);
result = prefix + columnName + postfix;
result = result.PadLeft(result.Length + spaces);
return(result);
}
/// <summary>
/// Does the SCD column list contain the specified column?
/// </summary>
/// <param name="scdColumn">SCD column</param>
/// <returns>Does the SCD column list contain the specified column?</returns>
private bool ContainsSCDColumn(SCDColumn scdColumn)
{
foreach (SCDColumn col in ScdColumns)
{
if (col.ColumnName == scdColumn.ColumnName)
{
return(true);
}
}
return(false);
}
