Platform for OnPremises CRUD SQL Server Application Development

Hello,

I would like to develop rather simple CRUD applications that to work with SQL Server databases that we host on premises.

I am not a professional developer but in the last couple of years I have become fairly proficient in SQL, Power Automate, Power Apps and Logic Apps and Power Query so that I was able to create some cloud based CRUD solutions and retrieve and view data on premises in Excel. I can also run the ETLs that we need to get data into the SQL databases from other sources.

Now, I am looking to create solutions that will not only allow me to display data from the SQL server, but to also enter new data or change existing data. All our users run Windows PCs. The Windows users (in the On Premises AD) and their security groups are known to the SQL server. Rights for access to the data are handled by the database.
In future, I would also like to be able to create simple web applications that will allow to display records and add new records depending on the user's Azure AD login (we have an Azure AD besides the Windows AD on premises).

I like the idea of low code, but I also don't want to be trapped in a closed development environment that will cause ongoing licensing costs.
So, my question is: what platform/development environment/programming language should I learn and use to be able to do create the first solutions and then later graduate to cloud-based solutions?

Thank you!

For programming language, go for C# of course.

Regardless of everything else, you should learn about Entity Framework. It will take time to learn but save much time after that. It is for working with databases. It is used by professionals and works in both desktop applications and websites. There are very many articles about it available in this website and in very many other websites. I recommend finding a book about it but I do not know what to recommend.

For desktop applications you probably want to use WPF.

For websites use ASP.Net Core. There are also are very many articles about it available in this website and in very many other websites. As a beginner you should find a book about it but I do not know what to recommend.

1 Reply

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

Sam Hobbs4y ago
For programming language, go for C# of course.

Regardless of everything else, you should learn about Entity Framework. It will take time to learn but save much time after that. It is for working with databases. It is used by professionals and works in both desktop applications and websites. There are very many articles about it available in this website and in very many other websites. I recommend finding a book about it but I do not know what to recommend.

For desktop applications you probably want to use WPF.

For websites use ASP.Net Core. There are also are very many articles about it available in this website and in very many other websites. As a beginner you should find a book about it but I do not know what to recommend.