/// <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); }