Using the designer in Visual Studio, how can you define an entity that maps to 2 or more tables?
See this video. http://www.msteched.com/2010/NorthAmerica/DEV305
try http://stackoverflow.com/questions/1772064/entity-framework-map-multiple-tables-to-one-entity
or
http://msdn.microsoft.com/en-us/library/cc716698.aspx