SQL Server Database is used for this solution. The connection string setup points to a hosted database on a remote server. You can use that database without requiring to setup SQL Server on your local machine. Or you can update connection string to point to a local database then run "update-database" to execute EF Core migration.

In other words, you can just run this API and start consuming it, with no code/config changes.

This is a standard WebAPI written in C# with a Contact Controller that exposes these actions, also available with OpenAPI in Development:

The actions take these parameters and return as below:

Task<ActionResult<GlobalResponse>> SaveContact(Contact record)

Task<ActionResult<GlobalResponse>> UpdateContact(Contact record)

Task<ActionResult<GlobalResponse>> DeleteContact(int id)

Task<ActionResult> GetContact(int id)

Task<ActionResult<List>> GetContacts()

The response schema looks like below: