subsonic - SubSonic 3.0 中的 SQL View

Question

有什么方法可以在 SubSonic 3.0 中访问我的 SQL View ？代码生成似乎完全跳过了 View

Answer 1

在项目中包含 View

只需打开 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 表和 View

const string TABLE_SQL=@"SELECT *
    FROM  INFORMATION_SCHEMA.TABLES
    WHERE TABLE_TYPE='BASE TABLE' 
        and table_name not like '%aspnet_%'
    union
    select Table_catalog, table_schema, table_name, 'View' table_type 
    from information_schema.views
    where table_name not like '%aspnet_%'";