Filtering by int field in serilog table from Azure Data Table

Question

Hi have one new property in serilog table in Azure Storage Table and i want to filter by it on my solution, i try apply some filter options but with no sucess, with this i get all records from table:

var records = table.ExecuteQuery(new TableQuery<MyTableDTO>()).ToList();

In records i receive a list of array with my field "accountID". How i can apply filters in executequery in my .net-mvc solution? My last try:

var queryfiltered = TableQuery.GenerateFilterConditionForInt("AccountID", QueryComparisons.Equal, accountID);

Answer 1

Congratulations that you solve the issue:

Solved with linq:

var queryfiltered = mytable.ExecuteQuery(new TableQuery<TableDTO>()).Where(k=>k.myField==myField);

I help you post is answer and this can be beneficial to other community members.