动态属性上的$select

Question

我有以下代码：

public class Book
{
    [Key]
    public string ISBN { get; set; }
    public string Title { get; set; }
    public Press Press { get; set; }
    public IDictionary<string, object> Properties { get; set; }
}

public class BooksController : ODataController
{
    private IList<Book> _books = new List<Book>
    {
        new Book
        {
            ISBN = "978-0-7356-7942-9",
            Title = "Microsoft Azure SQL Database Step by Step",

            Properties = new Dictionary<string, object>
            {
                {"k1","v1"},
                {"k2","v2"}
            }
        },
        new Book
        {
            ISBN = "978-0-7356-8383-9",
            Title = "SignalR",
            Press = new Press
            {
                Name = "Microsoft Press",
                Category = Category.Book
            },
            Properties = new Dictionary<string, object>
            {
                {"k1","v1"}
            }
        }
    };

    [EnableQuery]
    public IQueryable<Book> Get()
    {
        return _books.AsQueryable();
    }
}

当在动态属性上使用$select时，对于那些不包含该属性的对象，结果包含许多空对象。让我们假设在这个例子中，如果查询是http://localhost:58020/Books?$select=K2，我得到的响应是：

{
  @odata.context: "http://localhost:58020/$metadata#Books(k2)",
  value: [
   {
      k2: "v2"
   },
   { }
  ]
}

如果您观察到它包含不包含k2属性的图书的空大括号，则会发现它包含一个空大括号。如何摆脱这种行为？

Answer 1

这就是字典的问题。您可以做的是创建一个名为Parameter的新类，并使用如下所示的List<Parameter>代替Dictionary<String, object>：

class Parameter {
    public String Key;
    public Object Value;
}

修改后的代码：

public class Book
{
    [Key]
    public string ISBN { get; set; }
    public string Title { get; set; }
    public Press Press { get; set; }
    public List<Parameter> Properties { get; set; }
}
public class BooksController : ODataController
{
    private IList<Book> _books = new List<Book>
    {
        new Book
        {
            ISBN = "978-0-7356-7942-9",
            Title = "Microsoft Azure SQL Database Step by Step",

            Properties = new List<Parameter>
            {
                new Parameter { Key = "k1", Value = "v1" },
                new Parameter { Key = "k2", Value = "v2" }
            }
        },
        new Book
        {
            ISBN = "978-0-7356-8383-9",
            Title = "SignalR",
            Press = new Press
            {
                Name = "Microsoft Press",
                Category = Category.Book
            },
            Properties = new List<Parameter>
            {
                new Parameter { Key = "k1", Value = "v1" }
            }
        }
    };

    [EnableQuery]
    public IQueryable<Book> Get()
    {
        return _books.AsQueryable();
    }
}