Entity Framework 5.0 调用存储过程 返回值为什么是int类型
想念旧时光 2014-03-26 03:19:32 在sql server中调用存储过程确实返回的是多个表的连接后的结果集
但是生成带ef中 却返回的时候Int类型
存储过程里面未使用临时表跟select into
求各位大神求解决分方法
public virtual int sp_Report_VIPSales(Nullable<System.DateTime> dateBeg, Nullable<System.DateTime> dateEnd, Nullable<int> storeID, Nullable<int> provinceID, string salesAreaName, string brandID, Nullable<int> vIPType, Nullable<int> output)
{
var dateBegParameter = dateBeg.HasValue ?
new ObjectParameter("DateBeg", dateBeg) :
new ObjectParameter("DateBeg", typeof(System.DateTime));
var dateEndParameter = dateEnd.HasValue ?
new ObjectParameter("DateEnd", dateEnd) :
new ObjectParameter("DateEnd", typeof(System.DateTime));
var storeIDParameter = storeID.HasValue ?
new ObjectParameter("StoreID", storeID) :
new ObjectParameter("StoreID", typeof(int));
var provinceIDParameter = provinceID.HasValue ?
new ObjectParameter("ProvinceID", provinceID) :
new ObjectParameter("ProvinceID", typeof(int));
var salesAreaNameParameter = salesAreaName != null ?
new ObjectParameter("SalesAreaName", salesAreaName) :
new ObjectParameter("SalesAreaName", typeof(string));
var brandIDParameter = brandID != null ?
new ObjectParameter("BrandID", brandID) :
new ObjectParameter("BrandID", typeof(string));
var vIPTypeParameter = vIPType.HasValue ?
new ObjectParameter("VIPType", vIPType) :
new ObjectParameter("VIPType", typeof(int));
var outputParameter = output.HasValue ?
new ObjectParameter("Output", output) :
new ObjectParameter("Output", typeof(int));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction("sp_Report_VIPSales", dateBegParameter, dateEndParameter, storeIDParameter, provinceIDParameter, salesAreaNameParameter, brandIDParameter, vIPTypeParameter, outputParameter);
}
这是生成的的代码