Execute action queries using SqlCommand in ASP.NET Core

In the previous article we used SqlDataReader to execute SELECT queries and to read data from the database. You often need to execute action queries - INSERT, UPDATE, and DELETE - on the database to perform the respective operations. As far as as SQL Server data provider is concerned you can do that with the help of SqlCommand object. That's what we are going to discuss in this article.

http://www.binaryintellect.net/articles/bbad43ee-9ccc-4178-8624-c9cf72508dde.aspx