EF Core - Stored procedure Insert

EF Core - Stored procedure Insert - Clean architecture

manikandan r

I have a single SQL Stored procedure which runs multiple insert statements. with the Clean architecture, how do i call and execute the stored procedure? I am not sure i need to create multiple entities first to use IRepository

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jaimin Shethiya2y ago

Accepted answer

Hello Manikandan,

Please refer to the below code.

int id = 1;
var idParam = new SqlParameter("@Id", id);
List lst = dataContext.Products
            .FromSql("Your SP Name @Id", idParam)
            .ToList();

public static int AddSql(AppDbContext context, int id)
{
    return context.Database.ExecuteSql($"Your SP Name @Id={id}");
}

Thanks