Virtual property in Entity Framework or SQL Server join using view -

I have a model in which there are several navigation properties of other Poko models, I was thinking that it replaced it with a SQL View Which connects all these tables with a reputable model in the foreign key, which will require performance in all the data I need to get a boost, to boost performance. Any suggestions would be appreciated.

Using a indexed view will improve your reading performance, so it can be evaluated If you have the ability to change the database structure then you need to use EF's complex type feature to avoid the need to add multiple related classes to a single DB line altogether - consider can do.

While working with an ORM it is important to keep in mind that the design of your C # model and your database should not be particularly similar; So that you can create an executable database with minimal performance as well as a suitable C # model.