How to read Azure table all rows in table entity

Question

I have Azure table entity where I have queryResult with Partition Key, RowKey, Etag and Properties. I am trying to read Properties contains my table columns. But I am facing issue in reading the Properties using LINQ or tried to loop Properties and again I have to loop Properties as its contains My table columns... referred some samples which are telling to use table.ExecuteQuery(query);

But I am getting response contains 4 values and Properties contains my actual columns data.... any help really appreciated.

        Public class MyEntityModel : TableEntity
        {
             MyEntityModel (){}
                MyEnityModel(string Category, string Id){
                    PartitionKey=Category;
                    RowKey= Id;
              }

              Public string leaveCount{ get;set;}
              Public string leaveReason{get;set;}
         }

    TableQuery<DynamicTableEntity> query=new 
    TableQuery<DynamicTableEntity>();
     Var result = table.ExecuteQuerySegmented(query,token)
    Var entityItems=result.Results;
    Var propsItems=entityItems.Select(x=>x Properties). ToList();

Even if I am providing my entity model to query like

    TableQuery <MyEntityModel> query = new TableQuery();

I am getting data with Partition key and RowKey value, but Properties (entity column values) is null.

Thanks for sharing the code. Can you edit it one more time and include the properties of your entity. — Gaurav Mantri, Dec 21 '21 at 16:07

Mahee19 · Answer 1 · 2021-12-22T12:41:33.483

0

We can use EntityPropertConverter to get the Properties details like below

var myAzureColumnData = EntityPropertyConverter.ConvertBack<MyEntityModel>(Properties,  new OperationContext());

This give me the column values.

We can also do like this

 Var result = table.ExecuteQuery(new TableQuery<MyEntityModel>());

This will create a object with the values....

edited Dec 22 '21 at 12:41

answered Dec 22 '21 at 08:26

Mahee19

21
4

score 0 · Answer 2 · answered Aug 10 '22 at 12:58

using System;
using System.Collections.Generic;
using Azure.Data.Tables;
using System.Linq;  
using Azure;
     
public async Task<IEnumerable<T>> ListAsync(String? filter = null)
            {
                var table = new TableClient(_tableEndpointUri);
                var result = new List<T>();
                AsyncPageable<T> queryResultsMaxPerPage = table.QueryAsync<T>(filter: filter, maxPerPage: 100);
                
                await foreach (Page<T> page in queryResultsMaxPerPage.AsPages())
                {
                    result.AddRange(page.Values);
                }
    
                return result.AsEnumerable();
            }

score 0 · Answer 3 · answered Sep 19 '22 at 11:21

In WATS DynamicTableEntity is a TableEntity with an internal properties bag so by all means you are getting the correct response. If you want to "unwrap them" then query against MyEntityModel not DynamicTableEntity.

I had to decompile the source when I migrated off of WATS to Azure.Data.Tables, happy coding.

How to read Azure table all rows in table entity

3 Answers3