LLBLGEN V 3.0 .net Framework 2.0 Oracle 9i/10g

Hi, I have created a typed list and getting error invalid identifier. I have created typedlist earlier also but never had such problem. I tried executing query in DB directly "SELECT BCLUB1868.AFFILIATEMEMBER.USAGECONTINIOUSDAY FROM BCLUB1868.AFFILIATEMEMBER" it works fine but in LLBLGEN getting error. I have attached stack trace

Please show the code you're using to fetch the typed list.

The generated SQL is not correct as it doesn't conatin any relation (Join) to the AFFILIATEMEMBER table.

Otis wrote:

Please show the code you're using to fetch the typed list.

Here is the code

public static DataTable returnaffiliatemember(string affiliateclubno, string affiliatememberno) {

        var TlistAffiliateMember = new TlaffiliateMemberTypedList();

        var adapteraffiliatemember = new DataAccessAdapter();
        adapteraffiliatemember.FetchTypedList(TlistAffiliateMember.GetFieldsInfo(), TlistAffiliateMember, null, 0, null,true);
        DataTable DataTablesaffiliateclub = TlistAffiliateMember;
        return DataTablesaffiliateclub;
    }

yogesh_shtty wrote:

Walaa wrote:

The generated SQL is not correct as it doesn't conatin any relation (Join) to the AFFILIATEMEMBER table.

Dear Walaa, Attached project shows relationship exists

Well My stupid mistake. Just didnt add

var bucketaffiliatemember = new RelationPredicateBucket(); bucketaffiliatemember.Relations.Add( AffiliatememberEntity.Relations.AffiliateclubEntityUsingAffiliatememberclubno);

It is fine now