Advice about best method

Greeting

I neet to ask waht a principle solution to these situation.

I'm working on web application asp.net c#. with bootstrap 4.1

what a priciple way to show data in bootstrap cards designed to show tables statistics like( total products, total categories, total sales) notice(am not ask about sql query) my questions below:

1- Is princile to use views to get sperated totals and show it in many cards, in same page.

2- Is principle to create entity model from database to get total query from tabel.

3- Is usefule to use entity model after build 99% of my app.

3- what is a light method in last question. (view or entity model)speciall my application begining in light mode a data base be very light not have strong (CRUD).

Thanks for advice

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aktham Mahmoud6y ago
mmmm, But is this way not heavy on D.B
as example,
I need to calculate total rows for table (
- Total categoreis.
- Total Products.
Etc.

So useing stored procedure is principle.
I hope to descuse that..

Thanks
Laxmidhar Sahoo6y ago
When you conpleted 99% ,it is wise that use the stored procedure in sql and make strong the database utilities