var users = db.Users.Where(x => x.Name.Contains("T"))

SELECT 
    [Extent1].[Id] AS [Id], 
    [Extent1].[Name] AS [Name], 
    [Extent1].[Age] AS [Age]
    FROM [dbo].[Users] AS [Extent1]
    WHERE [Extent1].[Name] LIKE N'%T%'