Can`t generating Model from Database

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
sergey.sementsov
Posts: 3
Joined: Thu 14 Sep 2017 09:36

Can`t generating Model from Database

Post by sergey.sementsov » Thu 14 Sep 2017 09:53

Hello.

I have dotConnect "9.4.348" licanse version. And I can`t generate .edmx model from Oracle Database Express Edition 11g Release 2.

I use this tutorial (https://www.devart.com/dotconnect/oracl ... al_ef.html), but I have next error:

Image
Unable to generate the model because of the following exception: 'System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.InvalidOperationException: Unknown active document.
at Devart.Data.Oracle.Entity.ag.n()
at Devart.Data.Oracle.Entity.ag.m()
at Devart.Data.Oracle.Entity.ag.k()
at Devart.Data.Oracle.Entity.ag.a(Int32 A_0)
at Devart.Data.Oracle.Entity.m.a(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.m.b(CommandBehavior A_0)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.<Reader>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Internal.InterceptableDbCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
--- End of inner exception stack trace ---
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.Execute(EntityCommand entityCommand, CommandBehavior behavior)
at System.Data.Entity.Core.EntityClient.EntityCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadDataTable[T](String sql, Func`2 orderByFunc, DataTable table, EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1 filters, String[] filterAliases)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadTableDetails(IEnumerable`1 filters)
at Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.LoadStoreSchemaDetails(IList`1 filters)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.GetStoreSchemaDetails(StoreSchemaConnectionFactory connectionFactory)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.CreateStoreModel()
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelGenerator.GenerateModel(List`1 errors)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModels(String storeModelNamespace, ModelBuilderSettings settings, List`1 errors)
at Microsoft.Data.Entity.Design.VisualStudio.ModelWizard.Engine.ModelBuilderEngine.GenerateModel(ModelBuilderSettings settings, IVsUtils vsUtils, ModelBuilderEngineHostContext hostContext)'.
Loading metadata from the database took 00:01:04.5759212.
Generating the model took 00:00:02.3998614.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Can`t generating Model from Database

Post by Pinturiccio » Fri 15 Sep 2017 11:43

Please send us the Copy Info information of your Visual Studio. Open Visual Studio and navigate to Help->About Microsoft Visual Studio in the main menu. Click Copy Info in the opened window. The info will be copied to the clipboard. Post it here.

Please also try creating your model in the following way:
1. Right-click the project and select Add->New.
2. Switch to Data tab and select Devart Entity Model.
3. Click Add.
4. Select Database First and click Next.
5. Set the connection parameters in order to connect to Oracle.
6. After you have set the connection parameters and Test Connection is successful, click Next.
7. Select "Generate From Database" and click Next.
8. Select objects described in the tutorial and click Next.
9. Click Next until the Finish button appears and click Finish.
Is a model created in this case?

sergey.sementsov
Posts: 3
Joined: Thu 14 Sep 2017 09:36

Re: Can`t generating Model from Database

Post by sergey.sementsov » Fri 15 Sep 2017 12:27

Microsoft Visual Studio Professional 2017 (2)
Version 15.2 (26430.15) Release
VisualStudio.15.Release/15.2.0+26430.15
Microsoft .NET Framework
Version 4.7.02053

Installed Version: Professional

Visual Basic 2017 00369-60000-00001-AA920
Microsoft Visual Basic 2017

Visual C# 2017 00369-60000-00001-AA920
Microsoft Visual C# 2017

Visual C++ 2017 00369-60000-00001-AA920
Microsoft Visual C++ 2017

Visual F# 4.1 00369-60000-00001-AA920
Microsoft Visual F# 4.1

Application Insights Tools for Visual Studio Package 8.6.00404.2
Application Insights Tools for Visual Studio

ASP.NET and Web Tools 2017 15.0.30503.0
ASP.NET and Web Tools 2017

ASP.NET Web Frameworks and Tools 2017 5.2.50303.0
For additional information, visit https://www.asp.net/

Azure App Service Tools v3.0.0 15.0.30209.0
Azure App Service Tools v3.0.0

Azure Data Lake Node 1.0
This package contains the Data Lake integration nodes for Server Explorer.

Azure Data Lake Tools for Visual Studio 2.2.5000.0
Microsoft Azure Data Lake Tools for Visual Studio

Common Azure Tools 1.9
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

Cookiecutter 3.0.17114.1
Provides tools for finding, instantiating and customizing templates in cookiecutter format.

Devart dbForge Fusion for Oracle, Standard 3.8.11
Devart dbForge Fusion for Oracle, Standard
Copyright 2004 - 2015 Devart. All rights reserved.
Web: www.devart.com/dbforge/Oracle/fusion
Support: www.devart.com/dbforge/Oracle/fusion/support.html

Devart dotConnect for Oracle 9.4.348.0
Devart dotConnect for Oracle
Copyright 2002 - 2017 Devart. All rights reserved.
Web: www.devart.com/dotconnect/oracle
Support: support@devart.com

Devart Entity Developer 6.1.333.0
Devart Entity Developer
Copyright © 2008-2017 Devart. All rights reserved.
Web: www.devart.com/entitydeveloper
Support: support@devart.com

GitHub.VisualStudio 2.3.2.32
A Visual Studio Extension that brings the GitHub Flow into Visual Studio.

JavaScript Language Service 2.0
JavaScript Language Service

JavaScript Project System 2.0
JavaScript Project System

JetBrains ReSharper Ultimate 2017.1.3 Build 108.0.20170613.154143
JetBrains ReSharper Ultimate package for Microsoft Visual Studio. For more information about ReSharper Ultimate, visit http://www.jetbrains.com/resharper. Copyright © 2017 JetBrains, Inc.

KofePackagePackage Extension 1.0
KofePackagePackage Visual Studio Extension Detailed Info

MenuCommands Extension 1.0
MenuCommands Visual Studio Extension Detailed Info

Microsoft Azure Hive Query Language Service 2.2.5000.0
Language service for Hive query

Microsoft Azure Tools 2.9
Microsoft Azure Tools for Microsoft Visual Studio 2017 - v2.9.50131.1

Microsoft MI-Based Debugger 1.0
Provides support for connecting Visual Studio to MI compatible debuggers

Microsoft Visual Studio VC Package 1.0
Microsoft Visual Studio VC Package

Node.js Tools 1.3.50417.1
Adds support for developing and debugging Node.js apps in Visual Studio

NuGet Package Manager 4.2.0
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Oracle Developer Tools for Visual Studio 12.2.0.1.0
Oracle Developer Tools for Visual Studio Copyright (c) 2005, 2017

OzCode 1.0
Your road to Magical Debugging. http://www.oz-code.com

OzCodePackage Extension 1.0
OzCodePackage Visual Studio Extension Detailed Info

Python 3.0.17114.1
Provides IntelliSense, projects, templates, debugging, interactive windows, and other support for Python developers.

Python - Django support 3.0.17114.1
Provides templates and integration for the Django web framework.

Python - IronPython support 3.0.17114.1
Provides templates and integration for IronPython-based projects.

Python - Profiling support 3.0.17114.1
Profiling support for Python projects.

R Tools for Visual Studio 1.1.30523.1233
Provides project system, R Interactive window, plotting, and more for the R programming language.

SlowCheetah - XML config transforms 1.0
This package enables you to transform your app.config or any other XML file based on the build configuration. It also adds additional tooling to help you create XML transforms.

SQL Server Data Tools 15.1.61702.140
Microsoft SQL Server Data Tools

ToolWindowHostedEditor 1.0
Hosting json editor into a tool window

TypeScript 2.2.2.0
TypeScript tools for Visual Studio

sergey.sementsov
Posts: 3
Joined: Thu 14 Sep 2017 09:36

Re: Can`t generating Model from Database

Post by sergey.sementsov » Fri 15 Sep 2017 12:28

Unfortunately, does not work. After p.9 I have the error.
Pinturiccio wrote:Please send us the Copy Info information of your Visual Studio. Open Visual Studio and navigate to Help->About Microsoft Visual Studio in the main menu. Click Copy Info in the opened window. The info will be copied to the clipboard. Post it here.

Please also try creating your model in the following way:
1. Right-click the project and select Add->New.
2. Switch to Data tab and select Devart Entity Model.
3. Click Add.
4. Select Database First and click Next.
5. Set the connection parameters in order to connect to Oracle.
6. After you have set the connection parameters and Test Connection is successful, click Next.
7. Select "Generate From Database" and click Next.
8. Select objects described in the tutorial and click Next.
9. Click Next until the Finish button appears and click Finish.
Is a model created in this case?

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Can`t generating Model from Database

Post by Pinturiccio » Wed 20 Sep 2017 13:15

sergey.sementsov wrote:Unfortunately, does not work. After p.9 I have the error.
Please post the exception message and stack trace here.

Post Reply