Devart Forums

My model is 63 entities-large. I'm afraid I cannot send it to you (live project).
The problem started after I had added table-per-hierarchy hierarchy but I'm not convinced it's the source.

Ouch, I uninstalled 6.50 and retrograded to 6.30.

I'm having the same issue. I've been fighting to figure why the .Designer.cs is not getting generated.

Edit: Actually it's real bad. When I update the model from DB, when I save VS2010 gets stuck saving (I'm guessing during the generation process). I'm forced to kill VS2010.

I have several "doracle570pro.exe". It would be nice to have the full version number in the name in order to distinguish them better from one version to another.

Either that or the build date built into the download name and installer title.

Thank you

I'm also eager to see an update function. Having to delete and re-add tables to update them is tiresome and risky (don't forget to set those storage patterns every time!).

Wouldn't it make more sense to quote all columns or would this have a performance impact?

How about making a SQL view? You can then map that to an new entity object.

Is it therefore recommend to use Linq to Oracle instead of Entity Framework with dotConnect?

It would be nice to see recommendations and guidelines.

Yes it is. I've tried both modes.

Thanks. Generating one sequence and one trigger per Int32/64 Identity field would be nice.

I have generated more then on model using dotConnect for Oracle.
The problem is that it has worked well with my Oracle 10g Express local DB but either on my 9.2.0.6 or 11g servers, I get the following error:

Network error:: An existing connection was forcibly closed by the remote host

Is there any chance that in model first scenarios when I specify Int-based entity-keys that are set to Identity that dotConnect for Oracle generates the necessary triggers in order to get auto-increment working automatically?

That would be nice indeed.

Yes you can do "model first" development by creating your model first and then generating a schema from that model.

Ok so now I know exactly what's wrong: many-to-many associations use the StoreGeneratedPattern of the source tables.

So a table with UserID and RoleID will generate an INSERT statement with no VALUES at all!

This is Ok behaviour for a table's ID field but not for foreign keys. If the many-to-many associative table has other fields, Entity Framework will generate a entity for that table and in that case it works out fine as the ID fields are considered foreign field.

My suspicion is that dotConnect should ignore StoreGeneratedPattern on *-* associations foreign key fields.

Bellow the output SQL from DB Monitor:

declare
updatedRowid ROWID;
begin
insert into AM.USER_ROLES()
values ()
returning ROWID into updatedRowid;
open :outParameter for select ID_USER, ID_ROLE from AM.USER_ROLES where ROWID = updatedRowid;
end;

Note how it's trying to get the values it's supposed to insert back as if they where generated IDs.