can I directly pass the parameter in the query as shown below?
There is error so anyone could help?
public IEnumerable ListTop10countries(string direction)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MYCON"].ToString()))
{
var list = con.Query<OutputCountries>("Usp_GetTop10", direction).AsEnumerable();
return list;
}
}
Error:
An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code
Additional information: Procedure or function 'Usp_GetTop10' expects parameter '@direction', which was not supplied.
The stored proc script as is below:
CREATE proc [dbo].[Usp_GetTop10]
@direction nvarchar(30)
as
begin
SELECT TOP 10
[country]
,[Tons]
FROM [master].[dbo].[a]
where direction = @direction
order by [Tons] Desc
end
GO
try this
public IEnumerable ListTop10countries(string mydirection)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MYCON"].ToString()))
{
var list = con.Query<OutputCountries>("Usp_GetTop10", new {direction = mydirection}, commandType: CommandType.StoredProcedure).AsEnumerable();
return list;
}
}
이 기사는 인터넷에서 수집됩니다. 재 인쇄 할 때 출처를 알려주십시오.
침해가 발생한 경우 연락 주시기 바랍니다[email protected] 삭제
몇 마디 만하겠습니다