Possible to do Entity Transactions for "selects"?

Question

I have an array of PK RK pairs that I'd like to retrieve in a single operation.  I'm aware that I can't span Partitions within a query so I'm trying to determine if it's more efficient to select 100 records individually or a query like this:

//Pretend there are 50 to 100 "rk"'s here

var results = from c in _ServiceContext.ForumThreadCollectionTable
                          where (((c.RowKey == rk1) || (c.RowKey == rk2) || (c.RowKey == rk3) |(c.RowKey == rk4)) && c.PartitionKey == pk)
                          select c;

 

Answer 1

Regarding the ORs you might want to read Jai Haridas' post on this Azure Forum thread.