I want SQL query equivalent in EF Core Lambda, to get an extra column as either true or false, based on some substring(in this case DEALER) if present in other column's data of the same table.

myTable
     Id                        col1
     1              I have substring - DEALER
     2              I do not have any substring 

I need the output as

Id,                IsDealer
1,                  true   
2,                  false   

I tried the following SQL query,

SELECT [Id] , 
CASE WHEN [col1] LIKE '