Select Top N records with Subsonic 3

subsonicsubsonic3

I'm using Subsonic 3.0.0.3 for a new project and on one of my pages I'm wanting to display only 5 records that are the top 5 read records. My SQL select statement is

select top(5) * from myTable order by reads desc

Is this possible to do with ActiveRecord? If it is I haven't came across how yet.

Jon

Best Answer

You can use Take to select a limited number of items for example:

IQueryable<myTable> topFive = myTable.All()
  .OrderByDescending(table => table.reads)
  .Take(5);

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

Subsonic SimpleRepository problem with Category.All

This was resolved in 3.0.0.1

Best Answer

Related Solutions

SQL Views in SubSonic 3.0

Subsonic SimpleRepository problem with Category.All

Related Topic