How to use SQL ‘LIKE’ with LINQ to Entities? [duplicate]

by

http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/6529a35b-6629-44fb-8ea4-3a44d232d6b9/

var people = entities.People.Where("it.Name LIKE @searchTerm", new ObjectParameter("searchTerm", searchTerm));

More Related Contents:

  1. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  2. Calling a SQL User-defined function in a LINQ query
  3. Search SQL by date ASP.NET
  4. I want to insert a record in DB and then need to return a row
  5. How can I add user-supplied input to an SQL statement?
  6. How to get last inserted id?
  7. What is the syntax for an inner join in LINQ to SQL?
  8. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  9. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  10. ‘Contains()’ workaround using Linq to Entities?
  11. Method cannot be translated into a store expression
  12. C# SQL Server – Passing a list to a stored procedure
  13. linq case statement
  14. How can I log the generated SQL from DbContext.SaveChanges() in my Program? [duplicate]
  15. SQL WHERE clause matching values with trailing spaces
  16. Equivalent of SQL ISNULL in LINQ?
  17. SqlBulkCopy from a List
  18. How to fill Dataset with multiple tables?
  19. SqlConnection.Close() inside using statement
  20. Passing a SQL parameter to an IN() clause using typed datasets in .NET
  21. How do I perform Date Comparison in EF query?
  22. ASP.NET ODBC Query with parameters
  23. The variable name ‘@’ has already been declared. Variable names must be unique within a query batch or stored procedure
  24. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  25. How to create NVarchar(max) Sqlparameter in C#? [duplicate]
  26. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  27. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  28. Stored procedure returns int instead of result set
  29. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  30. SQL connection string for microsoft access 2010 .accdb

Leave a Comment