Database

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();

System.ArgumentException: DbComparisonExpression requires arguments with comparable types.

Dhyanga wrote:

I thought byte is equivalent to tinyInt.

Ibrahim.elh wrote:

what you proposed?

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

SELECT *
FROM
(
SELECT * FROM   #TABLEA A 
UNION ALL
SELECT * FROM   #TABLEC C 
)t   
WHERE LIS_KEY  = '047600055/R'

• Product the Cartesian Product of the two tables - each row in the left-hand table is matched with each row in the right-hand table.
• Remove the rows where the JOIN condition is not met.
• Depending on the JOIN type:
  
  
  • INNER JOIN: Nothing to do.
  • LEFT (OUTER) JOIN: Any rows in the left-hand table but not in the results are added back, matched with a row of NULL values for the right-hand table.
  • RIGHT (OUTER) JOIN:: Any rows in the right-hand table but not in the results are added back, matched with a row of NULL values for the left-hand table.
  • FULL (OUTER) JOIN: Apply the rules for both LEFT and RIGHT joins.
• Filter the result based on the conditions in the WHERE clause (if any).

JM76 wrote:

Internet explorer can't find the web page

JM76 wrote:

The problem is the browser, Internet explorer can't find the web page.

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