This is a migrated thread and some comments may be shown as answers.

Error in Left Outer Join query

3 Answers 90 Views
LINQ (LINQ specific questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Bassel
Top achievements
Rank 1
Bassel asked on 06 Feb 2011, 01:17 PM
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:

3 Answers, 1 is accepted

Sort by
0
Thomas
Telerik team
answered on 08 Feb 2011, 10:32 AM
Hello Bassel,

looks like you are going from the domain model to the database schema and a column name is generated in the wrong way; therefore subsequent queries fail. Can you try to give the fields of the ESERV_TRANSACTION_BATCH_APPL explicit (shorter) column names? I will look into the issue here as well.

Kind regards,
Thomas
the Telerik team
Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
0
Bassel
Top achievements
Rank 1
answered on 08 Feb 2011, 11:00 AM
Hello

it's ok the problem was in the relationship between the two tables
when I delete association it worked

thnx
0
Dimitar Kapitanov
Telerik team
answered on 09 Feb 2011, 11:05 AM
Hi Bassel,
Can you give us more information regarding the fault association? I would like to know what went wrong with the association. We know of verified problems if Undo/Redo is used intensively in the designer? Can you elaborate further on the topic.

Greetings,
Dimitar Kapitanov
the Telerik team
Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
Tags
LINQ (LINQ specific questions)
Asked by
Bassel
Top achievements
Rank 1
Answers by
Thomas
Telerik team
Bassel
Top achievements
Rank 1
Dimitar Kapitanov
Telerik team
Share this question
or