Sybase LINQ filtering by Year and Month

[FcabralJ]

I have one query which read all different years / months from the DB which will be used after for querying the DB in parallel as following:




var splitQuery = (from pv in dbLinq.Table
group pv by new {

pv.Date.Year,

pv.Date.Month

} into dates
select dates.Key)

.ToList();

splitQuery.AsParallel().ForAll(pvChunks =>{
var query = (from pv in dbLinq.PricesViews
where (pv.Date.Year == pvChunks.Year && pv.Date.Month == pvChunks.Month)
select pv)
.ToList();
});

In the second query I'm getting the following error: Sybase.Data.AseClient.AseException: 'Internal Error'

Continue reading...