This question is locked. New answers and comments are not allowed.
Hi
I've tried to execute a left outer join in Telerik ORM
IQueryable<Customer> query = from applications in dbContext.ESERV_APPLICATIONs
join batapp in dbContext.ESERV_TRANSACTION_BATCH_APPLs
on applications.APPLICATION_ID equals batapp.APPLICATION_ID into g
from batapp2 in g.DefaultIfEmpty()
select new ....................
but when I execute I got his error
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Telerik.OpenAccess.Exceptions.DataStoreException: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."e_s__r_v__t_r__n_s__c_t___n__b": invalid identifier
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
SQL:
I've tried to execute a left outer join in Telerik ORM
IQueryable<Customer> query = from applications in dbContext.ESERV_APPLICATIONs
join batapp in dbContext.ESERV_TRANSACTION_BATCH_APPLs
on applications.APPLICATION_ID equals batapp.APPLICATION_ID into g
from batapp2 in g.DefaultIfEmpty()
select new ....................
but when I execute I got his error
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Telerik.OpenAccess.Exceptions.DataStoreException: Error executing query: Telerik.OpenAccess.RT.sql.SQLException: ORA-00904: "A"."e_s__r_v__t_r__n_s__c_t___n__b": invalid identifier
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.executeQuery()
at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.executeQuery()
at OpenAccessRuntime.Relational.fetch.FetchResultImp.Execute()
SQL: