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