title: C# | WPF | DataGrid - Binding to the sources from two Tables
body: <p>I have a datagrid, named orderItemsGrid, which contains the columns (or TextColumn Headers, to prevent confusion) Item Name, Unit Price, Quantity, and Amount (Amount=Quantity*unitPrice) of each item that a customer has ordered in an order. I would like to fetch the info to this grid from a SQL Express 2008 R2 Database, called Business, using LINQ to SQL. But the problem is, the columns ItemName and Price exist in the table named ITEMS and the columns Quantity and Amount are in ORDER_ITEMS.</p>
  
  <p>Relationships:<br>
  FK_ORDER_ITEMS_ORDERS (OrderID)<br>
  FK_ORDER_ITEMS_ITEMS (ItemID)  </p>
  
  <p>The database diagram is here:<br>
  <a href="https://i.stack.imgur.com/MY8G3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MY8G3.png" alt=""></a></p>
  
  <p>Please revert with comments.</p>