/// <summary>
/// Read a generic List of your datatype from a table
/// </summary>
/// <typeparam name="T">Define a POCO of your table results</typeparam>
/// <param name="tableName">Table to query</param>
/// <param name="database">Database containing table</param>
/// <param name="schema">Optional schema</param>
/// <returns></returns>
public static List <T> ReadDataFromTable <T>(string tableName, string database, string schema = "dbo") where T : new()
{
// make sure the schema name doesn't already contain a "."
schema = schema.Replace(".", "");
using (var db = new ADODatabaseContext("TEST", database))
{
var query = $"SELECT * FROM [{schema}].[{tableName}]";
var data = db.ReadDataSet(query);
var result = data.Tables[0].ToList <T>();
return(result);
}
}
