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

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

3 Answers 345 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Praveen
Top achievements
Rank 1
Praveen asked on 11 Feb 2013, 07:20 AM
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

3 Answers, 1 is accepted

Sort by
0
Alexander
Telerik team
answered on 13 Feb 2013, 03:26 PM
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.
0
Praveen
Top achievements
Rank 1
answered on 14 Feb 2013, 04:20 AM
Hi,

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

-Praveen.
0
Yordan
Telerik team
answered on 15 Feb 2013, 03:46 PM
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.
Tags
General Discussions
Asked by
Praveen
Top achievements
Rank 1
Answers by
Alexander
Telerik team
Praveen
Top achievements
Rank 1
Yordan
Telerik team
Share this question
or