How to Execute Insert Operation Using Stored Procedure in Web API Core

Question

I Using Mysql Database and Stored Procedure to insert data in databse. Here my Id was Auto increment in . how to insert data using Stored procedure in Web api core.

Sachin Singh · Answer

using MySql.Data.MySqlClient;string cs = @"server=localhost;userid=dbuser;password=s$cret;database=mydb"; public void InsertData(Employee emp) {using(MySqlConnection con= new MySqlConnection("cs")) {MySqlCommand cmd= new MySqlCommand("spInsert",con); cmd.Parameters.AddWithValue("@name",emp.Name); cmd.Parameters.AddWithValue("@salary",emp.salary);con.Open();cmd.ExecuteNonQuery(); }}public class Employee { public int Id{get;set;} public string Name {get;set;} public int salary {get;set;}}/// Stored procedure mysql> DELIMITER // ; mysql> Create PROCEDURE insert_studentinfo( IN @name varchar(20),IN @salary int)-> BEGIN-> insert into Employee(name, salary) values (@name, @salary);-> END //

Jignesh Kumar · Answer

Hi Raj, Please refer this one, https://www.c-sharpcorner.com/article/crud-operations-in-asp-net-core-web-api-using-ado-net/ https://www.c-sharpcorner.com/UploadFile/e562e5/crud-operation-using-web-api-2-and-stored-procedure-with-a-s/

Jaydeep Patil · Answer

You can check my following article for the CRUD Operation in .NET Core 6 using Stored Procedure https://www.c-sharpcorner.com/article/crud-operation-using-entity-framework-core-and-stored-procedure-in-net-core-6-w/