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); }