LINQ sorgusu tarih kısıtlaması

private IEnumerable<dynamic> GetTransactions()
        {
            db = new MASTEREntities();


            return (
                    from t in db.TRANSACTIONS
                    join gonderen in db.CLIENTS on t.Gonderen_ID equals gonderen.Gonderen_ID
                    join alici in db.CLIENTS on t.Alici_ID equals alici.Gonderen_ID
                    join cmp1 in db.COMPANIES on t.Gonderen_ID equals cmp1.Gonderen_ID into _leftCMP1
                    from cmp1 in _leftCMP1.DefaultIfEmpty()
                    join cmp2 in db.COMPANIES on t.Alici_ID equals cmp2.Gonderen_ID into _leftCMP2
                    from cmp2 in _leftCMP2.DefaultIfEmpty()
                    join il1 in db.ILLER on cmp1.IL_ID equals il1.IL_ID into _leftIL1
                    from il1 in _leftIL1.DefaultIfEmpty()
                    join il2 in db.ILLER on cmp2.IL_ID equals il2.IL_ID into _leftIL2
                    from il2 in _leftIL2.DefaultIfEmpty()
                    join ilce1 in db.ILCELER on cmp1.ILCE_ID equals ilce1.ILCE_ID into _leftILCE1
                    from ilce1 in _leftILCE1.DefaultIfEmpty()
                    join ilce2 in db.ILCELER on cmp2.ILCE_ID equals ilce2.ILCE_ID into _leftILCE2
                    from ilce2 in _leftILCE2.DefaultIfEmpty()
                    where (t.OPR_ID == 2 || t.OPR_ID == 7 || t.OPR_ID == 8 || t.OPR_ID == 11 || t.OPR_ID == 12 || t.OPR_ID == 13 || t.OPR_ID == 15) &&
                            (t.TRN_STATU == 1) &&
                            (t.TRN_TIME > dtpBaslangicTarihi.Value.Date && t.TRN_TIME < dtpBitisTarihi.Value.Date)

                    select new { t, gonderen, alici, cmp1, cmp2, il1, il2, ilce1, ilce2 }
                ).OrderBy(x => x.t.TRN_ID).Take(1).AsEnumerable();
        }

(t.TRN_TIME > dtpBaslangicTarihi.Value.Date && t.TRN_TIME < dtpBitisTarihi.Value.Date)