tags:

views:

58

answers:

1
Q: 

Entity framework - Create entity to multiple related tables

We have three tables. TableA relates to TableB and TableB relates to TableC. Is it possible to create a new entity framework entity composed of all three tables without using a stored procedure or view?

It only seems to allow one level of mapping where we have two in this case.

Any help or tutorial appreciated.

A: 

Follow the "entity splitting" scenario from this MSDN page.

I'm interpreting "relates" as meaning they have the same primary key. If not, please edit and I'll update my answer.

Stephen Cleary  2010-06-28 17:06:12
Standard 1 to manys. B has FK to table A's PK, C has FK to table B's PK. We have no relationships in the database. Our primary table for our entity is C, but we also need fields from B and A.
Chris  2010-06-29 08:30:10

related questions

Subsonic Vs NHibernate
How to check For File Lock in C# ?
Is nAnt still supported and suitable for .net 3.5/VS2008?
Limit size of Queue<T> in .NET?
Viewstate invalid when using Safari
Free OCR library
Unhandled Exception Handler in .NET 1.1
Localising date format descriptors
Get a new object instance from a Type in C#
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
.NET Testing Framework Advice
Embedded Database for .net that can run off a network
Automatically update version number
Homegrown consumption of web services
How do you migrate a large app from VB6 to VB .net ?
.NET Migrations Engine
Adding Scripting functionality to .NET applications
SQLite and XSD
Floating Point Number parsing: Is there a Catch All algorithm?
How do I programmatically create a PDF in my .NET application?
How do I sync the SVN revision number with my ASP.NET web site?
XSD DataSets and ignoring foreign keys
Anatomy of a "Memory Leak"
Reliable Timer in a Console Application
How do I calculate relative time?