Guide to setup a webservice to post data to a sql server backend using webapi

Im new to creating a webservice and looking for tutorial to setup a webservice that i can consume and to post data to a microsoft sql backend. I prefer to do it in visual studio but wanted to ask first what i should try.