easy-table | Nice text table for Node.js | Data Manipulation library

Angular version: 6
Table library: ngx-easy-table
Library reference links:
https://stackblitz.com/edit/ngx-easy-table?file=app%2Fcomponents%2Fserver-sort%2Fserver-sort.component.ts
https://github.com/ssuperczynski/ngx-easy-table/wiki

Using the above table library, I want to sort certain columns using my custom sort function on the click of that particular column header/title. There is an example of custom sort in the stackblitz link provided above which enables us to do that but by placing a separate button for each column.

Also, am using to render the table data as below:

I'm a second year student and for my last project I'm interested in doing a Xamarin Application. So I just got started with Xamarin and I've been doing the tutorials in developer.xamarin to learn new things. However my ultimate goal is to make an Xamarin.Android App which has multiple screens which will be used to interact with an Azure SQLDatabase which is already being used for my ASP.NET Forms Website, so that I can use both like Facebook to as an App as well as an Website.

While I was searching for examples I got this by Xamarin This Link (Which is quite complicated and some unknown errors pop while I'm developing it) but, while I was reading the forums I got this C-Sharp Corner Tutorial which is quite easier than the original Xamarin Blog Example. Later I found another approach given in StackOverflow which is Hosted In GitHub. It would be grate if someone could explain me what is the correct approach (and what is used in the Industry) from above three and which is the most optimal solution for my app goal.

Plus, According to the articles I read, here's what I understood so far, It is unsafe to directly connect an Azure SQL Database to an Android App like we used to do in ASP.NET applications so what we usually do is use Some Mechanism called REST based on Json requests. It would be great if someone could tellWhat is the way to interact an Android Application with an Azure SQL database

Thanking in advance :-)

I have a cross platform mobile app built using Xamarin Forms and Visual Studio, it uses an Azure Mobile App table api to get its data. What I noticed was that the backend seems to run an additional query for incremental sync which checks the updatedAt columns timestamp.

Does anyone know where the query is generated (or what file holds it) within the node.js backend on Azure or rather, how I can remove it? It's a condition that we don't need as it's generating ghost data in the apps listview which is making everything appear as incorrect.

To clarify the node.js backend mobile app was automatically generated on Azure using Easy Tables within the Mobile App configuration (https://blog.xamarin.com/getting-started-azure-mobile-apps-easy-tables/). You simply add the name of your table and it will add the version, deleted, updatedAt and createdAt columns to the table for you.

It's an odd one but I feel totally out of control with my data, the app I made is ready only so the end user never deletes or updates anything.

Thanks

I have been following a tutorial about Azure Mobile Apps'Easy Tables (https://blog.xamarin.com/getting-started-azure-mobile-apps-easy-tables/). Everything has been going quite well and I managed to get to the point of testing my app which doesn't seem to return any data and I don't know why, I don't recieve any errors either which is making the tracing of this problem more difficult.

Ok to start with I have my Azure database (configured to allow access to Azure Services) and I have my table created and working using EasyTables. I used the Postman (https://www.getpostman.com/) application to test my API and to ensure data was returned from my database using https://myproject.azurewebsites.net/tables/users which returned my data as json.

My database table is called users and it's structure is quite basic (for testing) with two columns id and FirstName. I have populated my table with dummy data which I have proven can be returned from my azure uri using Postman.

That's the ground work to get running, here is a snapshot of my project hierarchy.

MyProject/Model/users.cs

This is the entity data which is named to match the table in the database.