}//GetColumnNames
//-------------------------------------------------------------------------------------------------------//
/// <summary>
///
/// </summary>
/// <param name="connectionString"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public static List<ColumnData> GetAllColumnData(string connectionString, string tableName)
{
List<ColumnData> dtColsData = new List<ColumnData>();
using (OdbcConnection connection = new OdbcConnection(connectionString))
{
using (OdbcDataAdapter adapter = new OdbcDataAdapter("", connection))
{
connection.Open();
dtColsData = connection.GetSchema("Columns", new[] { connection.DataSource, null, tableName })
.AsEnumerable()
.Select(r => ColumnData.FromDataRow(r))
.OrderBy(cd => cd.Name)
.ToList();
}//Using
}//Using
return dtColsData;
}//GetColumnNames
