[Oracle + devart + EF6] How to use different schemas

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
downwind
Posts: 19
Joined: Tue 19 May 2015 15:37

[Oracle + devart + EF6] How to use different schemas

Post by downwind » Wed 17 Jun 2015 16:10

Gentlemen
I need to get access (query/insert/update) to tables located in different schema.
I've successfully generated and built the software; at runtime, context is created as well as all requested objects, but as soon as I execute the AddObject():

Code: Select all

            L3Core.Communication.DM.PPS_L2SMP.PPS_SMP_INT_SEND controlItem = new DM.PPS_L2SMP.PPS_SMP_INT_SEND();
            controlItem.MSG_ID = telegramId;
            controlItem.MSG_KEY = telegramId.ToString();    // Not in use
            controlItem.READ_COUNT = 0;
            controlItem.SEND_TIME = DateTime.Now;
            controlItem.SIMULATION = 0;
            controlItem.STATUS = 0;
            controlItem.STATUS_TEXT = "";
            context.PPS_SMP_INT_SENDs.AddObject(controlItem); // <------- THIS
I get the exception:
An exception of type 'System.InvalidOperationException' occurred in EntityFramework.dll but was not handled in user code

Additional information: The EntitySet name 'PpsL2SmpEntities.PPS_SMP_INT_SENDs' could not be found.
Model has been created via Entity Developer without any problem. During table selection I've un-selected the default schema and opened the one I need. Other settings have been kept as default.

Did I forget something?

downwind
Posts: 19
Joined: Tue 19 May 2015 15:37

Re: [Oracle + devart + EF6] How to use different schemas

Post by downwind » Thu 18 Jun 2015 13:21

Sorry guys, I found my mistake: I simply copied the wrong configuration files. Now it works fine

Apologise for disturbing

Post Reply