/// <summary>
///
/// </summary>
/// <param name="tableAlias"></param>
/// <param name="advanceMembers"></param>
/// <param name="sqlSyntax"></param>
/// <returns>item 1 is the actual columns being selected
/// item 2 is the split on column</returns>
internal Tuple <string, string> BulidSelectColumnStatement(char tableAlias, List <AdvanceMember> advanceMembers, SqlSyntaxHelper sqlSyntax)
{
var sb = new StringBuilder();
var isFirstTime = true;
var splitOn = "";
advanceMembers.Where(a1 => a1.SqlTableAttritube == null && a1.SqlCustomAttritube.Ignore != true).ToList().ForEach(delegate(AdvanceMember member) // BUILD SQL COLUMNS
{
var columnName = $"{tableAlias}.{sqlSyntax.GetTableOpenChar()}{member.Member.Name}{sqlSyntax.GetTableClosedChar()}";
sb.AppendLine($"{columnName} , ");
if (isFirstTime)
{
splitOn = member.Member.Name;
isFirstTime = false;
}
});
return(new Tuple <string, string>(sb.ToString(), splitOn));
}
public static string GetQuotedValue(object value, DataBaseType type)
{
var syntax = new SqlSyntaxHelper(type);
return(syntax.GetEnclosedValueChar(value.GetType()));
}
