How about this line of code
var Obj = context.MediaCategories.Select(c => "ABC".Substring(1) !=
null).ToList();
It produces
SELECT
CASE WHEN (Substring('ABC', 1 + 1, (LENGTH('ABC')) - 1) IS NOT NULL) THEN 1
WHEN (Substring('ABC', 1 + 1, (LENGTH('ABC')) - 1) IS NULL) THEN 0 END AS [C1]
FROM [MediaCategories] AS [Extent1]
-- Executing at 29/05/2015 9:17:06 PM -05:00
SQLite error (1): no such function: Substring
-- Failed in 89 ms with error: SQL logic error or missing database
no such function: Substring
