Hello

see

sql view:

select a.a1,a.a2,b.b3,b.b4 from tableA as a, tableB as b
where a.Id = b.TableAId

the view name is : vwTest

fetch data from vwTest:

select * from vwTest where a1 = 'xxx';

for now, working fine.

but in the c# code:

IPredicateExpression filter = new PredicateExpression();
            filter.Add(TableAFields.a1== xxxx);

i got an sql error:

 Unknown column 'TableA.a1' in 'where clause'

please help. Thank you

TableAFields.a1

INstead of using the TableAFields class, you should use a similar class generated for the TypedView.

Code: MyViewFields.a1

Great, i found that class.

Thank you