Subsonic 3.0 dynamic search query

subsonic3

I want to build dynamic search query with subsonic 3.0.
who can help me?
Any sample Please.

Best Answer

Basically all you need to do is add conditions to an IQueryable based on your dynamic parameters. For example:

string productName = Request.Querystring[ProductName];

IQueryable<Product> productQuery = Product.All();

if(productName != null)
{
  productQuery = productQuery.Where(product => product.Name == productName);
}

IList<Product> filteredList = productQuery.ToList();

Related Solutions

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

C# – Subsonic 3.0 General Questions

Q. I need information on how to get success/failure? Do I look for an exception on failure or can I get a count of 'affected' records (old school?)

If it doesn't throw an exception then it's worked

Q. If I get an exception, which exception(s) can I expect?

You can expect a DbException

Best Answer

Related Solutions

SQL Views in SubSonic 3.0

C# – Subsonic 3.0 General Questions

Related Topic