public List <dynamic> ListDatabaseTableName(ListDatabaseTableNameInputDto input)
{
var resultList = new List <dynamic>();
var executeSql = $@"select object_id id,name text from sys.tables order by text";
var parameters = new { };
using (var conn = new SqlConnection(input.ConnectionString))
{
var queryList = conn.Query <dynamic>(executeSql, parameters).ToList();
foreach (var item in queryList)
{
resultList.Add(new { id = item.id, text = item.text });
}
}
return(resultList);
}
