Hi all

I have this senario fees is slids for fund and return one row

SELECT   *, FNDFundFees.*, FNDFund.*
FROM         FNDFund INNER JOIN
                      FNDFundFees ON FNDFund.FundID = FNDFundFees.FundID
WHERE    (FNDFund.FundID = '576ab9ec-931c-4c22-a0b1-1e861b7ebbe8') AND (FNDFundFees.FeesTo >= 1000) AND (FNDFundFees.FeesFrom <= 1000)

this is return one row when test it in database

but in llbl doesn't retern any thing

amount=1000;
var fundEn = new FNDFundEntity();
                    var path = new PrefetchPath2((int)EntityType.FNDFundEntity);
                    var fiter = ((FNDFundFeesFields.FeesFrom <= amount) & (FNDFundFeesFields.FeesTo >= amount));
                    path.Add(FNDFundEntity.PrefetchPathFNDFundFeesCollection, 0, fiter);

                    using (var adapter = DataAccess.DataAdapterFactory.Create())
                    {
                        adapter.FetchEntity(fundEn, path);
                    }

Mohamed,

You need to specify the PK for your FUNDEntity. For example:

var fundEn = new FNDFundEntity('576ab9ec-931c-4c22-a0b1-1e861b7ebbe8');