SQL Views in SubSonic 3.0

Question

Is there any way that I can access my SQL views in SubSonic 3.0? The code generation seems to skip views altogether

freddoo · Answer 1 · 2009-07-08T15:01:02.120

27

To include views in your project

simply open SQLServer.ttinclude Find the query that load the tables ( search form 'const string TABLE_SQL') then change it to

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";

if you are using it in an asp.net project you can exclude the aspnet table and views like so

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_%'";

edited Jul 08 '09 at 15:01

answered Jul 08 '09 at 12:30

freddoo

6,770
2
29
39

2

Only problem is then you have Save(),Delete(), etc methods on the view objects that don't really apply to Views – Jeremy Coenen Aug 20 '09 at 14:25
I have not tried to save or delete a view, but sql wise it's possible to update a view. I guess the best solution would be to create a template for view and return read-only objects. – freddoo Aug 24 '09 at 18:32

score 0 · Answer 2 · answered Jul 03 '09 at 10:16

The SubSonic 3 templates don't generate code for views yet. You could add the functionality yourself quite easily though, have a look at the LoadTables and GetSPs methods in SQLServer.ttinclude to see how SubSonic builds lists of tables\stored procedures.

SQL Views in SubSonic 3.0

2 Answers2

Linked