Looking for a tutorial on creating a web API that is connected to a DB.

[BenzilLobo]

I'm looking for a tutorial that teaches me how to create a web API (with C#) that is connected to a database. It doesn't matter to me what kind of SQL the tutorial is using, but I want to create the API with C#. It would be nice if the tutorial would also teach me on how to authenticate a user through the API.

I haven't had any succes finding a good up to date tutorial for what I'm looking for. Most tutorials I found are outdated or are not connected using a database. (or use other languages that I'm not comfortable with) It would be nice if the tutorial is using JSON, but XML would be fine aswell.

I'm hoping someone can tell me where exactly I should start learning what I want. Perhaps a link to one or multiple tutorials would be nice.

[Gurunathan A]

Hi BenzilLobo, 

Thanks for contacting Syncfusion.  

We have found some useful blogs which help to work on your requirement. 

https://dotnettutorials.net/lesson/web-api-with-sql-server/  - this is very simple and easy to connect  

https://www.codingame.com/playgrounds/35462/creating-web-api-in-asp-net-core-2-0/part-1---web-api this is having brief details about WEB API connection with data base and data retrieving.  

https://www.c-sharpcorner.com/article/crud-in-web-api-using-sql-server/ - this is about the CRUD action. 

Please let us know if any concerns.  

Regards, 

Gurunathan  

[BenzilLobo]

I'm looking for a tutorial that teaches me how to create a web API (with C#) that is connected to a database. It doesn't matter to me what kind of SQL the tutorial is using, but I want to create the API with C#. It would be nice if the tutorial would also teach me on how to authenticate a user through the API.

I haven't had any succes finding a good up to date tutorial for what I'm looking for. Most tutorials I found are outdated or are not connected using a database. (or use other languages that I'm not comfortable with) It would be nice if the tutorial is using JSON, but XML would be fine aswell.

I'm hoping someone can tell me where exactly I should start learning what I want. Perhaps a link to one or multiple tutorials would be nice.

I'm looking for a tutorial that teaches me how to create a web API (with C#) that is connected to a database. It doesn't matter to me what kind of SQL the tutorial is using, but I want to create the API with C#. It would be nice if the tutorial would also teach me on how to authenticate a user through the API. 

Appvalley

I haven't had any succes finding a good up to date tutorial for what I'm looking 

https://vlc.onl/

 for. Most tutorials I found are outdated or are not connected using a database. (or use other languages that I'm not comfortable with) It would be nice if the tutorial is using JSON, but XML would be fine aswell. 

Tweakbox

my issue got slved!

[Gurunathan A]

Hi BenzilLobo,  

Thanks for the update.  We are happy to assist you.  

Regards, 

Gurunathan  

[Harsh Shah]

Please Refer bellow sites it is providing whole tutorial about web API

• https://www.tutorialsteacher.com/webapi/test-web-api

• https://docs.microsoft.com/en-us/aspnet/web-api/overview/getting-started-with-aspnet-web-api/tutorial-your-first-web-api

Hope this will help you.

[Amos Smith]

Thank you, very helpful