Devart Forums

Has anyone found a way to manage this? The thought process was one version of the code, two projects, one project with an Oracle model and one with a SQL server model.

The capitilization of the column names has to match to get the binding to work correctly (silverlight) etc. so the two project approach is becoming painful.

Is the Universal product an option - it doesn't state support for the entity framework?

got it thanks - here is a vb implementation

Namespace nWorkArea
' fix ORA-01790
Partial Public Class WorkAreaEntities

Private Sub OnContextCreated()
Devart.Data.Oracle.Entity.OracleEntityProviderServices.TypedNulls = True
End Sub

End Class
End Namespace

I'm using silverlight on the front end and the entity framework for data access. I have no idea where to sent the above parameter to true - is there a web.config setting I can use?

I'm using the entity framework (edmx)

I have a table A that has 8 references to an employee table. The references are for things like
created by user
last changed by user
manager to approve
person who signed off on plan
person who executed plan
etc.

in the edmx model for table A I have right clicked on each reference and change the name
EMPLOYEEMANAGER for example
I use setlink to update and the correct reference is stored in the database
however when I query the data back in with

query = From p In _
Me.m_ADOService.A.Expand("EMPLOYEECREATEDBY").Expand("EMPLOYEELASTCHANGEDBY").Expand("EMPLOYEEBDN").Expand("EMPLOYEEPARTS").Expand("EMPLOYEEMANAGER").Expand("EMPLOYEEPLANSENT") _
Where p.OI = 123 Select p


None of the employee references are loaded

any suggestions?

Please provide more information on this fix

Fixed bug with using objects from different contexts

thanks

the problem can be demonstrated with 3 tables

CREATE TABLE ES.A2
( "OI" NUMBER(11,0) NOT NULL ENABLE,
CONSTRAINT "A2_PK" PRIMARY KEY ("OI"));

CREATE TABLE ES.C2
( "OI" NUMBER(11,0) NOT NULL ENABLE,
"C2_DATA" VARCHAR2(10),
CONSTRAINT "C2_PK" PRIMARY KEY ("OI"));

CREATE TABLE ES.B2
("OI" NUMBER(11,0) NOT NULL ENABLE,
"OI_A2" NUMBER(11,0),
"OI_C2" NUMBER(11,0),
CONSTRAINT "B2_PK" PRIMARY KEY ("OI"),
CONSTRAINT FK_A2 FOREIGN KEY (OI_A2)
REFERENCES ES.A2 (OI),
CONSTRAINT FK_C2 FOREIGN KEY (OI_C2)
REFERENCES ES.C2 (OI));

The model looks correct

a2 is connected to b2 which is connect to c2

I can write, compile and execute this LINQ statement

Dim qA2B2C2 As Linq.IOrderedQueryable(Of A2)

qA2B2C2 = From A2B2C2 In m_ADOEntities.A2.Expand("B2").Expand("B2/C2") _
Where A2B2C2.OI = 1 Select A2B2C2



But get errors when trying to access data in C2

start, settings, control panel, system
advanced tab
environment variables button
system variables, path

mine looks like this
C:\oracle\product\10.2.0\db_1\bin;C:\oracle\product\10.2.0\client_1\bin;C:\oracle\product\10.2.0\client_2\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\;C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\

This linq statement in Silverlight 2

Dim query = From p In myContext.WORKAREA_EMPLOYEE.Expand("EMPLOYEE").Expand("EMPLOYEE/SITELINK").Expand("EMPLOYEE/SITELINK/TRADE") _
Select p

Almost works. The ("EMPLOYEE/SITELINK/TRADE") does not work. The Trade object is nothing.

First is this a Microsoft issue or a Devarts issue? If it's a Devarts issue is there a way to get from table1 to table4 (workarea_employee, employee, siltelink, trade)

We have an existing project built with the "ADO.Net Entity Data model"

When I added the "ADO.Net Entity Data model" to the project VS 2008 included an model.edmx file and a model.designer.vb file

I can import the EDMX file into the DevArts toolset and generate a model.vb

When I drop the model.designer.vb and include the model.vb file the project does not start. I have not spent much time on this it looks to be related to he connection strings in the web.config. The constructors in the devarts generated vb file are slightly different than the Microsoft generated files.

Should we just be using DevArts for new models? I just noticed that I can add a Devarts Entity Model template?

In a legacy database I have a customer table and a contact table

Customer Table
InternalKey
CustomerID
Name
PrimaryContact_InternalKey

Contact Table
InternalKey
Customer_InternalKey
Name
Etc.

What I think I should be able to do is put the contact table into the model once and then inherit from it twice once for PrimaryContact and once for all Contacts.
Does anyone have an example showing how to work with the one contact table in two different contexts?

is there a way to generate an EDMX file from the Entity Developer?

production server web.config section had a small difference from the development server.

(Right-click on Project -> Add-> New Item...->Devart Entity Model).


I can add an Entity Model for SQL Server (have the trial version installed) but not an Entity Model for Oracle

Any suggestions?

Microsoft has provided instructions

http://msdn.microsoft.com/en-us/library/ms732023.aspx

on the development computer everything works

on the deployment server things work once and then stop working

to deploy I ran the licensed minimal install of DevArts dcoracle500pro.exe
and then copied from the development computer to the deployment server

devart.data.dll
devart.data.oracle.dll
devart.data.oracle.entity.dll
devart.data.oracle.web.dll

to the

c:\inetpub\wwwroot\myapp directory

and to the

c:\inetpub\wwwroot\myapp\bin directory

because the create, read, update, delete cycle worked once on the server I think I have an installation or licensing issue.

Has anyone resolved how to deploy dotConnect and have it work more than once?