gistfile1.cs

    public IEnumerable<GeneralLedger> GetUnprocessedEntriesForOrganizationUnit(OrganizationUnit ou)
    {
      using (var conn = _dapper.OpenConnection())
      {
        var query = string.Format(@"

SELECT GL.*, A.*, BOU.*
FROM GeneralLedger GL
  INNER JOIN Accounts A ON (A.ID = GL.AccountID)
	LEFT JOIN OrganizationUnits BOU ON (BOU.ID = A.BookOnOrganizationUnitID)
WHERE GL.OrganizationUnitID = @orgID
AND GL.IsProcessed = 0
", (int)FinancialPeriodStatus.Closed);

        var results = conn.QueryMultiple(query, new { @orgID = ou.ID });


        var records = results.Read<GeneralLedger, Account, OrganizationUnit, GeneralLedger>((gl, a, o) =>
        {
          a.BookOnOrganizationUnit = o;
          gl.Account = a;

          return gl;
        }).ToList();

        return records;
      }
    }