toptensoftware/PetaPoco — Issue #85: Paged<T, T2> support
Author: bfcamara
Created: 2011-10-17 15:10:08+00:00
State: open

I am trying to do this

var asset = db.Page(1, 10, PetaPoco.Sql.Builder
.Select()
.From("Asset")
.InnerJoin("AssetType").On("AssetTypeId = AssetType.Id"));

When I run the query I get

The column 'Id' was specified multiple times for 'peta_paged'.

It seems there is no support for

var asset = db.Page(1, 10, PetaPoco.Sql.Builder
.Select()
.From("Asset")
.InnerJoin("AssetType").On("AssetTypeId = AssetType.Id"));

Basically, I want pagonation with eager loading of my POCOs relations. Any help?

Thanks in advance