crestinul:

var datacontext=new SomedataContext() var query=from cont in datacontext.FIsacont let sold=(mdatacontext.FisaCont.where(x=>x.cont==cont.cont && Sqlmethods.DateDiff(x.DataInnr,cont.Datanr) ...&& x.coduser==1).sum(x=>x.debit-x.Credit) where fc.coduser==1 order by cont.cont,cont.datainr,cont.NDS select new {clasa=cont.cont(subbstring(0,1),subclasa=cont.cont(subbstring(0,2),sold??0,ssold=cont.debit-cont-credit...} foreach(var item in query) Console.writeln(item)