Database

productname  status

pepsi        true
miranda      false
coke         false
fanta        true

select a.productname, status = case b.product_id 
when 1 then 'True' else 'False' 
when 2 then 'True' else 'False' 
when 3 then 'True' else 'False' 
when 4 then 'True' else 'False' end
from products a, agent b where a.productid = b.productid and agentid ='1001'

public things[] GetMyThings( Guid myIdentity )
{
   using ( MyContext context = new MyContext( connectionString ) )
   {
        var mt = from t in context.ThingTable
            where t.Identity == myIdentity
            select t;
        return mt.ToArray();
   }
}*