ASP.NET网页API控制器,存储过程不返回数据
问题描述:
我有我的数据库中的以下存储过程:ASP.NET网页API控制器,存储过程不返回数据
SELECT dbo.Persona.Nombre, dbo.Persona.Cedula, dbo.Prestamo.Empresa, dbo.Prestamo.Concepto, dbo.Prestamo.Monto, dbo.Prestamo.Fecha, dbo.Prestamo.PagadoATiempo
FROM dbo.Financiera INNER JOIN
dbo.Prestamo ON dbo.Financiera.RNC = dbo.Prestamo.Empresa INNER JOIN
dbo.Persona ON dbo.Prestamo.Cliente = dbo.Persona.Cedula
WHERE dbo.Persona.Cedula = @p1
中,然后在我的上下文类为:
public partial class BDWSEntities : DbContext
{
public BDWSEntities()
: base("name=BDWSEntities")
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
throw new UnintentionalCodeFirstException();
}
public virtual DbSet<Financiera> Financieras { get; set; }
public virtual DbSet<Persona> Personas { get; set; }
public virtual DbSet<Prestamo> Prestamoes { get; set; }
public virtual ObjectResult<EnviarHistorial_Result> EnviarHistorial(string p1)
{
var p1Parameter = p1 != null ?
new ObjectParameter("p1", p1) :
new ObjectParameter("p1", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<EnviarHistorial_Result>("EnviarHistorial", p1Parameter);
}
public virtual ObjectResult<Nullable<bool>> EnviarSalud(string p1)
{
var p1Parameter = p1 != null ?
new ObjectParameter("p1", p1) :
new ObjectParameter("p1", typeof(string));
return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Nullable<bool>>("EnviarSalud", p1Parameter);
}
}
和我使用以下控制器访问它:
namespace Web_Services.Controllers
{
public class HistorialController : ApiController
{
private BDWSEntities db = new BDWSEntities();
public IHttpActionResult GetHistorial(string Cedula)
{
var record = db.EnviarHistorial(Cedula);
if (record == null)
{
return NotFound();
}
return Ok(record);
}
}
}
现在,在理论上,这个控制器应该返回数据,但是当通过相关的localhost/api/Historial访问,它不返回任何数据或消息,它只是返回一个空的JSON文件。发生了什么?
答
试试这个:
public virtual ObjectResult<EnviarHistorial_Result> EnviarHistorial(string p1)
{
var p1Parameter = p1 != null ?
new ObjectParameter("p1", p1) :
new ObjectParameter("p1", typeof(string));
return this.Database.SqlQuery<EnviarHistorial_Result>("EnviarHistorial", p1);
}
+0
谢谢你,谢谢你。这工作! –
“我有以下存储过程” 在哪里?我没有看到它的问题。您发布了两次相同的查询 – Marusyk
“然后在我的上下文类”中,该代码不是上下文的代码。这是一个查询! – Marusyk
哎呀,我把它搞砸了。固定! –