public List <SQLVarsVals> GetVariables()
{
List <SQLVarsVals> temp = new List <SQLVarsVals>();
string[] fields = Fields.GetFieldNames().Split(',');
for (int index = 0; index < Values.Count; index++)
{
SQLVarsVals var = new SQLVarsVals();
for (int index2 = 0; index2 < fields.Length; index2++)
{
var.Add(fields[index2], Values[index].GetFieldValues(index2).GetRawValue());
}
temp.Add(var);
}
return(temp);
}
protected string GetGroupBy()
{
if (GroupBy.Count() > 0)
{
return($" GROUP BY {GroupBy.GetFieldNames()}");
}
else
{
return("");
}
}
protected string GetON()
{
return($"ON {TableName} ({Columns.GetFieldNames()})");
}
protected string GetSelectFrom()
{
return($"SELECT {GetDistinct()} {SelectFields.GetFieldNames()} FROM {MainTable}");
}
protected string GetInsert()
{
return($"INSERT INTO {IntoTableName} ({Fields.GetFieldNames()})");
}
