///<summary>Build a select statement with omitted columns.</summary>
public static string GetSelectCommandStringFromTableMySql(string tableName, params string[] omitColumns)
{
if (omitColumns == null || omitColumns.Length <= 0 || omitColumns.All(x => string.IsNullOrEmpty(x)))
{
return("SELECT * FROM " + tableName);
}
List <string> listAllColumns = DbHelper.GetColumnNamesFromTableMySql(tableName);
string commandColumns = "";
foreach (string column in listAllColumns)
{
if (!string.IsNullOrEmpty(commandColumns))
{
commandColumns += ",";
}
if (omitColumns.Any(x => string.Compare(x, column, true) == 0))
{
commandColumns += "'' AS " + column;
}
else
{
commandColumns += column;
}
}
return("SELECT " + commandColumns + " FROM " + tableName);
}
