Bug #45513 Query freezes when using Entity framework with abstract/classes and inheritance
Submitted: 16 Jun 2009 5:22 Modified: 7 Sep 2009 12:55
Reporter: Alexis Bilodeau Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / NET Severity:S3 (Non-critical)
Version:6.0.4 OS:Windows
Assigned to: Assigned Account CPU Architecture:Any
Tags: entity framework, Inheritance, linq, query

[16 Jun 2009 5:22] Alexis Bilodeau
Description:
I used the 6.0.3 and 6.0.4 .Net connectors succesfully to issue simple queries (which are queries to a single table).

Now I have a scheme where a DB Table contains common attributes and a series of tables contains specific attributes. I modeled this in the VS2008 designer as a parent/children relationship where the table containing common attributes is an abstract class and the other tables inherit from it.

Issuing a Linq query to this scheme using a common attribute in the where clause freezes the application.

Not sure this is actually related to the connector, but you will be more knoledgeable than me to decide.

How to repeat:
In c# :

            var query = (from p in aDB.PartSet
                          where p.Part_Number == searchedPN
                          select p).First<Part>();

PartSet is the parent (abstract) Entity, and Part_Number is one of its attributes.

Other than that, let me know if I can provide any additional information that could be useful.
[7 Aug 2009 12:55] Tonci Grgin
Hi Alexis and thanks for your report.

You may consult test cases attached to Bug#46142 or Bug#45723, for example, and attach something of similar quality.
[7 Sep 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".