c# - 获取 "Could not find an implementation of the query pattern for source type ' ExcelQueryable'. "错误

Question

我正在使用 LinqToExcel Nuget 包来读取 excel 文件。

下面是我的代码

            var excelFile = new ExcelQueryFactory("DeployQueues");

        var tableData = from z in excelFile.Worksheet<AllQueues>("Data")
                        select z;

但我遇到以下编译器错误。

Could not find an implementation of the query pattern for source type 
'ExcelQueryable<AllQueues>

class for AllQueues

 public class AllQueues 
 {
    [ExcelColumn("Company Title")] 
    public string Name { get; set; }

    [ExcelColumn("Providence")] 
    public string State { get; set; }

    [ExcelColumn("Employee Count")] 
    public string Employees { get; set; }

 }

Answer 1

添加引用 Remotion.Data.Linq.dll。你可以在 Nuget 中找到它；

https://staging.nuget.org/packages/Remotion.Data.Linq/