Asp – Advice / opinions on using SubSonic 3.0.0.3 without MVC

asp.netiis-6subsonic3

I use SubSonic 3.0.0.3 ActiveRecord with ASP.NET MVC and it is very nice. However, we run on IIS 6 and I tend to have quite a few issues with speed. I dont know if this is me being too paranoid but I was thinking of using SubSonic with just a normal ASP.NET WebForms website. Please forgive me for being thick but I'm so used to models and binding now that I can't think how to use SubSonic within a normal ASPX page.

For example and this would be enough to set me free. I have a product view page .aspx and in that I would pull down data using the SubSonic code, but then there is my page end I'm a little confused about, I don't have any example code as I would like to see what is said about this and if me running MVC and SubSonic on IIS 6 is a BAD thing.

Best Answer

I don't think you are really asking the right questions, in my opinion. Whether you are using IIS6 or IIS7 and/or MVC or Webforms shouldn't have any impact on the feasibility of using Subsonic. That is, Subsonic should work just fine with any platform combination.

If performance is critical, you certainly need to consider that Subsonic or any ORM is never going to be quite as fast as pure ADO.NET code that you could write and optimize on your own. Having said that, odds are your performance bottleneck has nothing to do with this.

Using Subsonic in an .aspx page is just like you would in MVC, the only difference being now you'll bind any data directly to controls rather than passing into a view:

protected void Page_Load(object sender, EventArgs e)
{
    var products = Product.GetPaged(1, 20);
    productsGridView.DataSource = products;
    productsGridView.DataBind();
}

To answer your last question more succinctly: using Subsonic would not be a BAD thing, at least not for the reasons you mentioned.

Related Solutions

Subsonic 3.0.0.3 Crash

I experienced the exact same scenario. I was able to insert, but not update.

The cause, I found, was that a primary key was not set on the table. Once the primary key was set, I was able to update.

Asp – subsonic 3.0.0.3 multiple database connection failover

If you look in Context.tt at line 35 you'll see the following code:

public <#=DatabaseName#>DB() 
{ 
    DataProvider = ProviderFactory.GetProvider("<#=ConnectionStringName#>");
    Init();
}

This is where the provider is getting setup for you so if you add a BackupConnectionStringName variable in Settings.ttinclude after the ConnectionStringName at line 20 then you should be able to check your connection is working and user your fallback if not. For example:

public <#=DatabaseName#>DB() 
{ 
    DataProvider = ProviderFactory.GetProvider("<#=ConnectionStringName#>");
    Init();
    try
    {
        DataProvider.CreateConnection();
    }
    catch(SqlException)
    {
       DataProvider = ProviderFactory.GetProvider("<#=BackupConnectionStringName#>");
       Init(); 
    }
}

NB You may need to do some clean up to make sure a connection is not left open by CreateConnection.

Best Answer

Related Solutions

Subsonic 3.0.0.3 Crash

Asp – subsonic 3.0.0.3 multiple database connection failover

Related Topic