/// <summary>
/// Build the parameter list for a function, given a list of columns and a function
/// to evaluate the validity of a column.
/// </summary>
/// <param name="columns"></param>
/// <param name="isColumnValid"></param>
/// <returns></returns>
private string GetFunctionParms(List <DBColumn> columns, IsColumnValid isColumnValid)
{
StringBuilder functionParmsSb = new StringBuilder();
int x = 0;
foreach (DBColumn column in columns)
{
if (isColumnValid(column))
{
if (x > 0)
{
functionParmsSb.AppendFormat(",\r\n\t\t\t");
}
functionParmsSb.AppendFormat("{0} {1}", column.Type(), column.ParamName());
x++;
}
}
string functionParmsString = functionParmsSb.ToString();
functionParmsSb = null;
return(functionParmsString);
}
/// <summary>
/// Build the parameter list for a function, given a list of columns and a function
/// to evaluate the validity of a column.
/// </summary>
/// <param name="columns"></param>
/// <param name="isColumnValid"></param>
/// <returns></returns>
private string GetFunctionParms(List<DBColumn> columns, IsColumnValid isColumnValid)
{
StringBuilder functionParmsSb = new StringBuilder();
int x = 0;
foreach (DBColumn column in columns)
{
if (isColumnValid(column))
{
if (x > 0) functionParmsSb.AppendFormat(",\r\n\t\t\t");
functionParmsSb.AppendFormat("{0} {1}", column.Type(), column.ParamName());
x++;
}
}
string functionParmsString = functionParmsSb.ToString();
functionParmsSb = null;
return functionParmsString;
}
