Jim's Articles

Instant database Web API

Very fast database Web API? Since REST utilizes CRUD (Create, Retrieve, Update, and Delete), it is very easy to understand whether you are just starting out as a developer or have years of experience. It can be reused with different projects which saves time as well. It’s also very popular and according to Cloud Elements’ 2017 State of API Integration report, 83 percent of APIs now use REST. Here’s an article which goes into more depth but these are the highlights.

SOAP (Simple Object Access Protocol) and REST (Representational State Transfer) are both web service communication protocols. SOAP was long the standard approach to web service interfaces, although it’s been dominated by REST in recent years, with REST now representing more than 70% of public APIs according to Stormpath. Understand the primary differences between SOAP vs. REST and how each can benefit your organization’s goals.

Use Links for Relationships: Another way to show relationships between resources, without falling back on using keys in an SQL-like manner, is to embed links inside your responses. A cool thing about links is that they allow autodiscovery by clients! When the client gets the response back then it can see in the _link section what other actions it can follow from here. This is just like when you are surfing the web where you come to a page and then you can follow its links to new pages. Another nice thing is that clients will have fewer hard-coded links in their code, which will make the code more robust. If the client wants to see the customer’s orders, it can just follow the orders link to get them.

Code will be generated into the initial stub Visual Studio solution. At this point the solution can be build and is ready to use. The solution should contain 2 projects; one for the actual Web API and another one for Unit Tests. Using the Unit Test project you can test the quality of the Web API that was generated. The Web API project should contain a referrence to Swagger UI, that allows for clear documentation and testing of the newly created API. Build an instant database Web API now, no coding required. Generate your Web API in minutes to build applications faster. Using Entity Framework 6.2.0 and VS 2017 generate your Web API for any MS SQL database. NEW – Use Core EF to build Instant Web API! Using Core Entity Framework 2.2 and VS 2019 generate your Web API for any MS SQL database. Find extra details at http://instantwebapi.com/.