asp.netgridviewsql-likeentitydatasourceentity-sql

like operator in entitydatasource

I'm using an EntityDataSource in an asp .net form and a Gridview is bound to it. A where clause is used in the entityDataSource:

Where="it.Name like '%@Name%'

@Name is a parameter:

<WhereParameters>
<asp:ControlParameter ControlID="TextBox1" Name="Name" PropertyName="Text" Type="String"  />
</WhereParameters>

But it doesn't work. When I change @Name with a fixed string it works properly, like this:

Where="it.Name like '%ppp%'"
Solution 
  • Where="it.Name like '%' + @Name+ '%'"