Bottom line: I dont want to code on SharePoint 2016 or online, ive done it before, its a pain and clunky experience and other issues.
I am a developer and i code mostly in C# using ASP.NET/MVC and started coding using Core. I have a project to build but i want to use SharePoint online as the "storage" but I want to build a completely separate frontpage and set of UIs on an MVC project.
For example, if i were to make a small app that records production numbers, users would go to my MVC app and enter the new number. This data then gets inserted to some list on SharePoint Online/365 which we created using the out-of-the-box tool. Similarly on the MVC web app the user can run a report that runs a query on the SharePoint Online list and returns the data which is then graphed out using visualization libraries on the MVC app.
I would like to know if it is possible to design the lists etc to hold the content on SharePoint Online and make the MVC website talk to those lists (CRUD operations) and display the content back into the MVC project? And would there be an API i should be looking into?
We have an O365 license for SharePoint Online, O365 etc and we would be hosting the MVC application on Azure included in our package with Microsoft.
Thank you for your time!