asp net core work with stored procedure example sqlclient
Example: asp.net core sql server stored procedure
var emailAddressParam = new SqlParameter("@emailAddress", id.EmailAddress);
var passwordParam = new SqlParameter("@passwordHash", id.PasswordHash);
var users = context
.UserProfiles
.FromSqlRaw("exec sp_GetUsers @emailAddress, @passwordHash", emailAddressParam, passwordParam)
.ToList();