DevForce Community Forum : Two entities using the same database table http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Two entities using the same database table Sat, 11 Apr 2026 11:22:16 -700 Tue, 13 Jul 2010 07:46:09 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1894 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Two entities using the same database table : For anyone who is intressed. De... http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7606#7606 Author: Peter
Subject: 1894
Posted: 13-Jul-2010 at 7:46am

For anyone who is intressed.

De EF inheritance type TPH is working in this situation, as I described before.
The problem was (still is), that not in all cases the Visual Studio 2010 IDE correctly updated my EDMX file.
When I deleted an, automatic generated assiocation, the XML tag was not deleted in  the EDMX file.
I had to do it by manually.
I've read about this on the internet but I'm not sure if this is a bug or a local problem.
 
 
 
]]> Tue, 13 Jul 2010 07:46:09 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7606#7606 Two entities using the same database table : Hi Peter, Yes, I forgot... http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7381#7381 Author: ting
Subject: 1894
Posted: 22-Jun-2010 at 7:58pm

Hi Peter,
 
Yes, I forgot about that possibility.  That's seems like a reasonable approach.
 
 
]]> Tue, 22 Jun 2010 19:58:06 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7381#7381 Two entities using the same database table : Hello ting, Thank for your... http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7344#7344 Author: Peter
Subject: 1894
Posted: 17-Jun-2010 at 2:18am

Hello ting,

 

Thank for your response.

I also believe it is a EF question.

But, I find it hard to believe that I need to solve this though one entity.

 

I've read so far:

 

I can define two EF entities and alter the mapping properties.

The mapping properties also can hold conditions to filter the query.

Within my own partial class of Directory and File I can set the 'IsFile' variable.

 

I'm still testing this approche  

I’ll  keep you posted.

Peter

]]> Thu, 17 Jun 2010 02:18:02 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7344#7344 Two entities using the same database table : Yes, this is more of an Entity... http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7329#7329 Author: ting
Subject: 1894
Posted: 15-Jun-2010 at 8:19pm

Yes, this is more of an Entity Framework question, but it is interesting nonetheless.  I'm not the modelling expert, but I suspect that you will need to unify the DirectoryEntity and FileEntity into a single entity and return empty collections when IsFile is true.  You can make the foreign key fields private/protected (not a bad practice) so that everyone goes through the object-oriented methods.
]]> Tue, 15 Jun 2010 20:19:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7329#7329 Two entities using the same database table : Ok, I just hit the wrong button..... http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7314#7314 Author: Peter
Subject: 1894
Posted: 14-Jun-2010 at 4:06am

Ok, I just hit the wrong button.. lets resume my post.

Hello,
 
I've just started with DevForce and have a question about modelling my entities.
I'm not sure where EF ends and DF begins, so this may be an EF question.
 
I have a classic 'directory-file' situation
On one side the directory tree and on the other the containing files
I'm using one table to store these instances.

DataTable
- ID  Int
- Name  Varchar
- IsFile Bit
- Parent_ID  Int

DirectoryEntity
- ID  Int
- Name  String
- Parent  DirectoryEntity
- Childs Collection of DirectoryEntiry
- Files  Collection of FileEntity

FileEntity
- ID  Int
- Name  String
- Parent DirectoryEntity

Questions:
1. What is the best way to implement this?
2. How do I hide 'IsFile', but, implement it's value in the correct entity class?
3. EF, by default, makes FK fields public, like 'Parent_ID'. Can I freely set it getter and setter to private?

Thank in advance.
Peter

]]> Mon, 14 Jun 2010 04:06:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1894&PID=7314#7314