Devart Forums

What is the different between Standalone Entity Developer and the one that is package with dotConnect for Postgres? I created a edml file using the Entity Developer packaged with dotConnect for Postgres with in Visual Studio. My company has a licenses for it. Then my company decided to move from Postgres to SQL Server 2012. I uninstalled dotConnect for Postgres since we moved to SQL Server 2012. I installed the dotConnect for SQL Server which did not have the Entity Developer packaged with it. So I downloaded 30-day Standalone Entity Developer to generate my edml with in Visual Studio 2010. No the Standalone Entity Developer has expired. Then I decide to use the Entity Developer that was packaged in our licensed dotConnect for Postgres. But I get an SSDL error about the provider.

Is what I am trying to do allowed?

Can I convert my dotConnect for Postgres license to a Standalone Entity Developer's license?

Thanks,

Charlie J.

Thanks I am aware of Recommendation 1-3. I have that handled in my code. I created a ObjectContext on a different thread and enable BatchUpdate on the ObjectContext. This gives me better performance if the BatchUpdate would work with using Parallel.Foreach.

Thanks,

Charlie J.

Got it. Thanks. I tested it and it works just fine. Thanks for the internal build. When will this fix be in a general release?

Thanks,

Charlie J.

The email address is spelled incorrectly. It is [email protected]

Thanks,

Charlie J.

How big is the file, because there might by a size limit to that email. Can you send it to [email protected]?

Thanks,

Charlie J.

Sorry But we have not received they email that contains the download for the internal build. Can you please resend it?

Thanks,

Charlie J.

Ok Thanks

PgSqlEntityProviderConfig config = PgSqlEntityProviderConfig.Instance;
config.DmlOptions.BatchUpdates.Enabled = true;

config.DmlOptions.ReuseParameters = true;
config.DmlOptions.BatchUpdates.BatchSize = 50;
config.DmlOptions.BatchUpdates.AsynchronousBatch = true;
config.DmlOptions.InsertNullBehaviour = InsertNullBehaviour.InsertDefaultOrOmit

Just having Batching enabled and the rest of the lines commented out it breaks. If I set MaxDegreeofPallellism to 1 in my ForEach.Parallel, it works with all the batching code uncommented. It is only when I set MaxDegressof Pallellism to greater than 1 it complaining at runtime about non-existing missing relationships between tables that dont have a relationship.

Thanks,

Charlie J.

Thanks

I am having a hard time get a sample together to we recreate this issue. You never answer my questions about it that could have me debug it some more on my side.

1.) Why would it be checking an non-existing relationship on a valid EDM?

2.) Why does it work correctly when I disable Batch Update?

3.) Why does it work when I have Batch Update enable, but use a single core/thread?


4.) Is there any special logging I can turn on to give you more information to debug into it?



Thanks,

Charlie J.

That is great. Is there a way for me to get an internal build or patch for this issue? I know about the workaround that you mention, but that is alot of manually work for me.


Thanks,

Charlie J.

I dont think I can create a sample that would reproduce the problem, but I will try. I am able to reproduce it within my application very easily.

Thanks,

Charlie J.

I have been getting a runtime UpdateExeception using dotConnect for PostgreSQL 5.70.293. When I am doing alot of inserts into my tables with Batch Update enabled and using multi-core/threads (TPL or Parallel.Foreach). I get a relationship not found error message between two tables that dont have a relationship defined in the EDM. It is a valid model, and the relationship doesnt exist, so the message is correct.

1.) Why would it be checking an non-existing relationship on a valid EDM?

2.) Why does it work correctly when I disable Batch Update?

3.) Why does it work when I have Batch Update enable, but use a single core/thread?

I have been having this issue for a couple of releases.

Is there any special logging I can turn on to give you more information to debug into it? I dont know is I can create a sample to reproduce it, but I can easily create it in my application.

Thanks,

Charlie J.

Using a simple PK-FK relationship to generate a model using Entity Developer 4.2.120, I get the following error messages.

1 The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property 'source_setup_id' on entity 'FkbugModel.Store.setup_item_code' does not match the type of property 'id_item_coding' on entity 'FkbugModel.Store.setup_item' in the referential constraint 'fk_child_to_parent'. PriceBook.edml


2 The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property 'item_state_name' on entity 'FkbugModel.Store.setup_item_code' does not match the type of property 'pack_size' on entity 'FkbugModel.Store.setup_item' in the referential constraint 'fk_child_to_parent'. PriceBook.edml

3 The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property 'SourceSetupId' on entity 'FkbugModel.SetupItemCode' does not match the type of property 'IdItemCoding' on entity 'FkbugModel.SetupItem' in the referential constraint 'SetupItem_SetupItemCode'. PriceBook.edml

4 The types of all properties in the Dependent Role of a referential constraint must be the same as the corresponding property types in the Principal Role. The type of property 'ItemStateName' on entity 'FkbugModel.SetupItemCode' does not match the type of property 'PackSize' on entity 'FkbugModel.SetupItem' in the referential constraint 'SetupItem_SetupItemCode'. PriceBook.edml

Script used to generate the database.

CREATE TABLE setup_item (
setup_id integer NOT NULL,
source_setup_id integer NOT NULL,
id_item_coding character varying(30) NOT NULL,
pack_size integer NOT NULL,
item_state_name character varying(50) NOT NULL
);


ALTER TABLE public.setup_item OWNER TO postgres;



CREATE TABLE setup_item_code (
setup_id integer NOT NULL,
source_setup_id integer NOT NULL,
id_item_coding character varying(30) NOT NULL,
pack_size integer NOT NULL,
item_state_name character varying(50) NOT NULL
);


ALTER TABLE public.setup_item_code OWNER TO postgres;

ALTER TABLE ONLY setup_item
ADD CONSTRAINT pk_setup_item PRIMARY KEY (setup_id, source_setup_id, id_item_coding, pack_size, item_state_name);

ALTER TABLE ONLY setup_item_code
ADD CONSTRAINT pk_setup_item_code PRIMARY KEY (setup_id, source_setup_id, id_item_coding, pack_size, item_state_name);

ALTER TABLE ONLY setup_item_code
ADD CONSTRAINT fk_child_to_parent FOREIGN KEY (setup_id, source_setup_id, id_item_coding, pack_size, item_state_name) REFERENCES setup_item(setup_id, source_setup_id, id_item_coding, pack_size, item_state_name);

Thanks,

Charlie J.

Can Batch Updates be using in a multi-threaded application?

Thanks,

Charlie J.