Code: Select all
var x = (from t in context.table
where t.column.startsWith("MyString")
select t);
sql
select t.* from table t where t.column like 'MyString%'
But what if I want to have a sql command that results in
Code: Select all
select t.* from table t where t.column like 'My%String'