How to query using TableQuery via IEnumerable?

Question

I am exposing my Table via the following method:

public static class TableCacheService
{
    public static IEnumerable<Myentity> Read()
    {
        var acc = new CloudStorageAccount(
                     new StorageCredentials("account", "mypass"), false);
        var tableClient = acc.CreateCloudTableClient();
        var table = tableClient.GetTableReference("Myentity");
        return table.ExecuteQuery(new TableQuery<Myentity>());
    }
}

Here's a usage example:

    var nodeHasValue = TableCacheService.Read()
                                        .Where(x => note.ToLower().Contains(x.RowKey.ToLower()))
                                        .Any();

But supposedly x.RowKey is null!

It looks like there are 2 members both called RowKey. One of them is a TableEntity:

How do I access the RowKey that is non-null? Am I incorrectly querying the table?

Could you provide source code for `Myentity` class? – Alexander I. Sep 05 '18 at 20:47 — Alexander I., Sep 05 '18 at 20:47
@AlexanderI. you were EXACTLY right – Alex Gordon Sep 05 '18 at 21:49 — Alex Gordon, Sep 05 '18 at 21:49

score 1 · Accepted Answer · answered Sep 05 '18 at 20:59

It seems you have hiding properties RowKey and PartitionKey inside your Myentity class.

I guess your Myentity class has something like it:

public class Myentity: TableEntity
{
    public new string RowKey { get; set; }
    ...
}

Pay attention to keyword new.

If you have this construction you need to delete this property.

More information about hiding and overriding you can find here.

Also please review work example with ATS (Azure Table Storage) is here.

How to query using TableQuery via IEnumerable?

1 Answers1