Quick Objects Documentation Akal Tech Logo
Return All Records From Two Joined Tables

Glossary Item Box

Business Logic Framework - Tutorial 3:

Our third tutorial shows you another very powerful feature that creates a Join between two objects. We run the Find method on the Orders class and the parent record values from the Customers table will automatically be included in the result set.

Here is the example code that achieves this:

 

1 using (Orders orders = new Orders())  
2 {  
3     // this method will join the orders object with the CustomerID_Customers_Parent  
4     // and the parent table's columns will also be included in the result set.  
5     orders.Join_CustomerID_Customers_Parent();  
6  
7     // we do not want a duplicate CustomerID column in our result set so we set its visibility to false  
8     orders.CustomerID_Customers_Parent.CustomerID.Visible = false;  
9  
10     this.GridView.DataSource = orders.Find();  
11     this.GridView.DataMember = orders.GetResultSetName();  
12 }  
13  
1 Using Order As Orders = New Orders()  
2     ' this method will join the orders object with the CustomerID_Customers_Parent  
3     ' and the parent table's columns will also be included in the result set.  
4     Order.Join_CustomerID_Customers_Parent()  
5  
6     ' we do not want a duplicate CustomerID column in our result set so we set its visibility to false  
7     Order.CustomerID_Customers_Parent.CustomerID.Visible = False 
8  
9     Me.GridView.DataSource = Order.Find()  
10     Me.GridView.DataMember = Order.GetResultSetName()  
11 End Using  
12  


 This code above shows that just by writing one line of code you are able to include the parent table's columns in the result set. By default the Join_CustomerID_Customers_Parent creates an Inner Join, but you have the ability to override that as well by passing the JoinTypes.Left or JoinTypes.Right etc. See JoinTypes Enumeration