Search found 70 matches

by PeterUser
Tue 04 Oct 2022 06:10
Forum: dotConnect for Oracle
Topic: Does devart still exist
Replies: 2
Views: 12255

Re: Does devart still exist

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
by PeterUser
Thu 22 Sep 2022 09:40
Forum: dotConnect for Oracle
Topic: Set InitialLobFetchSize for EF 6 db context
Replies: 17
Views: 330642

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
by PeterUser
Mon 19 Sep 2022 05:49
Forum: dotConnect for Oracle
Topic: Issue with TruncateLongDefaultNames on Oracle 19
Replies: 7
Views: 21231

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
by PeterUser
Fri 16 Sep 2022 11:37
Forum: dotConnect for Oracle
Topic: Issue with TruncateLongDefaultNames on Oracle 19
Replies: 7
Views: 21231

Re: Issue with TruncateLongDefaultNames on Oracle 19

Hello,

is there any update or information on this issue?

Kind regards
Peter
by PeterUser
Thu 25 Aug 2022 08:01
Forum: dotConnect for Oracle
Topic: Set InitialLobFetchSize for EF 6 db context
Replies: 17
Views: 330642

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
by PeterUser
Tue 26 Jul 2022 16:13
Forum: dotConnect for Oracle
Topic: Does devart still exist
Replies: 2
Views: 12255

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
by PeterUser
Tue 12 Jul 2022 13:47
Forum: dotConnect for Oracle
Topic: Set InitialLobFetchSize for EF 6 db context
Replies: 17
Views: 330642

Re: Set InitialLobFetchSize for EF 6 db context

Hello devart,

is there any news on this item?

Kind regards
Peter
by PeterUser
Thu 23 Jun 2022 08:53
Forum: dotConnect for Oracle
Topic: Issue with TruncateLongDefaultNames on Oracle 19
Replies: 7
Views: 21231

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

Code: Select all

Update-Database ... -Script
on the Oracle 12 database, I get

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
/
with the Oracle 19 database, I get

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
/
This discrepancy is an issue since my databases would diverge. According to the documentation, I would expect to see the truncated version:
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.
Is there a way to use truncated names with Oracle 19?

Kind regards
Peter
by PeterUser
Thu 23 Jun 2022 08:31
Forum: dotConnect for Oracle
Topic: Set InitialLobFetchSize for EF 6 db context
Replies: 17
Views: 330642

Re: Set InitialLobFetchSize for EF 6 db context

Hello,

is there any update on this feature?

Kind regards
Peter
by PeterUser
Mon 09 May 2022 09:00
Forum: dotConnect for Oracle
Topic: Set InitialLobFetchSize for EF 6 db context
Replies: 17
Views: 330642

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