如何使用OdataController使用Web Api服务？

Question

我打电话服务这个网址：http://localhost:7951/odata/Student 但我得到了错误

找不到404

我在哪里做错了吗？

我的DbContext类如下：

public class DataContext : DbContext 
{ 
    public DataContext() 
     : base("name=FrameworkConnStr") 
    { 
    } 

    public DbSet<Student> Students { get; set; } 
    public DbSet<StudentAddress> StudentAddresses { get; set; } 
} 

[Table("M_DEMIR.STUDENT")] 
public partial class Student 
{ 
    public Student() 
    { 
     StudentAddress = new HashSet<StudentAddress>(); 
    } 

    [Column("ID"), Key] 
    public int Id { get; set; } 

    [Column("NAME", TypeName = "varchar2"), MaxLength(25)] 
    public string Name { get; set; } 

    [Column("SURNAME", TypeName = "varchar2"), MaxLength(50)] 
    public string Surname { get; set; } 

    public virtual ICollection<StudentAddress> StudentAddress { get; set; } 
} 

[Table("M_DEMIR.STUDENTADDRESS")] 
public partial class StudentAddress 
{ 
    [Column("ID"), Key] 
    public int Id { get; set; } 

    [Column("STUDENT_ID")] 
    public int StudentId { get; set; } 

    [Column("CITY", TypeName = "varchar2"), MaxLength(25)] 
    public string City { get; set; } 

    [ForeignKey("StudentId")] 
    public virtual Student Student { get; set; } 
} 

控制器代码是如下：

[EnableQuery] 
public class StudentController : ODataController 
{ 
    DataContext db = new DataContext(); 


    public IHttpActionResult Get() 
    { 
     return Ok(); 
    } 


} 

而且WebApiConfig守则如下：

public static class WebApiConfig 
{ 
    public static void Register(HttpConfiguration config) 
    { 
     var builder = new ODataConventionModelBuilder(); 
     builder.EntitySet<Student>("Students"); 
     builder.EntitySet<StudentAddress>("StudentAddresses"); 
     config.Routes.MapODataServiceRoute("odata", "odata", builder.GetEdmModel()); 
    } 

我在哪里做错了？

Answer 1

[ODataRoutePrefix("Students")] 
public class StudentController : ODataController 
{ 
    DataContext db = new DataContext(); 

    [EnableQuery(MaxTop = 100)] // MaxTop so you can use the $top in the query string 
    [ODataRoute] 
    public IHttpActionResult Get() 
    { 
     return Ok(db.Students); // you do want to return something that can be queried 
    } 
} 

• EnableQuery应该是GET方法。
• 将ODataRoute添加到Get方法。
• 添加ODataRoutePrefix("Students")类定义，你现在有EnableQuery

将网址变更为http://localhost:7951/odata/Students（添加一个或多个）。

另外不要忘记通过覆盖控制器的Dispose方法来处置您的DbContext实例。