Get varied columns from in Entity Framework 3.0

Question

I have an ASP.NET Core MVC solution.

I tried to get dynamic object and uncertainly column numbers and types from a stored procedure.

I prepared the stored procedure, but I couldn't find a solution about created stored procedure's class and more usage in EF Core 3.0.

I found a lot of solutions another versions of EF, but my developed project unfortunately business level project and already using EF Core 3.0 in many modules in a single a solution. How can I dynamically fetch data from SQL in ASP.NET Core MVC with EF Core 3.0?

Use Dapper for such task.

Svyatoslav Danyliv
– Svyatoslav Danyliv

2021-09-23 05:26:21 +00:00
Commented Sep 23, 2021 at 5:26 — Svyatoslav Danyliv
– Svyatoslav Danyliv, Commented Sep 23, 2021 at 5:26

Emin Niftiyev · Accepted Answer · 2021-09-23 05:23:53Z

-1

If your project is handling very large data transfers, I would not recommend using EntityFramework. You can take full control by using Repository Pattern. take a look here.

If you use Repository Pattern, it provides great advantages in terms of both program speed and change. That's why ORM is not the first product to look at in large projects.

answered Sep 23, 2021 at 5:23

Emin Niftiyev

2332 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get varied columns from in Entity Framework 3.0

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related