Translation of Contains on byte arrays

Translation of Contains on byte arrays

Queries using Contains on byte[] properties are now translated to SQL.
1
var blogs = context.Blogs.Where(e => e.Picture.Contains((byte)127)).ToList();
Copied!
Translates to the following on SQL Server:
1
info: 12/5/2019 11:42:42.022 RelationalEventId.CommandExecuted[20101] (Microsoft.EntityFrameworkCore.Database.Command)
2
Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
3
SELECT [b].[Id], [b].[Picture], [b].[Title]
4
FROM [Blogs] AS [b]
5
WHERE CHARINDEX(0x7F, [b].[Picture]) > 0
Copied!
Last modified 2mo ago