.Net Editor join when using procedural style

adam.leinen@fblfinancial.com

I'm using .Net Editor but I'm using procedural style so I can use my existing entityframework annotations to define my columns. However when I try to use join feature of editor it gives me the error listed below. Are you able to do joins when using procedural style?

Error Message:
Table part of the field 'I_GENERAL_LEDGER_SPLIT_RULE' was not found. In Editor instance that use a join, all the fields must have the database table set explicity.

Just to give you an idea of my table structure(not complete). I'm joining from Table1 to Table2

Table1
Key field : I_GENERAL_LEDGER_SPLIT_RULE
Foreign Key: I_SECURITY

Table2
Key field : I_SECURITY

allan

Hi,

When using a LeftJoin you need to specify the table name as part of the field name - e.g.:

new Field("Table1.I_GENERAL_LEDGER_SPLIT_RULE")

Allan