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.
Search found 25 matches
- Fri 23 Sep 2011 11:06
- Forum: dotConnect for Oracle
- Topic: Custom tool 'DevartEfGenerator' failed
- Replies: 6
- Views: 2635
- Thu 22 Sep 2011 06:09
- Forum: dotConnect for Oracle
- Topic: Custom tool 'DevartEfGenerator' failed
- Replies: 6
- Views: 2635
- Wed 21 Sep 2011 12:36
- Forum: dotConnect for Oracle
- Topic: Custom tool 'DevartEfGenerator' failed
- Replies: 6
- Views: 2635
- Wed 29 Sep 2010 10:22
- Forum: dotConnect for Oracle
- Topic: Please have full version in installer name
- Replies: 1
- Views: 1113
Please have full version in installer name
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
Either that or the build date built into the download name and installer title.
Thank you
- Tue 06 Jul 2010 09:44
- Forum: dotConnect for Oracle
- Topic: update model (EF4) from database
- Replies: 7
- Views: 2476
- Thu 24 Jun 2010 10:28
- Forum: dotConnect for Oracle
- Topic: dotConnect for Oracle v5.70 bug report
- Replies: 5
- Views: 1374
- Wed 12 May 2010 06:24
- Forum: Entity Framework support
- Topic: Many to Many and slow queries
- Replies: 10
- Views: 2374
- Mon 10 May 2010 14:18
- Forum: Entity Framework support
- Topic: Many to Many and slow queries
- Replies: 10
- Views: 2374
- Mon 10 May 2010 14:15
- Forum: Entity Framework support
- Topic: Problem generating model from Oracle server
- Replies: 3
- Views: 1624
- Thu 06 May 2010 12:10
- Forum: Entity Framework support
- Topic: Model First in Oracle
- Replies: 3
- Views: 1962
- Thu 06 May 2010 09:30
- Forum: Entity Framework support
- Topic: Problem generating model from Oracle server
- Replies: 3
- Views: 1624
Problem generating model from Oracle server
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:
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
- Mon 03 May 2010 13:05
- Forum: Entity Framework support
- Topic: Model First in Oracle
- Replies: 3
- Views: 1962
Model First in Oracle
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?
- Tue 13 Apr 2010 12:30
- Forum: Entity Framework support
- Topic: .NET 4 GA Support
- Replies: 5
- Views: 1898
- Tue 06 Apr 2010 05:44
- Forum: Entity Framework support
- Topic: Design and code...
- Replies: 8
- Views: 1884
- Thu 18 Mar 2010 10:11
- Forum: Entity Framework support
- Topic: Entity Framework 4.0 RC - Problem in many-to-many
- Replies: 3
- Views: 6864
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:
Note how it's trying to get the values it's supposed to insert back as if they where generated IDs.
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.