I want to build a cloud based SAS application

Mark Tabor

I have a project of cloud based SAS application in which there is lot of business complex work flows , and the system should also contain very sensitive information like payment gateway integration and ten - twelve thrid party API with local systems , I have chosen asp.net mvc , i also have to developed native android app, my team chosen angular js 1.8 and mvc with sql server as DB, they are using ado.net instead of entity framework they are saying that ado.net is father than entity framework , can someone guide me what are the major part i should consider for this project like its performance should be faster in web and mobile both also can you define entity framework is best or ado.net is best , application scope is very braod and it is process oriented !

Thanks in advance

2 Replies

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

Mark Tabor8y ago
I have On premise SQL Server, and my whole application would be on cloud it is just like
http://www.tenantcloud.com

thanks for your support and response
Tushar Dikshit8y ago
Hi,
Entity framework is different approach than ADO.NET.
And it is not better or next version of ado.net, its different approach.

So you can go ahead with ADO.NET - It is proven good to support large and complex databse applications.
In your scenario I think ado.net could be better choice.
Also - are you going to use Azure SQL or On premise SQL Server? This could affect performance and overall architecture.
How much of your application architecture you want to put on cloud?
Calculate/predict data volume and read/writes to make the decision.

Thank you
Tushar