public static List <string> DescribeTable(IElequentProvider db, string tableName)
{
List <string> listColumns = new List <string>();
var columns = db.Instance().Select($"SELECT name FROM syscolumns WHERE id=OBJECT_ID('{tableName}')").ToArray();
foreach (var column in columns)
{
listColumns.Add(column.name);
}
return(listColumns);
}
public RolesController(IElequentProvider db)
{
this.db = db;
}
public VoyagerBaseController(IElequentProvider db)
{
this.db = db;
}
public HomeController(ILogger <HomeController> logger, IElequentProvider _db)
{
_logger = logger;
this._db = _db;
}