Error in Left Outer Join query

4 posts, 0 answers
  1. Bassel
    Bassel avatar
    7 posts
    Member since:
    Nov 2008

    Posted 06 Feb 2011 Link to this post

    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:
  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 08 Feb 2011 Link to this post

    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.
  3. DevCraft banner
  4. Bassel
    Bassel avatar
    7 posts
    Member since:
    Nov 2008

    Posted 08 Feb 2011 Link to this post

    Hello

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

    thnx
  5. Dimitar Kapitanov
    Admin
    Dimitar Kapitanov avatar
    632 posts

    Posted 09 Feb 2011 Link to this post

    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.
Back to Top