This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 77%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
I have a data model where I am connecting to the same table 3 times. I can do this in SQL by using aliases, but I am unsure if it is possible to do this in ASP.NET Core 7 MVC. Are you able to "alias" a model in ASP.NET MVC?
MVC is for creating web sites and has nothing to do with SQL. You can write whatever SQL you like.
Perhaps this is an Entity Framework question?
It is an Entity Framework question. Within EF how is it possible to have the same model 3 times in one view?
Duplicate response.
@tjestesjr77 , is any update? Do you have some progress on the current question? I think one to many could solve your problem. How about you?
It is an Entity Framework question. Within EF how is it possible to have the same model 3 times in one view?
Yes. See the EF Core relationship documentation. Self-referencing one-to-many Keep in mind, you can still write any SQL you like even if you are using Entity Framework. SQL Queries