Page 1 of 1

Showstopper: database-related methods of OracleEntityProviderServices ignore all but first entity containers

Posted: Sat 29 Mar 2014 14:06
by Dennis Wanke
Database-related methods of OracleEntityProviderServices (i.e. DeleteDatabase, CreateDatabase and CreateDatabaseScript) ignore all but first entity containers in the given StoreItemCollection.

Both SQL Server and SQL Server Compact data providers consider all the containers in the collection - and this is the correct behavior, which is extremely important for our product.

This seems to be the extension method extracting "all" entity sets from the given ItemCollection (somewhere in the obfuscated code of Devart.Common.Entity):

Code: Select all

public static List<EntitySet> ???(this ItemCollection collection)
{
    var list = new List<EntitySet>();
    var container = collection.GetItems<EntityContainer>().FirstOrDefault();
    if (container != null)
       list.AddRange(container.BaseEntitySets.OfType<EntitySet>().Where(...));
    return list;
}
In this method, instead of getting the first entity container, all available containers should be iterated:

Code: Select all

...
collection.GetItems<EntityContainer>().SelectMany(container => container.BaseEntitySets).OfType<EntitySet>().Where(...)
...

Re: Showstopper: database-related methods of OracleEntityProviderServices ignore all but first entity containers

Posted: Thu 03 Apr 2014 09:20
by Dennis Wanke
Any updates to this issue? It currently prevent us from adopting dotConnect for our product.

Re: Showstopper: database-related methods of OracleEntityProviderServices ignore all but first entity containers

Posted: Fri 04 Apr 2014 14:58
by Shalex
Thank you for your report. We have reproduced the problem and are working on it. We will notify you as soon as any results are available.

Re: Showstopper: database-related methods of OracleEntityProviderServices ignore all but first entity containers

Posted: Wed 09 Apr 2014 14:11
by Shalex
Multiple EntityContainers in the Code-First CreateDatabase()/CreateDatabaseScript()/DeleteDatabase() functionality are supported. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

Re: Showstopper: database-related methods of OracleEntityProviderServices ignore all but first entity containers

Posted: Thu 10 Apr 2014 14:06
by Shalex
New build of dotConnect for Oracle 8.3.135 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=29348.

Re: Showstopper: database-related methods of OracleEntityProviderServices ignore all but first entity containers

Posted: Fri 11 Apr 2014 08:58
by Dennis Wanke
I confirm the issue is now fixed.