Hi DevartTeam,
thanks for your reply. No, at the moment this are the only issues I'm having. This post was more about the general state of this forum and the EF Code first approach. I'm using dotconnect for quite some years now and I must admit, I really like it.
When I had some minor issues some years back, I found help in this forum, which was quite busy back then. I'm not sure if this is still the way to go. Some recommend using direct support tickets, but I kind of like the forum since the discussion and the solution are discussed in the open. But if this is done another way by now, I'm happy to adapt.
Kind regards
Peter
Search found 70 matches
- Tue 04 Oct 2022 06:10
- Forum: dotConnect for Oracle
- Topic: Does devart still exist
- Replies: 2
- Views: 12281
- Thu 22 Sep 2022 09:40
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 330695
Re: Set InitialLobFetchSize for EF 6 db context
Hi,
is there any schedule for a new production release (to nuget.org) containing this feature?
Kind regards
Peter
is there any schedule for a new production release (to nuget.org) containing this feature?
Kind regards
Peter
- Mon 19 Sep 2022 05:49
- Forum: dotConnect for Oracle
- Topic: Issue with TruncateLongDefaultNames on Oracle 19
- Replies: 7
- Views: 21278
Re: Issue with TruncateLongDefaultNames on Oracle 19
Yes. Seems pretty dead around here. I'm not sure, if they are really maintaining this code first any more.
Thanks for the advice
Peter
Thanks for the advice
Peter
- Fri 16 Sep 2022 11:37
- Forum: dotConnect for Oracle
- Topic: Issue with TruncateLongDefaultNames on Oracle 19
- Replies: 7
- Views: 21278
Re: Issue with TruncateLongDefaultNames on Oracle 19
Hello,
is there any update or information on this issue?
Kind regards
Peter
is there any update or information on this issue?
Kind regards
Peter
- Thu 25 Aug 2022 08:01
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 330695
Re: Set InitialLobFetchSize for EF 6 db context
Hello Dimitry,
sorry for my late reply after pinging here so often, but I was on holiday and sick leave.
Thanks for the package though. I set the config.QueryOptions.InitialLobFetchSize and this reduces fetching 1000 rows with a CLOB column from ~40 seconds to 0.3 seconds in my specific scenario.
Thanks for implementing that.
I have a suggestion for improvement: It would be great to have XML-comments on all OracleEntityProviderConfig properties. Just bring the texts from the online docu there. That would save some googeling.
Kind regards
Peter
sorry for my late reply after pinging here so often, but I was on holiday and sick leave.
Thanks for the package though. I set the config.QueryOptions.InitialLobFetchSize and this reduces fetching 1000 rows with a CLOB column from ~40 seconds to 0.3 seconds in my specific scenario.
Thanks for implementing that.
I have a suggestion for improvement: It would be great to have XML-comments on all OracleEntityProviderConfig properties. Just bring the texts from the online docu there. That would save some googeling.
Kind regards
Peter
- Tue 26 Jul 2022 16:13
- Forum: dotConnect for Oracle
- Topic: Does devart still exist
- Replies: 2
- Views: 12281
Does devart still exist
Hello devart,
is there still anybody here? It seems that posts do not really get answered lately. Is it finally time to switch to another Oracle driver?
Looking forward to any reply
Peter
is there still anybody here? It seems that posts do not really get answered lately. Is it finally time to switch to another Oracle driver?
Looking forward to any reply
Peter
- Tue 26 Jul 2022 16:10
- Forum: dotConnect for Oracle
- Topic: Issue with TruncateLongDefaultNames on Oracle 19
- Replies: 7
- Views: 21278
- Tue 26 Jul 2022 16:10
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 330695
- Mon 18 Jul 2022 09:04
- Forum: dotConnect for Oracle
- Topic: Issue with TruncateLongDefaultNames on Oracle 19
- Replies: 7
- Views: 21278
- Mon 18 Jul 2022 09:04
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 330695
- Tue 12 Jul 2022 13:48
- Forum: dotConnect for Oracle
- Topic: Issue with TruncateLongDefaultNames on Oracle 19
- Replies: 7
- Views: 21278
- Tue 12 Jul 2022 13:47
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 330695
Re: Set InitialLobFetchSize for EF 6 db context
Hello devart,
is there any news on this item?
Kind regards
Peter
is there any news on this item?
Kind regards
Peter
- Thu 23 Jun 2022 08:53
- Forum: dotConnect for Oracle
- Topic: Issue with TruncateLongDefaultNames on Oracle 19
- Replies: 7
- Views: 21278
Issue with TruncateLongDefaultNames on Oracle 19
Hello,
I have an issue with the TruncateLongDefaultNames after an upgrade to Oracle 19.
One of our customers is currently upgrading from Oracle 12 to 19. At the moment one of the test systems is updated, while other test systems and the production system are not.
We work with the TruncateLongDefaultNames = true option to avoid long identifiers.
When I run on the Oracle 12 database, I get
with the Oracle 19 database, I get
This discrepancy is an issue since my databases would diverge. According to the documentation, I would expect to see the truncated version:
Kind regards
Peter
I have an issue with the TruncateLongDefaultNames after an upgrade to Oracle 19.
One of our customers is currently upgrading from Oracle 12 to 19. At the moment one of the test systems is updated, while other test systems and the production system are not.
We work with the TruncateLongDefaultNames = true option to avoid long identifiers.
When I run
Code: Select all
Update-Database ... -Script
Code: Select all
-- Script was generated by Devart dotConnect for Oracle, Version 9.16.1434
-- Product home page: http://www.devart.com/dotconnect/oracle
-- Database version: Oracle 12.1.0.2
-- Script date 23/06/2022 10:43:26
DROP INDEX PLATINEN_ADMIN.IX_N1493827076
/
Code: Select all
-- Script was generated by Devart dotConnect for Oracle, Version 9.16.1434
-- Product home page: http://www.devart.com/dotconnect/oracle
-- Database version: Oracle 19.0.0.0
-- Script date 23/06/2022 10:42:37
DROP INDEX PLATINEN_ADMIN.IX_PCB_TYPES_CREATED_IN_LOCATION_ID
/
Is there a way to use truncated names with Oracle 19?TruncateLongDefaultNames - When set to true, long default names of triggers, sequences, indexes, primary keys, and foreign keys, generated by Code-First Migrations, will be truncated to 30 symbols. When set to false, an exception will be raised for long default names. Be careful when setting the property to true, because checks for uniqueness of names are not performed. Default value is true.
Kind regards
Peter
- Thu 23 Jun 2022 08:31
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 330695
Re: Set InitialLobFetchSize for EF 6 db context
Hello,
is there any update on this feature?
Kind regards
Peter
is there any update on this feature?
Kind regards
Peter
- Mon 09 May 2022 09:00
- Forum: dotConnect for Oracle
- Topic: Set InitialLobFetchSize for EF 6 db context
- Replies: 17
- Views: 330695
Re: Set InitialLobFetchSize for EF 6 db context
Hello Alex,
that is great news indeed! Thanks a lot for working on that.
I use the Nuget package from Nuget.org, but I also have a local Nuget server here, if that helps for testing.
Looking forward to any news.
Kind regards and thanks again
Peter
that is great news indeed! Thanks a lot for working on that.
I use the Nuget package from Nuget.org, but I also have a local Nuget server here, if that helps for testing.
Looking forward to any news.
Kind regards and thanks again
Peter