Dynamic Column Example Joining Related SharePoint Lists

#region Usings
using System;
using System.Collections.Generic;
using System.Data;
using System.Globalization;
using System.Text;
using Simego.DataSync.Providers.MSSharePoint;
#endregion

class DataSourceRowOverride : Simego.DataSync.DynamicColumns.DataSourceRowInternal //Do Not Change This Line
{
    //Category Data
    DataTable categories;
    //Category Index
    Dictionary<int, DataRow> lookup = new Dictionary<int, DataRow>();
    
    /// <summary>
    /// Get the Category ID from the Category Lookup Column
    /// </summary>
    public int O_CategoryID
    {
        get { 
            int ix = this.Category.IndexOf(";#");
            if ( ix > 0 )
                return Convert.ToInt32(this.Category.Substring(0, ix));
            
            return 0; 
        }
    }

    /// <summary>
    /// Description
    /// </summary>
    public string O_CategoryDescription {         
        get 
        { 
            object val = lookup[O_CategoryID]["Description"];
            if ( val == DBNull.Value ) return null;
            return (string)val;
        } 
    }
    
    public override void Setup()
    {
        //Get a DataTable object of the related List via a new SharePoint Reader
        SharePointDataSourceReader reader = new SharePointDataSourceReader();
        reader.ListUrl = ((SharePointDataSourceReader)this.DataSourceA.Reader).ListUrl;
        reader.ListName = "Categories";
        //Get the Default Schema for this List
        reader.SchemaMap = reader.GetDefaultDataSchema();
        //Load the Data Table
        categories = reader.GetDataTable();        
        //Create a Lookup Index to help speed-up lookups
        foreach(DataRow r in categories.Rows) 
            lookup.Add((int)r["ID"], r);
    }
}