Entity Data Model Wizard Visual Studio 2010

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
anakin6680
Posts: 1
Joined: Wed 02 Jun 2010 19:58

Entity Data Model Wizard Visual Studio 2010

Post by anakin6680 » Wed 02 Jun 2010 20:03

I'm trying to create a Entity Data Model in Visual Studio 2010. I have gotten to the very last step where it asks, "Which database objects do you want to include in your model?". I select a single table and click on finish and VS locks up. Do you know what could be causing this?
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 03 Jun 2010 14:19

Could you please specify the following information?
1. Do you have the RTM version of Visual Studio 2010?
2. What is approximate number of tables in your schema?
Could you please provide us the call stack of the hanged VS? To obtain this call stack you can attach the first Visual Studio (the one that hangs) by a second instance. Please make sure that the Enable Just My Code check box (Tools->Options->Debugging) is not checked in the second instance of Visual Studio. Then just press Pause and you will see the call stack.
Top
park
Posts: 8
Joined: Tue 08 Jun 2010 01:45

Post by park » Tue 08 Jun 2010 01:53

We are also having this exact same problem. All three developers here have this same issue not only on VS 2010 but also on VS 2008. We have yet been unable to create an Entity Data Module.

The data provider has been configured in the machine.config and we're not sure what else needs to be done or able to find much information on the problem.



Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 08 Jun 2010 13:06

Park, could you please specify the information we have previously requested in this topic?
Top
park
Posts: 8
Joined: Tue 08 Jun 2010 01:45

Post by park » Wed 09 Jun 2010 06:04

1. Visual Studio 2010 10.0.30319.1 RTMRel
2. 175 tables in schema.

Oracle 9i

All developers have tried using both direct mode and the oracle client and waited patiently for up to an hour for the wizard to un-freeze.
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 09 Jun 2010 13:58

Could you please send us the call stack? I have already described the way to get it.
Please try to generate the same model using Devart Entity Developer (Add New Item...-> Devart Entity Model).
Top
park
Posts: 8
Joined: Tue 08 Jun 2010 01:45

Post by park » Wed 16 Jun 2010 02:17

Devart Entity Developer does work but this is not what we are trying to achieve in this thread.

-------------------------------------------------------------------------------------

Call Stack for VS 2010 Entity Data Model Wizard:

[In a sleep, wait, or join]
> mscorlib.dll!System.Threading.WaitHandle.WaitAny(System.Threading.WaitHandle[] waitHandles, int millisecondsTimeout, bool exitContext) + 0x8b bytes
System.dll!System.Net.TimerThread.ThreadProc() + 0x376 bytes
mscorlib.dll!System.Threading.ThreadHelper.ThreadStart_Context(object state) + 0x63 bytes
mscorlib.dll!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state, bool ignoreSyncCtx) + 0xb0 bytes
mscorlib.dll!System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext executionContext, System.Threading.ContextCallback callback, object state) + 0x2c bytes
mscorlib.dll!System.Threading.ThreadHelper.ThreadStart() + 0x44 bytes
[Native to Managed Transition]


-------------------------------------------------------------------------------------

Output Window (last few lines):


A first chance exception of type 'System.IO.PathTooLongException' occurred in mscorlib.dll
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.TemplateWizard\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.TemplateWizard.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.Data.Entity.Design.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio.Data.Services\9.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Data.Services.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PublicAssemblies\Microsoft.Data.Entity.Design.Extensibility.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.Data.Tools.XmlDesignerBase.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.Data.Tools.VSXmlDesignerBase.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.WizardFramework.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.Data.Package.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Data.Framework\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Data.Framework.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.Data.Host.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\assembly\GAC_MSIL\Microsoft.VisualStudio.Data.Core\9.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Data.Core.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.Data.Entity.Design.Package.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Modeling.Sdk.Shell.10.0\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Modeling.Sdk.Shell.10.0.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Modeling.Sdk.10.0\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Modeling.Sdk.10.0.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.Data.Entity.Design.EntityDesigner.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.Modeling.Sdk.Diagrams.10.0\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Modeling.Sdk.Diagrams.10.0.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\Microsoft.VisualStudio.Modeling.Sdk.Diagrams.GraphObject.10.0\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.Modeling.Sdk.Diagrams.GraphObject.10.0.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.Entity\v4.0_4.0.0.0__b77a5c561934e089\System.Data.Entity.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.Entity.Design\v4.0_4.0.0.0__b77a5c561934e089\System.Data.Entity.Design.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.DataTools.Interop.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VSDesigner\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.DataTools.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.Data.ConnectionUI.Dialog.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.Data.ConnectionUI.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.Data.Compatibility.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.Data.Interop.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualStudio.DataDesign.Interfaces\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.DataDesign.Interfaces.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.Web.Design.Client\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.Web.Design.Client.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\Microsoft.VisualStudio.Data.Providers.SqlEverywhere.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.Data.Providers.SqlServer.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.Data.Providers.Common.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data.OracleClient\v4.0_4.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies\Microsoft.VisualStudio.SharePoint.Explorer.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VSDesigner.Management.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.SqlServerCe.Client.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Data.SqlServerCe.Entity\3.5.1.0__89845dcd8080cc91\System.Data.SqlServerCe.Entity.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Microsoft.VisualStudio.Data.Providers.Oracle.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\assembly\GAC_MSIL\Devart.Data.Oracle\5.70.140.0__09af7300eec23701\Devart.Data.Oracle.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Devart.Data.Oracle.Entity\v4.0_5.70.140.0__09af7300eec23701\Devart.Data.Oracle.Entity.dll'
A first chance exception of type 'System.ArgumentException' occurred in Microsoft.VisualStudio.Design.dll
A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
A first chance exception of type 'System.IO.FileNotFoundException' occurred in mscorlib.dll
A first chance exception of type 'System.InvalidOperationException' occurred in System.Windows.Forms.dll
A first chance exception of type 'System.InvalidOperationException' occurred in System.Windows.Forms.dll
The thread '' (0x1c0d8) has exited with code 0 (0x0).
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'OciCall.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll'
'devenv.exe' (Managed (v4.0.30319)): Loaded 'C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll'
A first chance exception of type 'System.MissingMethodException' occurred in mscorlib.dll
A first chance exception of type 'System.MissingMethodException' occurred in mscorlib.dll
A first chance exception of type 'System.MissingMethodException' occurred in mscorlib.dll
A first chance exception of type 'System.MissingMethodException' occurred in mscorlib.dll
'devenv.exe' (Managed (v4.0.30319)): Loaded 'Anonymously Hosted DynamicMethods Assembly'
Top
stratdaz
Posts: 23
Joined: Tue 04 May 2010 00:46

Post by stratdaz » Fri 18 Jun 2010 07:28

Appears the wizard is hanging on an Oracle query.

When trying to generate a model on a table named "CUBE" owned by "DSS" the following query never returns ...

SELECT 1 AS C1,
'Catalog1' AS "CatalogName",
TAB.OWNER AS "SchemaName",
TAB.TABLE_NAME AS "Name",
COLS.COLUMN_NAME AS C2,
CASE COLS.NULLABLE
WHEN 'Y'
THEN
1
ELSE
0
END AS C4,
CASE
WHEN DATA_TYPE = 'NUMBER'
AND DATA_SCALE = 0
AND DATA_PRECISION = 1
THEN
'bool'
WHEN DATA_TYPE = 'NUMBER'
AND DATA_SCALE = 0
AND DATA_PRECISION BETWEEN 2
AND 9
THEN
'int'
WHEN DATA_TYPE = 'NUMBER'
AND DATA_SCALE = 0
AND DATA_PRECISION BETWEEN 10
AND 18
THEN
'int64'
WHEN DATA_TYPE = 'NUMBER'
AND ABS(DATA_SCALE) != DATA_SCALE
AND DATA_PRECISION + ABS(DATA_SCALE) BETWEEN 2
AND 9
THEN
'int'
WHEN DATA_TYPE = 'NUMBER'
AND ABS(DATA_SCALE) != DATA_SCALE
AND DATA_PRECISION + ABS(DATA_SCALE) BETWEEN 10
AND 18
THEN
'int64'
WHEN DATA_TYPE = 'NUMBER'
AND ABS(DATA_SCALE) = DATA_SCALE
AND DATA_PRECISION - DATA_SCALE BETWEEN 0
AND 333
AND DATA_PRECISION BETWEEN 1
AND 15
THEN
'double'
WHEN DATA_TYPE = 'NUMBER'
AND ABS(DATA_SCALE) = DATA_SCALE
AND DATA_PRECISION - DATA_SCALE NOT BETWEEN 0
AND 333
AND DATA_SCALE BETWEEN 1
AND 15
THEN
'double'
WHEN DATA_TYPE = 'NUMBER'
THEN
'decimal'
WHEN COLS.DATA_TYPE LIKE 'INTERVAL YEAR% TO MONTH%'
THEN
'INTERVAL YEAR TO MONTH'
WHEN COLS.DATA_TYPE LIKE 'INTERVAL DAY% TO SECOND%'
THEN
'INTERVAL DAY TO SECOND'
WHEN COLS.DATA_TYPE LIKE 'TIMESTAMP% WITH LOCAL TIME ZONE'
THEN
'TIMESTAMP WITH LOCAL TIME ZONE'
WHEN COLS.DATA_TYPE LIKE 'TIMESTAMP% WITH TIME ZONE'
THEN
'TIMESTAMP WITH TIME ZONE'
WHEN COLS.DATA_TYPE LIKE 'TIMESTAMP%'
THEN
'TIMESTAMP'
WHEN COLS.DATA_TYPE = 'RAW'
AND COLS.DATA_LENGTH = 16
THEN
'guid'
ELSE
COLS.DATA_TYPE
END AS C5,
CASE
WHEN COLS.DATA_TYPE = 'CLOB'
THEN
2147483643
WHEN COLS.DATA_TYPE = 'NCLOB'
THEN
2147483646
ELSE
COLS.DATA_LENGTH
END AS C6,
CASE
WHEN COLS.DATA_PRECISION IS NULL
THEN
NULL
WHEN COLS.DATA_TYPE = 'FLOAT'
THEN
NULL
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) != COLS.DATA_SCALE
AND COLS.DATA_PRECISION + ABS(COLS.DATA_SCALE) BETWEEN 1
AND 29
THEN
COLS.DATA_PRECISION + ABS(COLS.DATA_SCALE)
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) = COLS.DATA_SCALE
AND COLS.DATA_PRECISION - COLS.DATA_SCALE NOT BETWEEN 0
AND 333
AND COLS.DATA_SCALE BETWEEN 1
AND 28
THEN
COLS.DATA_SCALE
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) = COLS.DATA_SCALE
AND COLS.DATA_PRECISION - COLS.DATA_SCALE NOT BETWEEN 0
AND 333
THEN
28
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) = COLS.DATA_SCALE
AND COLS.DATA_PRECISION - COLS.DATA_SCALE BETWEEN 0
AND 333
AND COLS.DATA_PRECISION BETWEEN 1
AND 29
THEN
COLS.DATA_PRECISION
ELSE
29
END AS C7,
0 AS C8,
CASE
WHEN COLS.DATA_SCALE IS NULL
THEN
NULL
WHEN COLS.DATA_TYPE = 'FLOAT'
THEN
NULL
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) != COLS.DATA_SCALE
THEN
0
WHEN COLS.DATA_SCALE BETWEEN 0
AND 28
THEN
COLS.DATA_SCALE
ELSE
28
END AS C9,
0 AS C10,
0 AS C11,
CASE
WHEN (PKCOLS.POSITION IS NULL)
THEN
0
ELSE
1
END AS C12,
COLS.COLUMN_ID
FROM ALL_TABLES TAB INNER JOIN SYS.ALL_TAB_COLUMNS COLS ON ((TAB.OWNER || '.'
|| TAB.TABLE_NAME IN ('DSS.CUBE'))
AND TAB.OWNER = COLS.OWNER
AND TAB.TABLE_NAME = COLS.TABLE_NAME) LEFT OUTER JOIN SYS.ALL_CONSTRAINTS
PK ON (PK.CONSTRAINT_TYPE = 'P'
AND TAB.OWNER = PK.OWNER
AND TAB.TABLE_NAME = PK.TABLE_NAME) LEFT OUTER JOIN SYS.ALL_CONS_COLUMNS
PKCOLS ON (TAB.OWNER = PKCOLS.OWNER
AND TAB.TABLE_NAME = PKCOLS.TABLE_NAME
AND PK.CONSTRAINT_NAME = PKCOLS.CONSTRAINT_NAME
AND COLS.COLUMN_NAME = PKCOLS.COLUMN_NAME) UNION ALL
SELECT 1 AS C1,
'Catalog1' AS "CatalogName",
TAB.OWNER AS "SchemaName",
TAB.TABLE_NAME AS "Name",
COLS.COLUMN_NAME AS C2,
CASE COLS.NULLABLE
WHEN 'Y'
THEN
1
ELSE
0
END AS C4,
CASE
WHEN DATA_TYPE = 'NUMBER'
AND DATA_SCALE = 0
AND DATA_PRECISION = 1
THEN
'bool'
WHEN DATA_TYPE = 'NUMBER'
AND DATA_SCALE = 0
AND DATA_PRECISION BETWEEN 2
AND 9
THEN
'int'
WHEN DATA_TYPE = 'NUMBER'
AND DATA_SCALE = 0
AND DATA_PRECISION BETWEEN 10
AND 18
THEN
'int64'
WHEN DATA_TYPE = 'NUMBER'
AND ABS(DATA_SCALE) != DATA_SCALE
AND DATA_PRECISION + ABS(DATA_SCALE) BETWEEN 2
AND 9
THEN
'int'
WHEN DATA_TYPE = 'NUMBER'
AND ABS(DATA_SCALE) != DATA_SCALE
AND DATA_PRECISION + ABS(DATA_SCALE) BETWEEN 10
AND 18
THEN
'int64'
WHEN DATA_TYPE = 'NUMBER'
AND ABS(DATA_SCALE) = DATA_SCALE
AND DATA_PRECISION - DATA_SCALE BETWEEN 0
AND 333
AND DATA_PRECISION BETWEEN 1
AND 15
THEN
'double'
WHEN DATA_TYPE = 'NUMBER'
AND ABS(DATA_SCALE) = DATA_SCALE
AND DATA_PRECISION - DATA_SCALE NOT BETWEEN 0
AND 333
AND DATA_SCALE BETWEEN 1
AND 15
THEN
'double'
WHEN DATA_TYPE = 'NUMBER'
THEN
'decimal'
WHEN COLS.DATA_TYPE LIKE 'INTERVAL YEAR% TO MONTH%'
THEN
'INTERVAL YEAR TO MONTH'
WHEN COLS.DATA_TYPE LIKE 'INTERVAL DAY% TO SECOND%'
THEN
'INTERVAL DAY TO SECOND'
WHEN COLS.DATA_TYPE LIKE 'TIMESTAMP% WITH LOCAL TIME ZONE'
THEN
'TIMESTAMP WITH LOCAL TIME ZONE'
WHEN COLS.DATA_TYPE LIKE 'TIMESTAMP% WITH TIME ZONE'
THEN
'TIMESTAMP WITH TIME ZONE'
WHEN COLS.DATA_TYPE LIKE 'TIMESTAMP%'
THEN
'TIMESTAMP'
WHEN COLS.DATA_TYPE = 'RAW'
AND COLS.DATA_LENGTH = 16
THEN
'guid'
ELSE
COLS.DATA_TYPE
END AS C5,
CASE
WHEN COLS.DATA_TYPE = 'CLOB'
THEN
2147483643
WHEN COLS.DATA_TYPE = 'NCLOB'
THEN
2147483646
ELSE
COLS.DATA_LENGTH
END AS C6,
CASE
WHEN COLS.DATA_PRECISION IS NULL
THEN
NULL
WHEN COLS.DATA_TYPE = 'FLOAT'
THEN
NULL
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) != COLS.DATA_SCALE
AND COLS.DATA_PRECISION + ABS(COLS.DATA_SCALE) BETWEEN 1
AND 29
THEN
COLS.DATA_PRECISION + ABS(COLS.DATA_SCALE)
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) = COLS.DATA_SCALE
AND COLS.DATA_PRECISION - COLS.DATA_SCALE NOT BETWEEN 0
AND 333
AND COLS.DATA_SCALE BETWEEN 1
AND 28
THEN
COLS.DATA_SCALE
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) = COLS.DATA_SCALE
AND COLS.DATA_PRECISION - COLS.DATA_SCALE NOT BETWEEN 0
AND 333
THEN
28
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) = COLS.DATA_SCALE
AND COLS.DATA_PRECISION - COLS.DATA_SCALE BETWEEN 0
AND 333
AND COLS.DATA_PRECISION BETWEEN 1
AND 29
THEN
COLS.DATA_PRECISION
ELSE
29
END AS C7,
0 AS C8,
CASE
WHEN COLS.DATA_SCALE IS NULL
THEN
NULL
WHEN COLS.DATA_TYPE = 'FLOAT'
THEN
NULL
WHEN COLS.DATA_TYPE = 'NUMBER'
AND ABS(COLS.DATA_SCALE) != COLS.DATA_SCALE
THEN
0
WHEN COLS.DATA_SCALE BETWEEN 0
AND 28
THEN
COLS.DATA_SCALE
ELSE
28
END AS C9,
0 AS C10,
0 AS C11,
CASE
WHEN (PKCOLS.POSITION IS NULL)
THEN
0
ELSE
1
END AS C12,
COLS.COLUMN_ID
FROM SYS.ALL_OBJECT_TABLES TAB INNER JOIN SYS.ALL_TAB_COLUMNS COLS ON ((TAB.OWNER
|| '.' || TAB.TABLE_NAME IN ('DSS.CUBE'))
AND TAB.OWNER = COLS.OWNER
AND TAB.TABLE_NAME = COLS.TABLE_NAME) LEFT OUTER JOIN SYS.ALL_CONSTRAINTS
PK ON (PK.CONSTRAINT_TYPE = 'P'
AND TAB.OWNER = PK.OWNER
AND TAB.TABLE_NAME = PK.TABLE_NAME) LEFT OUTER JOIN SYS.ALL_CONS_COLUMNS
PKCOLS ON (TAB.OWNER = PKCOLS.OWNER
AND TAB.TABLE_NAME = PKCOLS.TABLE_NAME
AND PK.CONSTRAINT_NAME = PKCOLS.CONSTRAINT_NAME
AND COLS.COLUMN_NAME = PKCOLS.COLUMN_NAME)
ORDER BY 3, 4, 15

Looking closer at the SYS.ALL_OBJECT_TABLES table shows that it doesn't contain any information about the "CUBE" table.

Just has ...

TABLE_NAME
KOTTD$
KOTTB$
KOTAD$
KOTMD$
KOTTBX$
KOTADX$

We are running Oracle 9.2.0.7.0[/img]
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 21 Jun 2010 15:04

We have answered you by e-mail.
Top
park
Posts: 8
Joined: Tue 08 Jun 2010 01:45

Post by park » Tue 29 Jun 2010 05:17

Would it be possible to see the answer to this problem here on the forum?
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 29 Jun 2010 09:12

Stratdaz has confirmed that the SYS.ALL_OBJECT_TABLES view doesn't return any resultset from his Oracle 9i database. This causes the problem.

The way Microsoft EDM Wizard retrieves metadata from data source is not the best way for Oracle. The wizard's performance significantly decreases when there are many database objects available. We recommend you to create model with Entity Developer (the Devart Entiry Model template). It is optimized for working with Oracle Server. Any time you can change an extension of the model generated by our tool (*.edml) to the *.edmx extension. And you can work with this model using standard Visual Studio Entity Data Model Wizard after this. The XML of the corresponding *.edml and *.edmx is the same.
Top
park
Posts: 8
Joined: Tue 08 Jun 2010 01:45

Post by park » Tue 29 Jun 2010 22:44

Changing the extension from edml to edmx does not solve the problem for me. The model does convert ok and I can view it but the Entity Framework dialog still freezes when trying to add new entities to the model.

Can you please confirm whether you can add entities to a converted model as you described for an Oracle 9i database? If successful please give the steps involved.
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 30 Jun 2010 15:55

Park, according to dotConnect for Oracle Entity Framework compatibility, version of Oracle Server should be 9.2.0.4 or higher. Please tell us the exact versions of your Oracle Server and Oracle Client.
Top
park
Posts: 8
Joined: Tue 08 Jun 2010 01:45

Post by park » Fri 02 Jul 2010 04:05

Oracle Database: 9.2.0.7
Oracle Client: 11g
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 02 Jul 2010 16:38

Park, changing *.edml to *.edmx is not a workaround. It was note that you can generate model using Entity Developer, and then use it with Visual Studio Entity Data Model Wizard.

We cannot reproduce the problem with freezing Entity Data Model Wizard in our environment. Maybe this is a problem of Entity Data Model Wizard itself. The similar problem was reported here: http://social.msdn.microsoft.com/Forums ... 08616f6df6.
Top
Post Reply

Return to “dotConnect for Oracle”