Asp – SubSonic 3 Installation Doesn’t Work

asp.netsubsonicsubsonic3

Ok I have following the tutorial here as best I can

http://subsonicproject.com/docs/Setting_up_SubSonic_3.0

As the files you get in the download are nothing like what is shown in the video?? So I am literally just guessing which files to use??

Then I drag the files / folders into Visual studio (As the video shows) and NOTHING happens?? It just adds the files to my solution?? Or adds the folders to my solution as normal files… Nothing gets executed as shown in the video??

I realise Rob has spent a lot of time on this off his own back, and I am trying not to be a whining old women BUT… How are we expected to use it, if the installation video is completely different to the actual files you get in the download AND when you drag the files into VS2008 nothing happens – Which is completely different to the video? My VS does not recognise TT files as being anything special…

I really want to use this new version, as I loved v2.1 but I'm loosing faith

RANT OVER

Best Answer

OK a few places to start:

Are you using Visual Studio Express, if so unfortunately it doesn't support t4 and so won't work with SubSonic 3
Try right clicking on the tt files and clicking 'Run Custom Tool'
If your project is a Website rather than a Web Application Project t4 won't work and you won't see 'Run Custom Tool' in the right click menu. In this case either convert the project or you can use a separate class library project in your solution and add the templates to it, then reference this in your website.
Choose whether you want to use Simple, Linq or ActiveRecord templates. Have a look here to help you choose (you can always change your mind later)
Watch the video for whichever template you've chosen, the setup video you linked to is unfortunately a little dated and I think the template specific ones are much more helpful.

Related Solutions

Subsonic 3 State

Currently I'm hammering away on refinements as I use S3 to build out a project I'm working on. I'm trying to get it to a respectable, solid point so you don't have to keep telling me about silly bugs.

For instance - I found and eliminated a dumb join bug the other day that's been absolutely plaguing me :).

I need to make sure the working experience is what I imagine it to be: as close to 0 friction as possible. I'm also trying to work up our documentation so you don't have to guess on things - you can see this here:

http://subsonicproject.com/docs

I have some great people helping me, but I've frozen commits to the core stuff outside of myself for now so we don't get any regressions.

I know people want to use it - I need to tune it and so people will have to wait a bit.

SQL Views in SubSonic 3.0

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

Best Answer

Related Solutions

Subsonic 3 State

SQL Views in SubSonic 3.0

Related Topic