---
title: "show data from more tables relation"  
description: "show data from more tables relation"  
author: "Abeer Shlby"  
published: 2016-08-23  
updated: 2016-08-23  
canonical: https://www.mindstick.com/forum/34166/show-data-from-more-tables-relation  
category: "asp.net mvc"  
tags: ["asp.net mvc"]  
reading_time: 1 minute  

---

# show data from more tables relation

In this diagram below

I need to make [view](https://yourviews.mindstick.com/view/84701/layoffs-in-google-india-2023-view) contain to following

[Name](https://yourviews.mindstick.com/view/87450/how-to-generate-a-brand-name-using-linkedin-comprehensive-guide),[Email](https://www.mindstick.com/articles/12870/10-easy-ways-to-manage-your-business-email-inbox),Salary,DistrictName,CountryName,CityName,CourseName,LanguageName,levelName

all id is [identity](https://www.mindstick.com/articles/13090/icon-the-identity-of-your-brand) [increment](https://www.mindstick.com/forum/173/auto-increment-id) by 1

i [already](https://yourviews.mindstick.com/view/88453/the-hidden-ways-ai-is-already-controlling-your-daily-life) have ef [design](https://www.mindstick.com/articles/12279/interior-design-and-furniture-store-wordpress-theme) for these [tables](https://www.mindstick.com/articles/336597/introduction-of-html-tables-for-web-development)

how to make view for that

in [controller](https://www.mindstick.com/blog/273/passing-values-from-controller-to-view-in-asp-dot-net-mvc)

```
public ActionResult index(){//what i write here to create viewreturn view();}in view what i write <html><html>and what model i will create to show datapublic class emp{}
```

![show data from more tables relation](https://www.mindstick.com/mindstickforums/8c766dea-f76c-4219-adb1-cbd6af86ed11/images/7e800b1b-0242-4647-9927-90974abd77d1.png)\


---

Original Source: https://www.mindstick.com/forum/34166/show-data-from-more-tables-relation

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.
