Database

class Person
{
   string Name{get;set;}
   IEnumerable<CustomProperty> CustomProperties {get;set;}
}

class CustomProperty
{
   string Name{get;set;}
   string Value{get;set;}
}

companies.First(cmpn=>cmpn.Name="Netflix").Employees.Avg(empl=>empl.Sal)

select * from companies join company_employess on ... join ... group by.. avg

hi , 
i have a list of id values ( listOfProducts ) returned from a dropdown list , i need to use them to filter in a sql request



something like this :

SELECT stock_id , loc_id

FROM S_ware D

WHERE D.product_id IN (listOfProducts) (not sure about that)



i need to get all the records that have a product id that is contained inside the list from the dropdown

thanks

select isnull([1], 0) as Janeiro,
       isnull([2], 0) as Fevereiro,
	   isnull([3], 0) as Março,
	   isnull([4], 0) as Abril,
	   isnull([5], 0) as Maio,
	   isnull([6], 0) as Junho,
	   isnull([7], 0) as Julho,
	   isnull([8], 0) as Agosto,
	   isnull([9], 0) as Setembro,
	   isnull([10], 0) as Outubro,
	   isnull([11], 0) as Novembro,
	   isnull([12], 0) as Dezembro
from (select month(PP.PAPA_DT_DATAPAGAMENTO) as Mesn, PP.PAPA_RE_VALORPAGAMENTO from PAGAMENTO_PARCELA PP, PAGAMENTO P
     where PP.MOVI_NA_CODIGO = P.MOVI_NA_CODIGO AND P.SUPA_NA_CODIGO = 5) Tab1
pivot (sum(PAPA_RE_VALORPAGAMENTO) for Mesn in ([1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12])) P1