Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 11th, 2012  |  syntax: None  |  size: 0.59 KB  |  hits: 6  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. EF 4.0 Linq generates weird query when using string.contains with a variable instead of hard coded string
  2. var query = context.Set.Where(o => o.Email.Contains("Mail@gmail.com"));
  3. var stringQuery = ((System.Data.Objects.ObjectQuery)query).ToTraceString();
  4.        
  5. SELECT *
  6. FROM [SET] AS [Extent1]
  7. WHERE [Extent1].[Email] LIKE '%Mail@gmail.com%'
  8.        
  9. string email = "Mail@gmail.com";
  10. var query = context.Set.Where(o => o.Email.Contains(email));
  11. var stringQuery = ((System.Data.Objects.ObjectQuery)query).ToTraceString();
  12.        
  13. SELECT *
  14. FROM [Set] AS [Extent1]
  15. WHERE [Extent1].[Email] LIKE @p__linq__0 ESCAPE N'~'