linq_functions_4.cs

StringBuilder query = new StringBuilder($";With fullTable as (select b.[Id],[BusinessName], ");

// manipulate data
query.Append($"CAST(CASE WHEN COUNT(service.BusinessId)>0 THEN 1 ELSE 0 END AS bit) as servicesFlag")
 
 query.Append($" from [DB].[Businesses] b ");
 
// add data to table that is needed for line 2 to execute properly
query.Append($"LEFT JOIN [DB].Services service ON service.BusinessId = b.Id ");
 
Data = db.Businesses.FromSqlRaw(query.ToString()).ToArray();