Skip to content

Instantly share code, notes, and snippets.

@samirbehara-zz

samirbehara-zz/Trim in Entity Framework

Created October 15, 2017 11:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samirbehara-zz/acf513bee53d448f896195b6601577c8 to your computer and use it in GitHub Desktop.
Save samirbehara-zz/acf513bee53d448f896195b6601577c8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Trim in Entity Framework
// Entity Framework Query
_context.Titles.Where (t => t.ListCode.Trim() == buildTitle.ListCode)
// Corresponding Query fired against SQL Server
DECLARE @p0 VarChar(3) = 'BO'
SELECT [t0].[Titlecode], [t0].[ZLineNumber]
FROM [Titles] AS [t0]
WHERE LTRIM(RTRIM([t0].[ListCode])) = @p0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment