EF4.3如何调用有返回值的储存过程

[LeoPan1988]

EF4.3如何调用有返回值的储存过程,我是这样写的，但是，一直返回的值不对，麻烦各位帮忙看看。。。
SqlParameter[] parm = {
new SqlParameter("TableName",SqlDbType.VarChar,50),
new SqlParameter("Fields",SqlDbType.VarChar,5000),
new SqlParameter("OrderField",SqlDbType.VarChar,5000),
new SqlParameter("sqlWhere",SqlDbType.VarChar,5000),
new SqlParameter("pageSize",SqlDbType.Int),
new SqlParameter("pageIndex",SqlDbType.Int),
new SqlParameter("TotalPage",SqlDbType.Int),
new SqlParameter("totalRecordCount",SqlDbType.Int)
};
parm[0].Value = mt.TableName;
parm[1].Value = mt.Fields;
parm[2].Value = mt.OrderField;
parm[3].Value = mt.SqlWhere;
parm[4].Value = mt.PageSize;
parm[5].Value = mt.PageIndex;
parm[6].Direction = ParameterDirection.Output;
parm[7].Direction = ParameterDirection.Output;
var list = db.Database.SqlQuery<T>("exec Pro_GetRecord @TableName,@Fields,@OrderField,@sqlWhere,@pageSize,@pageIndex,@TotalPage,@totalRecordCount", parm).ToList();

[觉悟之时]

SqlCommand cmd = new SqlCommand("SqlMembership_GetAllUsers",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ApplicationName",SqlDbType.VarChar,255).Value = this.applicationName;
cmd.Parameters.Add("@PageIndex",SqlDbType.Int).Value = pageIndex;
cmd.Parameters.Add("@PageSize",SqlDbType.Int).Value = pageSize;
SqlParameter parm = new SqlParameter("@totalrecords",SqlDbType.Int);
parm.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parm);
conn.Open();
dr = cmd.ExecuteReader();
while( dr.Read() )
{
members.Add(MembershipUserFromReader(dr));
}

[LeoPan1988]

你这个是ADO.NET下的调用吧。。。
[Quote=引用 1 楼 wellbeingzhang 的回复:]

SqlCommand cmd = new SqlCommand("SqlMembership_GetAllUsers",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ApplicationName",SqlDbType.VarChar,255).Value = this.applicati……
[/Quote]

[laizhiping_rj]

SqlParameter[] parm = {  
  new SqlParameter("@TableName",SqlDbType.VarChar,50),
  new SqlParameter("@Fields",SqlDbType.VarChar,5000),
  new SqlParameter("@OrderField",SqlDbType.VarChar,5000),
  new SqlParameter("@sqlWhere",SqlDbType.VarChar,5000),
  new SqlParameter("@pageSize",SqlDbType.Int),
  new SqlParameter("@pageIndex",SqlDbType.Int),
  new SqlParameter("@TotalPage",SqlDbType.Int),
  new SqlParameter("@totalRecordCount",SqlDbType.Int)
  };
  parm[0].Value = mt.TableName;
  parm[1].Value = mt.Fields;
  parm[2].Value = mt.OrderField;
  parm[3].Value = mt.SqlWhere;
  parm[4].Value = mt.PageSize;
  parm[5].Value = mt.PageIndex;
  parm[6].Direction = ParameterDirection.Output;
  parm[7].Direction = ParameterDirection.Output;
  var list = db.Database.SqlQuery<T>("exec Pro_GetRecord @TableName,@Fields,@OrderField,@sqlWhere,@pageSize,@pageIndex,@TotalPage,@totalRecordCount", parm).ToList();

[LeoPan1988]

汗。。。
[Quote=引用 3 楼 laizhiping_rj 的回复:]

SQL code

SqlParameter[] parm = {
new SqlParameter("@TableName",SqlDbType.VarChar,50),
new SqlParameter("@Fields",SqlDbType.VarChar,5000),
new SqlParameter("@OrderField",SqlDbType.VarChar,50……
[/Quote]