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

[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(...)
...

[Dennis Wanke]

Any updates to this issue? It currently prevent us from adopting dotConnect for our product.

[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.

[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.

[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.

[Dennis Wanke]

I confirm the issue is now fixed.