Re: [Firebird-net-provider] How can I use % inside of a contatins string?

2010-08-21 Thread Jiri Cincura
On Sat, Aug 21, 2010 at 16:56, Marco Castro wrote: > Hello, > > I'm trying this code in a LINQ statement in the last version of the > provider (August 16): > > ...where cl.ClientName.ToUpper().Contains("MARC%SMI") > > The generated SQL code is this: > > ...WHERE UPPER("Extent1"."CL

[Firebird-net-provider] How can I use % inside of a contatins string?

2010-08-21 Thread Marco Castro
Hello, I'm trying this code in a LINQ statement in the last version of the provider (August 16): ...where cl.ClientName.ToUpper().Contains("MARC%SMI") The generated SQL code is this: ...WHERE UPPER("Extent1"."CLIENTNAME") LIKE _UTF8'%MARC\%VIEI%' ESCAPE _UTF8'\' In my