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

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

Postby Dennis Wanke » Sat 29 Mar 2014 14:06

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
 
Posts: 57
Joined: Tue 11 Mar 2014 07:49

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

Postby Dennis Wanke » Thu 03 Apr 2014 09:20

Any updates to this issue? It currently prevent us from adopting dotConnect for our product.
Dennis Wanke
 
Posts: 57
Joined: Tue 11 Mar 2014 07:49

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

Postby Shalex » Fri 04 Apr 2014 14:58

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
Devart Team
 
Posts: 7616
Joined: Thu 14 Aug 2008 12:44

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

Postby Shalex » Wed 09 Apr 2014 14:11

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
Devart Team
 
Posts: 7616
Joined: Thu 14 Aug 2008 12:44

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

Postby Shalex » Thu 10 Apr 2014 14:06

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.
Shalex
Devart Team
 
Posts: 7616
Joined: Thu 14 Aug 2008 12:44

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

Postby Dennis Wanke » Fri 11 Apr 2014 08:58

I confirm the issue is now fixed.
Dennis Wanke
 
Posts: 57
Joined: Tue 11 Mar 2014 07:49


Return to dotConnect for Oracle