Make cassini work with .net 2

Recently I have been playing with Monorail the port of Ruby on Rails to C#/.NET
I needed to get Cassini to work with .NET 2

The initial version of Cassini that I have was built against  

I added the following as CassiniWebServer.exe.config 

<?xml version =”1.0″?>
<configuration>
<startup>
<requiredRuntime version=”v2.0.50727″/>
<supportedRuntime version=”v2.0.50727″/>
</startup>
</configuration>

This is all that was required. 

Paging in sql server

This may not be the most elegant paging code for sql server but it solves the problem:

create database foobar
go

use foobar
go

drop table test
go
create table test(id int not null, name varchar(10) not null, primary key(id))
go

insert into test values (1,’one’)
insert into test values (2,’two’)
insert into test values (3,’three’)
insert into test values (4,’four’)
insert into test values (5,’five’)
go

select top 2 *
from test  
where id not in (select top 2 id from test)
order by id
go