Devart Forums

I'm having trouble using the "Retrieve Data" action in the context menu of any Entity on the designer surface. After installing Entity Developer I configure a database connection successfully then drag and drop a table on the designer and it generates a new entity. However when I right-click on the new Entity I get a context-menu,"Retrieve Data", and I'm prompted to point to my NHibernate assemblies. It's at this point where my frustration begins because no matter which combination of NHibernate or FluentNhibernate I use, I always end up with an error (see error #1). I've spent a full day playing with the configuration and can't get this working. I've pulled down each version, extracted it and pointed Entity Developer to these directories with no luck. I've even tried extracting them in the same directory as Entity Developer and when I do I get the same error (see error #1).

Our development wants to target using:
1. NHibernate 3.1.0.GA
2. Fluent NHibernate 1.2 for NHibernate 3.1

PLEASE REPLY WITH
1. The exact version of FluentNHibernate and/or NHibernate to download so I can use the "Retrieve Data" feature of Entity Developer.
2. Explain all the steps involved so when complete I can right-click on any entity and retrieve some sample data.
3. Can I get one query example using linq within Entity Framework to query the Cats sample entity?

ERROR #1
The result of model generation or query syntax is not valid.
Failed to compile and load the working library with the model.
Error List:
error1 : The type or namespace name 'FluentNHibernate' could not be found (are you missing a using directive or an assembly reference?)
error2 : The type or namespace name 'FluentNHibernate' could not be found (are you missing a using directive or an assembly reference?)
error3 : The type or namespace name 'ClassMap' could not be found (are you missing a using directive or an assembly reference?)

I've tried the following versions of NHibernate:
http://sourceforge.net/projects/nhibern ... Hibernate/
All versions => {2.0.1.GA, 2.1.0.GA, 2.1.2GA, 3.0.0.GA, 3.1.0.GA, 3.2.0GA}

I've tried both versions of Fluent NHibernate:
http://fluentnhibernate.org/downloads
1. Fluent NHibernate 1.2 for NHibernate 3.1
2. Download for NHibernate 2.1.2

SAMPLE ENTITY
public class Cats
{
public string FirstName {get;set;}
public string LastName {get;set;}
public int NumberOfSiblings {get;set;}
}

FEATURE REQUEST
1. Include this Nhibernate package with the next release of the Entity Developer installation package and/or preconfigure Entity Developer so users don't have to perform this configuration step.
2. If this is too cumbersome, at least improve the message the end user is prompted with to point to the NHibernate directory path to include a link on your site to download this dependency and any others for this version of Entity Developer.

NHIBERNATE DIRECTORY PATH
"C:\Program Files (x86)\Devart\EntityDeveloper\Entity_Dev_Requirements"
Folder PATH listing
Volume serial number is F857-9D86
C:.
Antlr3.Runtime.dll
Castle.Core.dll
Castle.Core.xml
FluentNHibernate.dll
FluentNHibernate.pdb
FluentNHibernate.XML
Iesi.Collections.dll
Iesi.Collections.pdb
Iesi.Collections.xml
LinFu.DynamicProxy.dll
LinFu.License.txt
NHibernate.ByteCode.Castle.dll
NHibernate.ByteCode.Castle.pdb
NHibernate.ByteCode.Castle.xml
NHibernate.ByteCode.LinFu.dll
NHibernate.ByteCode.LinFu.pdb
NHibernate.ByteCode.LinFu.xml
NHibernate.dll
NHibernate.pdb
NHibernate.xml
nhibernate_files.txt
Oracle.DataAccess.dll
Remotion.Data.Linq.dll

No subfolders exist

MY ENVIRONMENT
VS 2010 Ultimate SPK 1
WIN 7 64-BIT
ENTITY DEVELOPER (Professional Edition) 4.2.138
Oracle 11g Server
Oracle 11g Client Version -> ODAC 11.2.0.3.0 with Oracle Developer Tools for Visual Studio (see link below)
http://www.oracle.com/technetwork/datab ... 01290.html

Thank you.

The Retrieve Data option is working only for the NHibernate template. We will investigate the possibility to support this feature for the Fluent NHibernate template and post here about the results. Thank you for your suggetion.

The way how it works for the NHibernate template:
1. Put Oracle.DataAccess.dll to the Program Files (x86)\Devart\EntityDeveloper\ folder.
2. Specify the NHibernate-3.1.0.GA-bin\Required_Bins\ folder (with Iesi.Collections.dll and NHibernate.dll). This will be enough if [right click on the designer surface > Model Settings > Configuration > Proxy Factory] is set to None. Otherwise, you need to copy the corresponding assemblies to this folder (error message will tell you which exactly assemblies are needed).

wdcoleman wrote:3. Can I get one query example using linq within Entity Framework to query the Cats sample entity?

There are simple LINQ to Entities examples at http://www.devart.com/dotconnect/oracle ... al_EF.html.

The Retrieve Data feature for the NHibernate Fluent template is implemented. We will post here when the corresponding build of Entity Developer is available for download.

New version of Entity Developer 4.6 is released!
It can be downloaded from http://www.devart.com/entitydeveloper/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=32&t=24852.

To make the Retrieve Data feature for the Fluent NHibernate template work, please set the path to the corresponding NHibernate assemblies (they all should be in the same folder) via the Tools > Options > Environment > NHibernate > NHibernate assemblies folder menu of Entity Developer.

I'm using ED 5.7.299 with VS 2013 Express, which puts the NHibernate, FluentNH and IESI.Collections assemblies in different directories.

This is a problem for ED retrieving entity data, which wants them all in a single dir. This is set in Tools->Options->Environment->NHibernate.

A workaround is to manually copy all .dlls to one common dir, but this means extra manual management for each project, and it could lead to versioning problems if this 'parallel' location is not kept in synch with the VS references.

Would it be possible to make the NHibernate option use multiple dirs, so they could be the same ones as the VS references? Perhaps the UI could be a listbox with add/edit/delete controls.

jabble wrote:Would it be possible to make the NHibernate option use multiple dirs, so they could be the same ones as the VS references? Perhaps the UI could be a listbox with add/edit/delete controls.

You are using a standalone Entity Developer, aren't you?
Please submit your suggestion about multiple paths in the "NHibernate assemblies folder" textbox at http://devart.uservoice.com/forums/3867 ... -developer.

The bug with looking for NHibernate assemblies basing on the project references is fixed in the Entity Developer version integrated into Visual Studio. We will notify you when the corresponding build of Entity Developer is available for download.

New build of Entity Developer 5.7.321 is available for download!
It can be downloaded from http://www.devart.com/entitydeveloper/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=32&t=29235.