Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'Employee'.

4 posts, 0 answers
  1. Praveen
    Praveen avatar
    14 posts
    Member since:
    Oct 2011

    Posted 11 Feb 2013 Link to this post

    Hi,

    I am using Telerik Open Access ORM in my asp.net C# web application.
    In my app, I have mapped a table entity from database named "Person"  as base class and created a Sub Domain Class named "Employee".
    Then I have  applied vertical inheritance for subclass to the Base class and used "Default mapping" for the Employee Sub class.

    While querying both Base/Sub class I am getting error :

    Error executing query: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'Employee'.

    Please help.

    -Praveen
  2. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 13 Feb 2013 Link to this post

    Hi Praveen,

    This error is actually the same as the one you asked about in your other thread.
    Please update your database using the Update Database From Model wizard and the error should be fixed.

    All the best,
    Alexander
    the Telerik team
    Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.
  3. DevCraft banner
  4. Praveen
    Praveen avatar
    14 posts
    Member since:
    Oct 2011

    Posted 13 Feb 2013 Link to this post

    Hi,

    Can I use any other inheritance strategy to implement my scenario as a SubClass without mapping to any database table?

    -Praveen.
  5. Yordan
    Admin
    Yordan avatar
    39 posts

    Posted 15 Feb 2013 Link to this post

    Hello Praveen, 

    If I understood you correctly, you want all your classes that derive from one base class to be saved in one database table? If that is the case than you need to use "flat inheritance". For more information you can refer to the article  How to: Model Flat Inheritance with the Visual Designer.

    Please find attached a sample project I have prepared for your convenience.

    Do not hesitate to get back to us if the project is not the proper solution for your scenario.


    Greetings,
    Yordan
    the Telerik team
    Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.
Back to Top