what is the equivalent linq query for the following sql query?

[Dhyanga]

string qryInterviews = "SELECT ID, UpdatedByAdmin, UpdatedBy,Deleted " +
"CASE UpdatedByAdmin WHEN 1 THEN Date1 ELSE TimesForDate1 END AS D1, " +
"CASE UpdatedByAdmin WHEN 1 THEN Date2 ELSE TimesForDate2 END AS D2, " +
"CASE UpdatedByAdmin WHEN 1 THEN Date3 ELSE TimesForDate3 END AS D3, " +

"FROM myTable where (Deleted is null OR Deleted = 0)";

In the above query, UpdatedByAdmin,Deleted are of tinyInt datatype. Please help.

Dhyanga

[PIEBALDconsult]

That doesn't even look like valid SQL.

[Dhyanga]

this is the currently running query in my project. I don't know how columnname with tinyInt datatype be compared to any given value in the case statement in linq.

Dhyanga

[Dhyanga]

var query = (from sub in db.myTable
where (sub.Deleted == null || sub.Deleted == 0)
select new
{
sub.ID,
sub.UpdatedByAdmin,
sub.UpdatedBy,
sub.Deleted,
D1 = sub.UpdatedByAdmin.Equals(true ? sub.Date1 : sub.TimesForDate1),
D2 = sub.UpdatedByAdmin.Equals(true ? sub.Date2 : sub.TimesForDate2),
D3 = sub.UpdatedByAdmin.Equals(true ? sub.Date3 : sub.TimesForDate3)

                         }).ToList();

But this is giving error message as:

System.ArgumentException: DbComparisonExpression requires arguments with comparable types.

I think its because my UpdatedByAdmin, Deleted columns are tinyInt datatype in the database. But When i used these fields in model class, i used byte datatype. I thought byte is equivalent to tinyInt. Please help.

Dhyanga

[PIEBALDconsult]

Dhyanga wrote:

I thought byte is equivalent to tinyInt.

It is, but SQL tends to be more forgiving than C#.

[Lost User]

In this case, the query is more readable than the LINQ version. Secondly, this query executes on the server. What use does changing it to LINQ have?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Dhyanga]

I am trying to implement entity framework to that project..

Dhyanga