Post by RQ1 on Mar 14, 2011 8:08:46 GMT -5
Hello,
i have a little Problem with Linqer. I want to convert a SQL-Statement to VB.NET (LINQ to Entities)
The Problem is: If I execute the VB statement the Result is wrong, but with the C# LINQ the result is right
My SQL-Statement
Why does the VB-Statement reutrn a other result then the C#-Statement ?
i have a little Problem with Linqer. I want to convert a SQL-Statement to VB.NET (LINQ to Entities)
The Problem is: If I execute the VB statement the Result is wrong, but with the C# LINQ the result is right
My SQL-Statement
Select b.Referat, COUNT(u.FK_StateID) as Gesamt,
sum(case when u.FK_StateID in (0,3) then 1 else 0 end) as [ErledigtGesamt],
sum(case when u.FK_StateID not in (0,3) then 1 else 0 end) as [OffenGesamt],
sum(case when u.GenerationsID in (1) then 1 else 0 end) as [GesamtPeriode],
sum(case when u.FK_StateID in (0,3) and u.GenerationsID in (1) then 1 else 0 end) as [ErledigtPeriode],
sum(case when u.FK_StateID not in (0,3) and u.GenerationsID in (1) then 1 else 0 end) as [OffenPeriode]
from tbl_baseData b
inner join tbl_userData u
on b.BaseID = u.FK_BaseID
group by b.ReferatWhy does the VB-Statement reutrn a other result then the C#-Statement ?
