Hi,i'm studying last dnn innovations and dal2.

I read some blog posts from dnn experts on this argument, but i can't find other documentation on this, so I hope someone can help me here.

I've an info class like this:

    [TableName("mwOfficies")]
    [PrimaryKey("OfficeID")]
    [Scope("ModuleID")]
    [Cacheable("Offices", CacheItemPriority.Default, 20)]
    public class OfficeInfo
    {

        public int OfficeID { get; set; }
        public int ModuleID { get; set; }
        public string Name { get; set; }
        public int OfficeTypeID { get; set; }               //Linked table    
        [IgnoreColumn]
        public string OfficeEmail { get; set; }
        public DateTime OfficeOpened { get; set; }
}

Created a Controller class to get data:

public static IEnumerable<OfficeInfo> GetCurrentOffices(int moduleId, int status)
        {

            IEnumerable<OfficeInfo> offices;

            using (IDataContext context = DataContext.Instance())
            {
                var repository = context.GetRepository<OfficeInfo>();
                offices = repository.Find("WHERE ModuleID = @0 " +
                    "AND (FK_STATO < @1)", moduleId, status);
            }
            return offices;
        }

now I've those questions:

1) in dnngrid I used MyController.GetCurrentOffices(ModuleID, 3) as dnngrid datasource, but i can see only 20 results as dnngrid.pagesize = 20, but no pager is displayed

 2) I've a Linked column (you can see the property OfficeTypeID) on a Type SQL table where i need to map Office.TypeID = Types.ID and get the OfficeType name to display on dnngrid. How i can do this on DAL2?

the announcements module source code isn't a good start, it has only one table :(

1. Add a templatecolumn with, for example, an asp:Label in it, to the dnngrid's definition.
2. Then, add an OnItemDataBound-method to your codebehind, for the dnngrid.
3. In the method, retrieve the correct Type from Types, using the repository.GetById functionality combined with the OfficeTypeID-property's value, and set the label's text from the resulting Type-object.

1. Create a View in your database, that does an inner join to your Types-table and returns (amongst all the Office-properties), an extra column named (for example) "OfficeTypeName".
2. Create an additional String-property in your OfficeInfo-class with the exact same name (thus, following my own example, "OfficeTypeName").
3. A. Alter the "TableName"-attribute of your OfficeInfo-class to contain the new view's name. I'm not completely sure whether or not that will work, but since MSSQL itself treats views as tables, I'm expecting DAL2/PetaPoco to do so too.
   B. If A doesn't work, then alter your GetCurrentOffices to use context.ExecuteQuery([params]).