Web API code software on MS SQL? Daniel Jacobson, Director of Engineering at Netflix, writes in his influential API strategy book that REST should be the default choice for any new API you write today, and Google Insights reveals that REST overtook SOAP as the most popular API style in 2008, and has increased its dominance ever since. This pervasiveness of REST is one of its key strengths; you are not only choosing a technology, you are also joining an enormous ecosystem of tools, best practices and developers.
Benefits of SOAP Over REST. Still, SOAP remains the preferred protocol for certain use cases. The general consensus among experts these days is that REST is the typically preferred protocol unless there’s a compelling reason to use SOAP (and there are some cases in which SOAP is preferred). Because you can achieve most outcomes using either protocol, it’s sometimes a matter of personal preference. However, there are some use cases for which SOAP tends to be better-suited. For instance, if you need more robust security, SOAP’s support for WS-Security can come in handy. It offers some additional assurances for data privacy and integrity. It also provides support for identity verification through intermediaries rather than just point-to-point, as provided by SSL (which is supported by both SOAP and REST).
Begin with the API User in Mind: Bestselling author and architect Sam Newman’s great book on microservices provides a powerful alternative to the database-driven approach for designing REST web services. It’s useful even if you don’t plan to use microservices. Newman suggests that you divide your application into bounded contexts (similar to business areas). Each bounded context should provide an explicit interface for those who wish to interact with it. Implementation details of the bounded context that don’t need to be exposed to the outside world are hidden behind the interface. You should use this explicit interface as the basis for your API design. Start by asking yourself what business capabilities do the API user needs, rather than what data that should be shared. In other words, ask yourself what does this bounded context do? and then ask yourself what data does it need to do that?
When I ran InstantWebAPI I get an error message about writing rights. How can this be fixed? If you created the stub solution as an administrator, then InstantWebAPI needs to be run as an administrator as well. We have a database with 80 tables. How many tables and views can this software generate the code for? This code was tested against databases with more than 100 tables. Web API project code gets generated pretty fast, but generating Unit Test code it might take a while. We recommend generating the code for a limited number of tables at a time. We have a database with multiple schema. Can the code be generated for all the schemas at the same time? No, this version of the software only allows generating the code for one schema at a time. Further customization can be added by sending a requests to Customer Service. See extra details on Instant database Web API.