ORA-00942: table or view does not exist

[Libertad]

Hi,
I've created a DataService using DSW from an EntitiesModel which is created from an Oracle database.
When I was creating this EntitiesModel I choose a prefix to be added to all of my classes (tables name).
Now when I try to get access to a table of my DB using the DataService I face the message "ORA-00942: table or view does not exist"

here is my code to call the table content:

protected void Page_Load(object sender, EventArgs e)
        {
            var dm = new DataManager();
            GridView1.DataSource = dm.RN_USERSs; // original table name is USERS
            GridView1.DataBind();
        }

Why OpenAccessModel cannot specify prefixes?

[Ivailo]

Hello Majid,

Just to note in this thread that following our communication in your support ticket regarding the same issue, we are already working on it. We will contact you on the support ticket in case we need any details.

When there are any final results, I will post them on the forum thread as well for future references.


Regards,
Ivailo
the Telerik team

[Libertad]

Thank you Ivailo 
I'm waiting for that.

[Stefano]

I have the same problem. Any suggestion?

[Libertad]

Check the Error List window of Visual Studio - it will show the problems and you will be able to fix them through the OpenAccess ORM Validation window, which will open automatically when you double click the errors. 

In order to find out how to handle issues with missing primary keys, you can refer to this article. If there are any other errors in your Error List, you can use the information and recommendations of the Validation window to try to resolve them or you can get back to us with the error messages.

[Ivailo]

Hi Guys,

First of all, Majid is correct in his recommendations, so let me say thanks for the support.

The only thing I would add is that this error could be a result of different problems in your mapping, one of which is the missing primary key. Another problem that is frequently encountered is a wrong table to class mapping - check if all of your Domain Classes are mapped properly to the tables you want to use. You can verify that for each class if you click on Edit Table item of the class context menu or alternatively you can verify in the Model Schema Explorer that all the tables are added to the Domain Model (the ones that are not mapped to a class would be grayed out).

I hope that helps. Do not hesitate to let us know if you need further assistance on this.

All the best,
Ivailo
the Telerik team