"Race condition" while trying to "map" Postgres db in VS2010

kodo65 · Post by **kodo65** » Wed 20 Oct 2010 14:56

Hi!

We're currently evaluating dotConnect for PostgreSQL as a possible data-provider in a fortcoming project. We downloaded the 4.95 version and installed. However we immediately ran into a complete stop when we tried to create an "entity framework class". We successfully completed the data-provider steps up to the point when we should select which tables to map. After clicking "Finish" we ended up in a "race condition" where the cores of the CPU were utilized 100%. The only way to stop this condition was to force VS2010 to shutdown.

We also tried another scenario where we only selected one table in the database - a table with NO relations whatsoever. We ended up with the same result. The database we use for testing is small: only 30+ tables. FYI - we tried to "map" the "postgis" db which is installed as part of the GIS stuff and that worked without a glitch.

The enviroment we're running this under is:

Intel Core Duo 2.33GHz
4 Gb RAM
WinXP 32-bit SP3
VS2010 Professional
PostgreSQL v8.4

Any ides what could be wrong?

Thanks in advance!
/Peter

AndreyR · Post by **AndreyR** » Thu 21 Oct 2010 12:57

Could you please try the 5.0 Beta version of dotConnect for PostgreSQL?
We have made a number of fixes associated with model generation performance in it.
I have made a couple of tests (using both Devart Entity model and Microsoft Entity model) and succeeded in adding tables with geometry columns.
Please notify us if the problem persists at your side.

kodo65 · Post by **kodo65** » Fri 22 Oct 2010 16:19

AndreyR wrote:Could you please try the 5.0 Beta version of dotConnect for PostgreSQL?
We have made a number of fixes associated with model generation performance in it.
I have made a couple of tests (using both Devart Entity model and Microsoft Entity model) and succeeded in adding tables with geometry columns.
Please notify us if the problem persists at your side.

Hi!

We tried v5 beta but the problem persists! What information can we provide to help you investigate this further?

Kind regards
/Peter

AndreyR · Post by **AndreyR** » Fri 22 Oct 2010 16:49

Could you please specify the build number of PostgreSQL 8.4 (for example, we have 8.4.4 and 8.4.1 test servers)?
Could you please send us (support * devart * com, subject "EF: PostGIS VS hang") the script of the database you are trying to create a model from as well?

kodo65 · Post by **kodo65** » Fri 22 Oct 2010 19:15

Hi!

Some progress!

If we used the "Devart Entity Model" we managed to "map" the underlying datamodel in VS2010! However - when we tried to expose the entity model using .Net 4 WCF Data Services we get a

Inconsistent accessibility: base class
'System.Data.Services.DataService'
is less accessible than class 'Our DataService...

At least some progress! What could be wrong with our DataService declaration?

Cheers
/Peter

kodo65 · Post by **kodo65** » Fri 22 Oct 2010 20:47

Hi again!

We changed the declaration of our "entity class" from partial to public, and then we managed to compile our WCF Data Service project! However, we immediately ran into another problem:

Trying to publish *any* of the tables/classes in the underlying datamodel failed...

config.SetEntitySetAccessRule("", EntitySetRights.All);

Where EntityName = {* | entityname}

Iow - publishing *any* of the tables failed. Furthermore adding a service operation also failed.

Cheers,
/Peter

kodo65 · Post by **kodo65** » Fri 22 Oct 2010 20:50

Postgres server is 8.4.3.1 running under Windows XP 32-bit SP3

AndreyR · Post by **AndreyR** » Thu 28 Oct 2010 11:40

I have sent a sample project to the e-mail address available in your profile.

Devart Forums

"Race condition" while trying to "map" Postgres db in VS2010

"Race condition" while trying to "map" Postgres db in VS2010

"Race condition" - tried v5.0 beta

Devart Entity Model tested

Partial -> public made the project compile but...

PostgreSQL version