解决方法
在您的项目中包含视图
只需打开sqlServer.ttinclude
找到加载表的查询(搜索表单“const string TABLE_sql”)
然后将其更改为
const string TABLE_sql=@"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' union select Table_catalog,table_schema,table_name,'View' table_type from information_schema.views";
如果您在asp.net项目中使用它,您可以排除aspnet表和视图
const string TABLE_sql=@"SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' and table_name not like '%aspnet_%' union select Table_catalog,'View' table_type from information_schema.views where table_name not like '%aspnet_%'";