How to get data from relational table using entity framework [Resolved]

Posted by Abhi_Patil under ASP.NET Web API on 10/26/2015 | Points: 10 | Views : 2329 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I am fetching data from table using web api and entity framework.
i have .edmx file with relational tables.

there is only 1 record into EmployeeInfo table and this table has foreign key data with other tables.
when i try to fetch data from EmployeeInfo table using following statement, i am getting large data instead of single record.

return db.EmployeeInfo.ToList();

-----

Kindly help me to pull out exact available records from table using entity framework and web api

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Sheonarayan on: 10/27/2015 [Administrator] HonoraryPlatinum | Points: 50

0	It is clear from your question that your primary key and foreign key relationship of EmployeeInfo and other tables are not right. Check the relationship diagram in Visual Studio and modify them right and it should work as expected. Thanks Regards, Sheo Narayan http://www.dotnetfunda.com Abhi_Patil, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts