SQL Server Database table to REST web service

Question

Is there an Azure service to expose the database table to REST API?

I have a table in SQL Server and I want to expose that table via REST API without having to manage any infra or authentication

https://azure.microsoft.com/en-us/blog/introduction-to-open-data-protocol-odata-and-sql-azure/ — Dai, Nov 12 '19 at 00:50

score 0 · Answer 1 · answered Nov 12 '19 at 03:56

0

No SQL server does not have a REST api directly, But you can build an OData service with ASP.NET Web API and Entity Framework.

answered Nov 12 '19 at 03:56

Sajeetharan

score 0 · Answer 2 · answered Nov 12 '19 at 06:35

0

You can create a class based on the table fields and on getting the table data convert it to List and response it.

To Convert DataTable to List use the link: Found in Stackoverflow

answered Nov 12 '19 at 06:35

Moloy Adhikary

2 Answers2