Last post Jan 29, 2018 09:50 AM by Deepak Panchal
Jan 24, 2018 09:28 PM|ismailwissam|LINK
What is the best technology and framework to create a high response .net web application that connects to sql server large database?
Some tables can be modified from time to time like adding new fields.
Contains tables with more than 50 millions records and growing every day
Jan 25, 2018 08:58 AM|Deepak Panchal|LINK
You can try to Develop a Web Application using .Net Framework , C#.
There will be several options like Web application, WebSite, MVC Web Application, You can choose the desire one.
It can connect with and can handle big SQL Database.
You can try to start developing it using Visual Studio Community 2017 version.
Which is free of cost available to use.
Visual Studio Community
Below are some links that may help you to start development.
Chapter 1. Getting Started with ASP.NET 4
Get Started with ASP.NET
Getting Started with ASP.NET MVC 5
Jan 26, 2018 08:33 AM|wmec|LINK
There is no tricks to connect to SQL Database. You can try to create different Connection which is something like
<add name="conn2" connectionString="Data Source=192.168.?.?\your_db_instance;Initial Catalog=your_db_schema;Integrated Security=False;User ID=your_db_login;Password=??????" providerName="System.Data.SqlClient"/>
within Web.config/app.config file in your project.
Jan 26, 2018 09:06 AM|DA924|LINK
Jan 26, 2018 10:49 PM|ismailwissam|LINK
Jan 29, 2018 09:50 AM|Deepak Panchal|LINK
You had mentioned that,"It is not about the connection, it is about the best performance and security and easy to use".
All Web based projects in .Net Framework using Visual Studio provides security features and good performance.
It is upon you that with which you are familiar and having a strong knowledge to use those features efficiently.
If you are not familiar with those features then also the project will not give the desired performance.