Connection.Execute无法正常工作 [英] Connection.Execute not working

问题描述

任何人都可以帮助我----这不会返回任何东西



public static void PopulateCacheUserPercentageMarksForClass（）

{

尝试

{

短？ returnValue = 0;

string errMsg =;

var param = new DynamicParameters（）;

param.Add（@ Return ，0，方向：ParameterDirection.Output）;

param.Add（@ RetunErrMsg，string.Empty，direction：ParameterDirection.Output）;

using（var connection = new SqlConnection（ConnectionManager.ConnectionString））

{

if（connection.State！= ConnectionState.Open）

{

connection.Open（）;



}

connection.Execute（s_tidx_PopulateCacheUserPercentageMarksForClass，param，commandType：CommandType.StoredProcedure ）;

returnValue = param.Get< short？>（@ Return）;

errMsg = param.Get< string>（@ RetunErrMsg）;



}

}

catch（例外情况）

{



}

}

can anybody please help me ----this is not returning anything

public static void PopulateCacheUserPercentageMarksForClass()
{
try
{
short? returnValue = 0;
string errMsg = "";
var param = new DynamicParameters();
param.Add("@Return", 0, direction: ParameterDirection.Output);
param.Add("@RetunErrMsg", string.Empty, direction: ParameterDirection.Output);
using (var connection = new SqlConnection(ConnectionManager.ConnectionString))
{
if (connection.State != ConnectionState.Open)
{
connection.Open();

}
connection.Execute("s_tidx_PopulateCacheUserPercentageMarksForClass", param, commandType: CommandType.StoredProcedure);
returnValue = param.Get<short?>("@Return");
errMsg = param.Get<string>("@RetunErrMsg");

}
}
catch (Exception ex)
{

}
}

推荐答案

没有这样的方法SqlConnection.Execute： http://msdn.microsoft.com/en-us/library/ system.data.sqlclient.sqlconnection％28v = vs.110％29.aspx [ ^ ]。



整个想法是完全错了;并且代码甚至无法编译。



请查看 SqlQuery ：

http://msdn.microsoft.com/ en-us / library / system.data.sqlclient.sqlcommand％28v = vs.110％29.aspx [ ^ ]。

-SA

There is no such method "SqlConnection.Execute": http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection%28v=vs.110%29.aspx[^].

The whole idea is totally wrong; and the code could not even compile.

Look at SqlQuery instead:
http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand%28v=vs.110%29.aspx[^].

—SA

这篇关于Connection.Execute无法正常工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！