using LJCNetCommon;
using LJCDBMessage;
        
// A Person Data Record class.
public class Person
{
    <span class='xmlComment'>/// <summary>Gets or sets the PersonId value.</summary></span>
    public Int32 PersonId { get; set; }
        
    <span class='xmlComment'>/// <summary>Gets or sets the Name value.</summary></span>
    public string Name { get; set; }
        
    <span class='xmlComment'>/// <summary>Gets or sets the City value.</summary></span>
    public string City { get; set; }
}
        
// Creating the Joins collection object.
        
// Create the Joins collection and Join definition objects.
DbJoins dbJoins = new DbJoins();
dbJoin = new DbJoin()
{
    TableName = "Address",
    JoinType = "Left"
};
        
// Create the JoinOn definitions and add them to the JoinOns collection.
// Add the JoinOns collection to the Join definition.
DbJoinOns dbJoinOns = new DbJoinOns();
DbJoinOn dbJoinOn = new DbJoinOn()
{
    FromColumnName = "ID",
    ToColumnName = "PersonID",
    JoinOnOperator = "=" // Default
};
dbJoinOns.Add(dbJoinOn);
dbJoin.JoinOns = dbJoinOns;
        
// Create the Column definitions and add them to the Columns collection.
// Add the Columns collection to the Join definition.
// Add the Join definition to the Joins collection.
DbColumns columns = new DbColumns();
DbColumn column = new DbColumn()
{
    ColumnName = "City_Name",
    PropertyName = "City", // Defaults to same as ColumnName
    DataTypeName = "String" // Default
};
columns.Add(column);
dbJoin.Columns = columns;
dbJoins.Add(dbJoin);
        
// Shortcut using object initialization, only required values and defaults.
// Note: JoinOn Columns must have properties in the Data Object
// to recieve the join values.
// The RenameAs property is required if there is another table column
// with the same name.
// dbJoinOns.Add(string fromColumnName, string toColumnName
//   , string joinOperator = "=")
// dbColumns.Add(string columnName, string propertyName = null
//   , string renameAs = null, string dataTypeName = "String", string caption = null)
DbJoins dbJoins = new DbJoins();
dbJoin = new DbJoin()
{
    TableName = "Address",
    JoinOns = new DbJoinOns() {
        { "ID", "PersonID" }
    },
    Columns = new DbColumns() {
        { "City_Name", "City" }
    }
};
dbJoins.Add(dbJoin);
        
// The Data Service creates the following SQL from this request which
// includes the DbJoins object.
DbRequest dbRequest = new DbRequest("Select", "Person")
{
    DataConfigName = "PersonData",
    Columns = new DbColumns() { { "Name" }},
    Joins = dbJoins
};
        
// select
//  [Person].[Name],
//  [Address].[City_Name]
// from [Person]
// left join [Address]
//  on [Person].[ID] = [Address].[PersonID]