#1  
Old 9th February 2016, 02:37 AM
Christian Holm J?rgensen
 
Posts: n/a
Default Unable to build Entity model via build 242 on VS 2015

Hi.
I have just purchased and installed
NexusDB_V4_Visual_Studio_Pack_Standard_build242
on Win 7, 64bit.

I have Visual Studio 2015 Update 1.

I am able to add my existing database from NexusDB v. 3.1203 (see
1_NexusDbAdoNetConnection.png)
I am able to browse the tables and execute select queries.

Then I want to build an EF model from the database.

I follow the guide "NexusDB ADO.NET Provider,
Entity Framework Support"
provided by you. And get EF installed, removed sql reference and
modified the App.Config (see 2_EF_Installed.png)

I then try to import the database as a model, but receive this
message (see 3_EF_Error.png)

Any suggestions?

Best regards Christian

Attached Images
File Type: png 1_NexusDbAdoNetConnection.png (14.8 KB, 2 views)
File Type: png 2_EF_Installed.png (50.7 KB, 2 views)
File Type: png 3_EF_Error.png (21.1 KB, 3 views)
  #2  
Old 9th February 2016, 03:48 AM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Unable to build Entity model via build 242 on VS 2015

Please add references to NexusDB.ADOProvider and NexusDB.ADOProvider.Linq to
your project (both should be installed in the GAC). Then, as the text in the
wizard instructs, rebuild the project before trying to run the wizard again.

Also, make sure the version of EntityFramework that you are referencing is 6.1.3

Christian Holm J?rgensen wrote:

> Hi.
> I have just purchased and installed
> NexusDB_V4_Visual_Studio_Pack_Standard_build242
> on Win 7, 64bit.
>
> I have Visual Studio 2015 Update 1.
>
> I am able to add my existing database from NexusDB v. 3.1203 (see
> 1_NexusDbAdoNetConnection.png)
> I am able to browse the tables and execute select queries.
>
> Then I want to build an EF model from the database.
>
> I follow the guide "NexusDB ADO.NET Provider,
> Entity Framework Support"
> provided by you. And get EF installed, removed sql reference and
> modified the App.Config (see 2_EF_Installed.png)
>
> I then try to import the database as a model, but receive this
> message (see 3_EF_Error.png)
>
> Any suggestions?
>
> Best regards Christian


  #3  
Old 9th February 2016, 11:51 PM
Christian Holm J?rgensen
 
Posts: n/a
Default Re: Unable to build Entity model via build 242 on VS 2015

Hi.

1.
Adding the ref's to Nexus assemblies fixed the problem.
I think a line about this detail should be added to the help file.

2.
However, now I received an error when trying to access the
available tables to import in the Entity Wizard
(NexusErrorEntityDataModelWizard.PNG).

The strange thing is: If I cancel the dialog and retry multiple
times I may get lucky to have the tables overview.

Then, in such lucky case I try to build the entity model through
the wizard and receive the exception stack trace (see below).

-> Only once during my many retry attempts, I have been able to
successfully complete the wizard and get the complete model
of my database.

I have ensured I have installed EF 6.1.3.
I have saved all, rebuild, cleaned several times.


Exception Stack Trace:
======================
The model was generated with warnings or errors.Model1.edmxPlease see
the Error List for more details. These issues must be fixed before
running your application.
Loading metadata from the database took 00:00:01.3991650.
Generating the model took 00:00:02.3856912.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0041253.
Unable to generate the model because of the following exception:
'System.Data.Entity.Core.EntityCommandExecutionExc eption: An error
occurred while executing the command definition. See the inner
exception for details. --->
System.Runtime.InteropServices.SEHException: External component has
thrown an exception.
at NexusDB.ADOProvider.NxDLLDB32._SetParam(Int64 _aStatementID,
String ParameterName, Byte ParameterType, Int32 aLength, Byte[] aData,
Boolean IsNull)
at NexusDB.ADOProvider.NxDLLDB32.SetParam(Int64 aStatementID, Byte[]
ParameterName, Byte ParameterType, Int32 aLength, Byte[] aData, Boolean
IsNull)
at NexusDB.ADOProvider.NxCommand.ProcessParams(Int64 anxStatementID,
String strCommandText, NxParameterCollection objParameters, CultureInfo
objCulture, CommandBehavior behavior)
at
NexusDB.ADOProvider.NxCommand.InternalExecuteReade r(CommandBehavior
behavior)
at NexusDB.ADOProvider.NxCommand.ExecuteDbDataReader( CommandBehavior
behavior)
at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
behavior)
at
System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.<Read
er>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
at
System.Data.Entity.Infrastructure.Interception.Int ernalDispatcher`1.Disp
atch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3
operation, TInterceptionContext interceptionContext, Action`3
executing, Action`3 executed)
at
System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.Reade
r(DbCommand command, DbCommandInterceptionContext interceptionContext)
at
System.Data.Entity.Internal.InterceptableDbCommand .ExecuteDbDataReader(C
ommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
behavior)
at
System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
behavior)
--- End of inner exception stack trace ---
at
System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
behavior)
at
System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
ecute(EntityCommand entityCommand, CommandBehavior behavior)
at
System.Data.Entity.Core.EntityClient.EntityCommand .ExecuteReader(Command
Behavior behavior)
at
Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadDataTable[T](
String sql, Func`2 orderByFunc, DataTable table,
EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1 filters,
String[] filterAliases)
at
Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadViewDetails(I
Enumerable`1 filters)
at
Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadStoreSchemaDe
tails(IList`1 filters)
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
tor.GetStoreSchemaDetails(StoreSchemaConnectionFac tory
connectionFactory)
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
tor.CreateStoreModel()
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
tor.GenerateModel(List`1 errors)
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBuilde
rEngine.GenerateModels(String storeModelNamespace, ModelBuilderSettings
settings, List`1 errors)
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBuilde
rEngine.GenerateModel(ModelBuilderSettings settings, IVsUtils vsUtils,
ModelBuilderEngineHostContext hostContext)'.
Loading metadata from the database took 00:00:01.3610970.
Generating the model took 00:00:03.9692479.
Unable to generate the model because of the following exception:
'System.Data.Entity.Core.EntityCommandExecutionExc eption: An error
occurred while executing the command definition. See the inner
exception for details. --->
System.Runtime.InteropServices.SEHException: External component has
thrown an exception.
at NexusDB.ADOProvider.NxDLLDB32._SetParam(Int64 _aStatementID,
String ParameterName, Byte ParameterType, Int32 aLength, Byte[] aData,
Boolean IsNull)
at NexusDB.ADOProvider.NxDLLDB32.SetParam(Int64 aStatementID, Byte[]
ParameterName, Byte ParameterType, Int32 aLength, Byte[] aData, Boolean
IsNull)
at NexusDB.ADOProvider.NxCommand.ProcessParams(Int64 anxStatementID,
String strCommandText, NxParameterCollection objParameters, CultureInfo
objCulture, CommandBehavior behavior)
at
NexusDB.ADOProvider.NxCommand.InternalExecuteReade r(CommandBehavior
behavior)
at NexusDB.ADOProvider.NxCommand.ExecuteDbDataReader( CommandBehavior
behavior)
at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
behavior)
at
System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.<Read
er>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
at
System.Data.Entity.Infrastructure.Interception.Int ernalDispatcher`1.Disp
atch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3
operation, TInterceptionContext interceptionContext, Action`3
executing, Action`3 executed)
at
System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.Reade
r(DbCommand command, DbCommandInterceptionContext interceptionContext)
at
System.Data.Entity.Internal.InterceptableDbCommand .ExecuteDbDataReader(C
ommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
behavior)
at
System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
behavior)
--- End of inner exception stack trace ---
at
System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
behavior)
at
System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
ecute(EntityCommand entityCommand, CommandBehavior behavior)
at
System.Data.Entity.Core.EntityClient.EntityCommand .ExecuteReader(Command
Behavior behavior)
at
Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadDataTable[T](
String sql, Func`2 orderByFunc, DataTable table,
EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1 filters,
String[] filterAliases)
at
Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadTableDetails(
IEnumerable`1 filters)
at
Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadStoreSchemaDe
tails(IList`1 filters)
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
tor.GetStoreSchemaDetails(StoreSchemaConnectionFac tory
connectionFactory)
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
tor.CreateStoreModel()
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
tor.GenerateModel(List`1 errors)
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBuilde
rEngine.GenerateModels(String storeModelNamespace, ModelBuilderSettings
settings, List`1 errors)
at
Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBuilde
rEngine.GenerateModel(ModelBuilderSettings settings, IVsUtils vsUtils,
ModelBuilderEngineHostContext hostContext)'.
Loading metadata from the database took 00:00:01.4033457.
Generating the model took 00:00:14.4342030.



Best regards Christian

Thorsten Engler [NDA] wrote:

> Please add references to NexusDB.ADOProvider and
> NexusDB.ADOProvider.Linq to your project (both should be installed in
> the GAC). Then, as the text in the wizard instructs, rebuild the
> project before trying to run the wizard again.
>
> Also, make sure the version of EntityFramework that you are
> referencing is 6.1.3
>
> Christian Holm J?rgensen wrote:
>
> > Hi.
> > I have just purchased and installed
> > NexusDB_V4_Visual_Studio_Pack_Standard_build242
> > on Win 7, 64bit.
> >
> > I have Visual Studio 2015 Update 1.
> >
> > I am able to add my existing database from NexusDB v. 3.1203 (see
> > 1_NexusDbAdoNetConnection.png)
> > I am able to browse the tables and execute select queries.
> >
> > Then I want to build an EF model from the database.
> >
> > I follow the guide "NexusDB ADO.NET Provider,
> > Entity Framework Support"
> > provided by you. And get EF installed, removed sql reference and
> > modified the App.Config (see 2_EF_Installed.png)
> >
> > I then try to import the database as a model, but receive this
> > message (see 3_EF_Error.png)
> >
> > Any suggestions?
> >
> > Best regards Christian



Attached Images
File Type: png NexusErrorEntityDataModelWizard.PNG (143.9 KB, 1 views)
  #4  
Old 9th February 2016, 11:57 PM
Thorsten Engler [NDA]
 
Posts: n/a
Default Re: Unable to build Entity model via build 242 on VS 2015

Could you create an issue for this in our tracker with the required tables
attached (can be empty if you can confirm that the issue still happens with
empty tables)?

I don't have any problems when building a model for the Northwind database, so
I assume it's something specific about your tables.

Christian Holm J?rgensen wrote:

> Hi.
>
> 1.
> Adding the ref's to Nexus assemblies fixed the problem.
> I think a line about this detail should be added to the help file.
>
> 2.
> However, now I received an error when trying to access the
> available tables to import in the Entity Wizard
> (NexusErrorEntityDataModelWizard.PNG).
>
> The strange thing is: If I cancel the dialog and retry multiple
> times I may get lucky to have the tables overview.
>
> Then, in such lucky case I try to build the entity model through
> the wizard and receive the exception stack trace (see below).
>
> -> Only once during my many retry attempts, I have been able to
> successfully complete the wizard and get the complete model
> of my database.
>
> I have ensured I have installed EF 6.1.3.
> I have saved all, rebuild, cleaned several times.
>
>
> Exception Stack Trace:
> ======================
> The model was generated with warnings or errors.Model1.edmxPlease see
> the Error List for more details. These issues must be fixed before
> running your application.
> Loading metadata from the database took 00:00:01.3991650.
> Generating the model took 00:00:02.3856912.
> Added the connection string to the App.Config file.
> Writing the .edmx file took 00:00:00.0041253.
> Unable to generate the model because of the following exception:
> 'System.Data.Entity.Core.EntityCommandExecutionExc eption: An error
> occurred while executing the command definition. See the inner
> exception for details. --->
> System.Runtime.InteropServices.SEHException: External component has
> thrown an exception.
> at NexusDB.ADOProvider.NxDLLDB32._SetParam(Int64 _aStatementID,
> String ParameterName, Byte ParameterType, Int32 aLength, Byte[] aData,
> Boolean IsNull)
> at NexusDB.ADOProvider.NxDLLDB32.SetParam(Int64 aStatementID, Byte[]
> ParameterName, Byte ParameterType, Int32 aLength, Byte[] aData, Boolean
> IsNull)
> at NexusDB.ADOProvider.NxCommand.ProcessParams(Int64 anxStatementID,
> String strCommandText, NxParameterCollection objParameters, CultureInfo
> objCulture, CommandBehavior behavior)
> at
> NexusDB.ADOProvider.NxCommand.InternalExecuteReade r(CommandBehavior
> behavior)
> at NexusDB.ADOProvider.NxCommand.ExecuteDbDataReader( CommandBehavior
> behavior)
> at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
> behavior)
> at
> System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.<Read
> er>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
> at
> System.Data.Entity.Infrastructure.Interception.Int ernalDispatcher`1.Disp
> atch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3
> operation, TInterceptionContext interceptionContext, Action`3
> executing, Action`3 executed)
> at
> System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.Reade
> r(DbCommand command, DbCommandInterceptionContext interceptionContext)
> at
> System.Data.Entity.Internal.InterceptableDbCommand .ExecuteDbDataReader(C
> ommandBehavior behavior)
> at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
> behavior)
> at
> System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
> ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
> behavior)
> --- End of inner exception stack trace ---
> at
> System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
> ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
> behavior)
> at
> System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
> ecute(EntityCommand entityCommand, CommandBehavior behavior)
> at
> System.Data.Entity.Core.EntityClient.EntityCommand .ExecuteReader(Command
> Behavior behavior)
> at
> Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
> scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadDataTable[T](
> String sql, Func`2 orderByFunc, DataTable table,
> EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1 filters,
> String[] filterAliases)
> at
> Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
> scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadViewDetails(I
> Enumerable`1 filters)
> at
> Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
> scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadStoreSchemaDe
> tails(IList`1 filters)
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
> tor.GetStoreSchemaDetails(StoreSchemaConnectionFac tory
> connectionFactory)
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
> tor.CreateStoreModel()
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
> tor.GenerateModel(List`1 errors)
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBuilde
> rEngine.GenerateModels(String storeModelNamespace, ModelBuilderSettings
> settings, List`1 errors)
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBuilde
> rEngine.GenerateModel(ModelBuilderSettings settings, IVsUtils vsUtils,
> ModelBuilderEngineHostContext hostContext)'.
> Loading metadata from the database took 00:00:01.3610970.
> Generating the model took 00:00:03.9692479.
> Unable to generate the model because of the following exception:
> 'System.Data.Entity.Core.EntityCommandExecutionExc eption: An error
> occurred while executing the command definition. See the inner
> exception for details. --->
> System.Runtime.InteropServices.SEHException: External component has
> thrown an exception.
> at NexusDB.ADOProvider.NxDLLDB32._SetParam(Int64 _aStatementID,
> String ParameterName, Byte ParameterType, Int32 aLength, Byte[] aData,
> Boolean IsNull)
> at NexusDB.ADOProvider.NxDLLDB32.SetParam(Int64 aStatementID, Byte[]
> ParameterName, Byte ParameterType, Int32 aLength, Byte[] aData, Boolean
> IsNull)
> at NexusDB.ADOProvider.NxCommand.ProcessParams(Int64 anxStatementID,
> String strCommandText, NxParameterCollection objParameters, CultureInfo
> objCulture, CommandBehavior behavior)
> at
> NexusDB.ADOProvider.NxCommand.InternalExecuteReade r(CommandBehavior
> behavior)
> at NexusDB.ADOProvider.NxCommand.ExecuteDbDataReader( CommandBehavior
> behavior)
> at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
> behavior)
> at
> System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.<Read
> er>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
> at
> System.Data.Entity.Infrastructure.Interception.Int ernalDispatcher`1.Disp
> atch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3
> operation, TInterceptionContext interceptionContext, Action`3
> executing, Action`3 executed)
> at
> System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.Reade
> r(DbCommand command, DbCommandInterceptionContext interceptionContext)
> at
> System.Data.Entity.Internal.InterceptableDbCommand .ExecuteDbDataReader(C
> ommandBehavior behavior)
> at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
> behavior)
> at
> System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
> ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
> behavior)
> --- End of inner exception stack trace ---
> at
> System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
> ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
> behavior)
> at
> System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinition.Ex
> ecute(EntityCommand entityCommand, CommandBehavior behavior)
> at
> System.Data.Entity.Core.EntityClient.EntityCommand .ExecuteReader(Command
> Behavior behavior)
> at
> Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
> scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadDataTable[T](
> String sql, Func`2 orderByFunc, DataTable table,
> EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1 filters,
> String[] filterAliases)
> at
> Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
> scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadTableDetails(
> IEnumerable`1 filters)
> at
> Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.SchemaDi
> scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadStoreSchemaDe
> tails(IList`1 filters)
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
> tor.GetStoreSchemaDetails(StoreSchemaConnectionFac tory
> connectionFactory)
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
> tor.CreateStoreModel()
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGenera
> tor.GenerateModel(List`1 errors)
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBuilde
> rEngine.GenerateModels(String storeModelNamespace, ModelBuilderSettings
> settings, List`1 errors)
> at
> Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBuilde
> rEngine.GenerateModel(ModelBuilderSettings settings, IVsUtils vsUtils,
> ModelBuilderEngineHostContext hostContext)'.
> Loading metadata from the database took 00:00:01.4033457.
> Generating the model took 00:00:14.4342030.
>
>
>
> Best regards Christian
>
> Thorsten Engler [NDA] wrote:
>
> > Please add references to NexusDB.ADOProvider and
> > NexusDB.ADOProvider.Linq to your project (both should be installed in
> > the GAC). Then, as the text in the wizard instructs, rebuild the
> > project before trying to run the wizard again.
> >
> > Also, make sure the version of EntityFramework that you are
> > referencing is 6.1.3
> >
> > Christian Holm J?rgensen wrote:
> >
> > > Hi.
> > > I have just purchased and installed
> > > NexusDB_V4_Visual_Studio_Pack_Standard_build242
> > > on Win 7, 64bit.
> > >
> > > I have Visual Studio 2015 Update 1.
> > >
> > > I am able to add my existing database from NexusDB v. 3.1203 (see
> > > 1_NexusDbAdoNetConnection.png)
> > > I am able to browse the tables and execute select queries.
> > >
> > > Then I want to build an EF model from the database.
> > >
> > > I follow the guide "NexusDB ADO.NET Provider,
> > > Entity Framework Support"
> > > provided by you. And get EF installed, removed sql reference and
> > > modified the App.Config (see 2_EF_Installed.png)
> > >
> > > I then try to import the database as a model, but receive this
> > > message (see 3_EF_Error.png)
> > >
> > > Any suggestions?
> > >
> > > Best regards Christian


  #5  
Old 10th February 2016, 12:35 AM
Christian Holm J?rgensen
 
Posts: n/a
Default Re: Unable to build Entity model via build 242 on VS 2015

Its now submitted as ID: 0002023

Thorsten Engler [NDA] wrote:

> Could you create an issue for this in our tracker with the required
> tables attached (can be empty if you can confirm that the issue still
> happens with empty tables)?
>
> I don't have any problems when building a model for the Northwind
> database, so I assume it's something specific about your tables.
>
> Christian Holm J?rgensen wrote:
>
> > Hi.
> >
> > 1.
> > Adding the ref's to Nexus assemblies fixed the problem.
> > I think a line about this detail should be added to the help file.
> >
> > 2.
> > However, now I received an error when trying to access the
> > available tables to import in the Entity Wizard
> > (NexusErrorEntityDataModelWizard.PNG).
> >
> > The strange thing is: If I cancel the dialog and retry multiple
> > times I may get lucky to have the tables overview.
> >
> > Then, in such lucky case I try to build the entity model through
> > the wizard and receive the exception stack trace (see below).
> >
> > -> Only once during my many retry attempts, I have been able to
> > successfully complete the wizard and get the complete model
> > of my database.
> >
> > I have ensured I have installed EF 6.1.3.
> > I have saved all, rebuild, cleaned several times.
> >
> >
> > Exception Stack Trace:
> > ======================
> > The model was generated with warnings or errors.Model1.edmxPlease
> > see the Error List for more details. These issues must be fixed
> > before running your application.
> > Loading metadata from the database took 00:00:01.3991650.
> > Generating the model took 00:00:02.3856912.
> > Added the connection string to the App.Config file.
> > Writing the .edmx file took 00:00:00.0041253.
> > Unable to generate the model because of the following exception:
> > 'System.Data.Entity.Core.EntityCommandExecutionExc eption: An error
> > occurred while executing the command definition. See the inner
> > exception for details. --->
> > System.Runtime.InteropServices.SEHException: External component has
> > thrown an exception.
> > at NexusDB.ADOProvider.NxDLLDB32._SetParam(Int64 _aStatementID,
> > String ParameterName, Byte ParameterType, Int32 aLength, Byte[]
> > aData, Boolean IsNull)
> > at NexusDB.ADOProvider.NxDLLDB32.SetParam(Int64 aStatementID,
> > Byte[] ParameterName, Byte ParameterType, Int32 aLength, Byte[]
> > aData, Boolean IsNull)
> > at NexusDB.ADOProvider.NxCommand.ProcessParams(Int64
> > anxStatementID, String strCommandText, NxParameterCollection
> > objParameters, CultureInfo objCulture, CommandBehavior behavior)
> > at
> > NexusDB.ADOProvider.NxCommand.InternalExecuteReade r(CommandBehavior
> > behavior)
> > at
> > NexusDB.ADOProvider.NxCommand.ExecuteDbDataReader( CommandBehavior
> > behavior) at
> > System.Data.Common.DbCommand.ExecuteReader(Command Behavior behavior)
> > at
> > System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.<
> > Read er>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
> > at
> > System.Data.Entity.Infrastructure.Interception.Int ernalDispatcher`1.
> > Disp atch[TTarget,TInterceptionContext,TResult](TTarget target,
> > Func`3 operation, TInterceptionContext interceptionContext, Action`3
> > executing, Action`3 executed)
> > at
> > System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.R
> > eade r(DbCommand command, DbCommandInterceptionContext
> > interceptionContext) at
> > System.Data.Entity.Internal.InterceptableDbCommand .ExecuteDbDataRead
> > er(C ommandBehavior behavior)
> > at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
> > behavior)
> > at
> > System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinitio
> > n.Ex ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
> > behavior)
> > --- End of inner exception stack trace ---
> > at
> > System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinitio
> > n.Ex ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
> > behavior)
> > at
> > System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinitio
> > n.Ex ecute(EntityCommand entityCommand, CommandBehavior behavior)
> > at
> > System.Data.Entity.Core.EntityClient.EntityCommand .ExecuteReader(Com
> > mand Behavior behavior)
> > at
> > Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.Sche
> > maDi
> > scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadDataTable
> > [T]( String sql, Func`2 orderByFunc, DataTable table,
> > EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1
> > filters, String[] filterAliases) at
> > Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.Sche
> > maDi
> > scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadViewDetai
> > ls(I Enumerable`1 filters) at
> > Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.Sche
> > maDi
> > scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadStoreSche
> > maDe tails(IList`1 filters) at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGe
> > nera tor.GetStoreSchemaDetails(StoreSchemaConnectionFac tory
> > connectionFactory)
> > at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGe
> > nera tor.CreateStoreModel()
> > at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGe
> > nera tor.GenerateModel(List`1 errors)
> > at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBu
> > ilde rEngine.GenerateModels(String storeModelNamespace,
> > ModelBuilderSettings settings, List`1 errors)
> > at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBu
> > ilde rEngine.GenerateModel(ModelBuilderSettings settings, IVsUtils
> > vsUtils, ModelBuilderEngineHostContext hostContext)'.
> > Loading metadata from the database took 00:00:01.3610970.
> > Generating the model took 00:00:03.9692479.
> > Unable to generate the model because of the following exception:
> > 'System.Data.Entity.Core.EntityCommandExecutionExc eption: An error
> > occurred while executing the command definition. See the inner
> > exception for details. --->
> > System.Runtime.InteropServices.SEHException: External component has
> > thrown an exception.
> > at NexusDB.ADOProvider.NxDLLDB32._SetParam(Int64 _aStatementID,
> > String ParameterName, Byte ParameterType, Int32 aLength, Byte[]
> > aData, Boolean IsNull)
> > at NexusDB.ADOProvider.NxDLLDB32.SetParam(Int64 aStatementID,
> > Byte[] ParameterName, Byte ParameterType, Int32 aLength, Byte[]
> > aData, Boolean IsNull)
> > at NexusDB.ADOProvider.NxCommand.ProcessParams(Int64
> > anxStatementID, String strCommandText, NxParameterCollection
> > objParameters, CultureInfo objCulture, CommandBehavior behavior)
> > at
> > NexusDB.ADOProvider.NxCommand.InternalExecuteReade r(CommandBehavior
> > behavior)
> > at
> > NexusDB.ADOProvider.NxCommand.ExecuteDbDataReader( CommandBehavior
> > behavior) at
> > System.Data.Common.DbCommand.ExecuteReader(Command Behavior behavior)
> > at
> > System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.<
> > Read er>b__c(DbCommand t, DbCommandInterceptionContext`1 c)
> > at
> > System.Data.Entity.Infrastructure.Interception.Int ernalDispatcher`1.
> > Disp atch[TTarget,TInterceptionContext,TResult](TTarget target,
> > Func`3 operation, TInterceptionContext interceptionContext, Action`3
> > executing, Action`3 executed)
> > at
> > System.Data.Entity.Infrastructure.Interception.DbC ommandDispatcher.R
> > eade r(DbCommand command, DbCommandInterceptionContext
> > interceptionContext) at
> > System.Data.Entity.Internal.InterceptableDbCommand .ExecuteDbDataRead
> > er(C ommandBehavior behavior)
> > at System.Data.Common.DbCommand.ExecuteReader(Command Behavior
> > behavior)
> > at
> > System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinitio
> > n.Ex ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
> > behavior)
> > --- End of inner exception stack trace ---
> > at
> > System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinitio
> > n.Ex ecuteStoreCommands(EntityCommand entityCommand, CommandBehavior
> > behavior)
> > at
> > System.Data.Entity.Core.EntityClient.Internal.Enti tyCommandDefinitio
> > n.Ex ecute(EntityCommand entityCommand, CommandBehavior behavior)
> > at
> > System.Data.Entity.Core.EntityClient.EntityCommand .ExecuteReader(Com
> > mand Behavior behavior)
> > at
> > Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.Sche
> > maDi
> > scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadDataTable
> > [T]( String sql, Func`2 orderByFunc, DataTable table,
> > EntityStoreSchemaFilterObjectTypes queryTypes, IEnumerable`1
> > filters, String[] filterAliases) at
> > Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.Sche
> > maDi
> > scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadTableDeta
> > ils( IEnumerable`1 filters) at
> > Microsoft.Data.Entity.Design.VersioningFacade.Reve rseEngineerDb.Sche
> > maDi
> > scovery.EntityStoreSchemaGeneratorDatabaseSchemaLo ader.LoadStoreSche
> > maDe tails(IList`1 filters) at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGe
> > nera tor.GetStoreSchemaDetails(StoreSchemaConnectionFac tory
> > connectionFactory)
> > at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGe
> > nera tor.CreateStoreModel()
> > at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelGe
> > nera tor.GenerateModel(List`1 errors)
> > at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBu
> > ilde rEngine.GenerateModels(String storeModelNamespace,
> > ModelBuilderSettings settings, List`1 errors)
> > at
> > Microsoft.Data.Entity.Design.VisualStudio.ModelWiz ard.Engine.ModelBu
> > ilde rEngine.GenerateModel(ModelBuilderSettings settings, IVsUtils
> > vsUtils, ModelBuilderEngineHostContext hostContext)'.
> > Loading metadata from the database took 00:00:01.4033457.
> > Generating the model took 00:00:14.4342030.
> >
> >
> >
> > Best regards Christian
> >
> > Thorsten Engler [NDA] wrote:
> >
> > > Please add references to NexusDB.ADOProvider and
> > > NexusDB.ADOProvider.Linq to your project (both should be
> > > installed in the GAC). Then, as the text in the wizard instructs,
> > > rebuild the project before trying to run the wizard again.
> > >
> > > Also, make sure the version of EntityFramework that you are
> > > referencing is 6.1.3
> > >
> > > Christian Holm J?rgensen wrote:
> > >
> > > > Hi.
> > > > I have just purchased and installed
> > > > NexusDB_V4_Visual_Studio_Pack_Standard_build242
> > > > on Win 7, 64bit.
> > > >
> > > > I have Visual Studio 2015 Update 1.
> > > >
> > > > I am able to add my existing database from NexusDB v. 3.1203
> > > > (see 1_NexusDbAdoNetConnection.png)
> > > > I am able to browse the tables and execute select queries.
> > > >
> > > > Then I want to build an EF model from the database.
> > > >
> > > > I follow the guide "NexusDB ADO.NET Provider,
> > > > Entity Framework Support"
> > > > provided by you. And get EF installed, removed sql reference and
> > > > modified the App.Config (see 2_EF_Installed.png)
> > > >
> > > > I then try to import the database as a model, but receive this
> > > > message (see 3_EF_Error.png)
> > > >
> > > > Any suggestions?
> > > >
> > > > Best regards Christian


  #6  
Old 10th February 2016, 06:13 AM
InsMark InsMark is offline
Junior Member
 
Join Date: Apr 2011
Posts: 25
Default

Hi, I still have the same problem, the number 3 you have. I added Nexus to the references and have EF 6.1.3 installed.



Quote:
Originally Posted by Christian Holm J?rgensen View Post
Hi.

1.
Adding the ref's to Nexus assemblies fixed the problem.
I think a line about this detail should be added to the help file.

2.
However, now I received an error when trying to access the
available tables to import in the Entity Wizard
(NexusErrorEntityDataModelWizard.PNG).

The strange thing is: If I cancel the dialog and retry multiple
times I may get lucky to have the tables overview.

Then, in such lucky case I try to build the entity model through
the wizard and receive the exception stack trace (see below).

-> Only once during my many retry attempts, I have been able to
successfully complete the wizard and get the complete model
of my database.

I have ensured I have installed EF 6.1.3.
I have saved all, rebuild, cleaned several times.


> > Best regards Christian[/color][/color]
Attached Images
File Type: jpg EF_Error.jpg (12.8 KB, 1 views)
  #7  
Old 10th February 2016, 06:33 AM
InsMark InsMark is offline
Junior Member
 
Join Date: Apr 2011
Posts: 25
Default

Hi, Christian,

I have the same problem, can you give me the link or reference to the guide "NexusDB ADO.NET Provider, Entity Framework Support" that you posted here.

Thanks.

Quote:
Originally Posted by Christian Holm J?rgensen View Post
Hi.
I have just purchased and installed
NexusDB_V4_Visual_Studio_Pack_Standard_build242
on Win 7, 64bit.

I have Visual Studio 2015 Update 1.

I am able to add my existing database from NexusDB v. 3.1203 (see
1_NexusDbAdoNetConnection.png)
I am able to browse the tables and execute select queries.

Then I want to build an EF model from the database.

I follow the guide "NexusDB ADO.NET Provider,
Entity Framework Support"
provided by you. And get EF installed, removed sql reference and
modified the App.Config (see 2_EF_Installed.png)

I then try to import the database as a model, but receive this
message (see 3_EF_Error.png)

Any suggestions?

Best regards Christian
  #8  
Old 10th February 2016, 06:56 AM
InsMark InsMark is offline
Junior Member
 
Join Date: Apr 2011
Posts: 25
Default

Hi, Christian,

I found the guide and fix the problem, thanks.

Quote:
Originally Posted by InsMark View Post
Hi, Christian,

I have the same problem, can you give me the link or reference to the guide "NexusDB ADO.NET Provider, Entity Framework Support" that you posted here.

Thanks.


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
What is the proper way of Generating a Entity Data Model fromDatabase? John Myren nexusdb.public.support.adoprovider 9 23rd June 2015 02:00 AM
New ADO Build 84??? Thomas Scherer nexusdb.public.support.adoprovider 5 18th November 2009 08:33 PM
Build 84 David Guest nexusdb.public.support.adoprovider 3 30th October 2009 10:28 PM
Build 62 Bug? Chris F nexusdb.public.support.adoprovider 8 21st October 2008 04:26 PM
Build 60 Paul Toms nexusdb.public.support.odbc 1 9th June 2008 02:21 PM


All times are GMT +11. The time now is 11:42 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.