Thank you for your responding my question is now I want to expose data from my in-house database to service other application from outside now I need to make sure a web api is a good way.

@Justin ,Thank you

Many thanks for your suggestion. This is very useful.

The requirement is application development for the manufacturing that supports warehouse, purchasing, production, planning etc.