public IEnumerable <dynamic> GetColumnValues(string tableName, string columnName)
{
using (var tbl = new FlexTable(_config.GetConnectionString("DefaultConnection"), tableName))
{
var sql = $"SELECT [{columnName}] AS [name] FROM [{tableName}]";
var dt = tbl.Select(sql);
return(dt.AsDynamicEnumerable());
}
}
public IEnumerable <dynamic> GetAllRows(string tableName, int masterRecordId, string masterId)
{
using (var tbl = new FlexTable(_config.GetConnectionString("DefaultConnection"), tableName))
{
var sql = $"SELECT * FROM [{tableName}]";
if (masterRecordId > 0 && !string.IsNullOrEmpty(masterId))
{
sql += $" WHERE {masterId}_id={masterRecordId}";
}
var dt = tbl.Select(sql);
return(dt.AsDynamicEnumerable());
}
}
