How to get multiple rows in subsonic

subsonic

I am using the following

Product objProduct = new Product("active_flag","true");

This one will result multiple row, how can I access the multple rows? ObjProduct will have only one row?

Best Answer

If you're using 2.1 or above you can do the following:

ProductCollection products = DB.Select().From(Product.Schema)
  .Where(Product.Columns.active_flag).IsEqualTo(true)
  .ExecuteAsCollection<ProductCollection>();

Related Solutions

Issue with SubSonic and Multiple Providers

One of your provider is failing. Subsonic is not good about telling you why and where its failing.

I usually debug in couple of ways.

Use only one provider at a time and comment the other one. Check if you are able to see the namespace. If both of them load fine, then you atleast know its not the database.
Check if any of you tables start with -, _, or numbers. This can cause it fail as well.

Let me know how it goes.

C# – Using SubSonic Query to on multiple tables

You neet to join them, much like you would do in SQL. If you have a foreign key relationship in the schema, Subsonic is smart enough to figure the joins directly:

DataSet DS = DB.Select().From<Table1>().InnerJoin<Table2>().ExecuteDataSet();

If you don't have a FKI between the tables, you need to manually specify the columns from each table to create the join:

DataSet DS = DB.Select().From<Table1>().InnerJoin(Table1.FKIColumn,Table2.IDColumn).ExecuteDataSet();

Similarly you can create the Left/Right Outer joins,etc.

Remeber you can only join them on simple FKI constraints. For example I found no easy way to do "INNER JOIN Table2 on Table1.FKI = Table2.ID and Table2.CreateDate>Table1.CreateDate" directly from SubSonic.

And a big downside to using SubSonic multiple table joins is that you will run into troubles if you have identically named columns in both tables.

Best Answer

Related Solutions

Issue with SubSonic and Multiple Providers

C# – Using SubSonic Query to on multiple tables

Related Topic