how to retreive httpget data stored procedure in net core 31HttpGetRoute34apiTalentGetTalents34public async TaskltIEnumerableltGetTalentgtgt GetTalentsGetTalent model var param new SqlParameter34Id34 modelId return await dbGetTalentsFromSqlRaw34EXEC spTblMstTalentSelect Id34 paramToListAsync

Call Stored Procedure using Entity Framework FromSqlRaw in ASP.Net Core

Ruben123...

SOLVED CLOSED ACTIVE ANSWERED
User: Ruben12345
Posted: on Feb 27, 2020 11:10 PM
Forum: Entity Framework
Replies: 2
Views: 8051

how to retreive httpget data stored procedure in net core 3.1

[HttpGet]
[Route("api/Talent/GetTalents")]
public async Task<IEnumerable<GetTalent>> GetTalents(GetTalent model)
{
    var param = new SqlParameter("@Id", model.Id);
    return await db.GetTalents.FromSqlRaw("EXEC sp_Tbl_Mst_TalentSelect @Id", param).ToListAsync();
}