asp.net-core-mvc - 从表中获取选定列的列表数据

Question

我想从表中获取选定列的数据并在存储库类中返回该数据。但是我的查询没有返回任何数据。

我的代码是：

 public  IQueryable<BusinessProfile> GetBusinessProfileAddress()
    {

        var y = _db.Set<BusinessProfile>().Where(x => x.Deleted == false).Select(x => new
        {
            x.ID,
            x.Address.StreetName,
            x.Address.Number,
            x.Address.Complement,
            x.Address.PostalCode,
            x.Address.Neighborhood,
            x.Address.City,
            x.Address.State
        });
        var d=from a in BusinessProfile select a. 

        return  y; ;
    }

注意：这里的“return y”是显示错误。

标签： asp.net-core-mvcentity-framework-core

Answer 1

此代码甚至不会构建，因为您还没有完成此查询：var d=from a in BusinessProfile select a.但是，您根本没有使用该d变量，因此您应该删除整var d=from a in BusinessProfile select a.行。而且你不需要 2 之后的分号y。因此，您的代码应如下所示：

public IQueryable GetBusinessProfileAddress() {

    var y = _db.Set<BusinessProfile>().Where(x => x.Deleted == false).Select(x => new
    {
        x.ID,
        x.Address.StreetName,
        x.Address.Number,
        x.Address.Complement,
        x.Address.PostalCode,
        x.Address.Neighborhood,
        x.Address.City,
        x.Address.State
    });

    return  y;
}