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();
   }
}*

ID   MAX_CALENDAR_DAY
 1              14833
 2              14840
...

SELECT WORKCENTER.ID AS WORKCENTER_ID, MAX_CALENDAR_DAY
FROM WORKCENTER,
    (SELECT MAX(DAY) AS MAX_CALENDAR_DAY
     FROM (SELECT DAY
           FROM CALENDAR
           WHERE DAY > TRUNC(TO_NUMBER(SYSDATE - TO_DATE('01.01.1970', 'DD.MM.YYYY')))
           WHERE CALENDAR.IS_WORKING_DAY= 'y'
           ORDER BY CALENDAR.DAY
          )
     WHERE ROWNUM <= WORKCENTER.NR_OF_DAYS
    )
WHERE WORKCENTER.ID IN ( 1, 2, 6, 7, 9)