M Miriam Nogueria Sep 9, 2009 #1 Hi, how i can make a Like ( as TSQL ) in Lambda ? I was searching but i couldn´t find it. TIA
A Alberto Poblacion Sep 9, 2009 #2 Miriam Nogueria said: Hi, how i can make a Like ( as TSQL ) in Lambda ? I was searching but i couldn´t find it. Click to expand... You mean a LINQ query, not a Lamda, right? It's not exactly the same as a Like, but if you write a query like this: from c in dc.Table where c.Field.StartsWith("abc") ... then it will be automatically translated into a LIKE when it is sent to the server: Select ... from Table Where Field LIKE 'abc%' ...
Miriam Nogueria said: Hi, how i can make a Like ( as TSQL ) in Lambda ? I was searching but i couldn´t find it. Click to expand... You mean a LINQ query, not a Lamda, right? It's not exactly the same as a Like, but if you write a query like this: from c in dc.Table where c.Field.StartsWith("abc") ... then it will be automatically translated into a LIKE when it is sent to the server: Select ... from Table Where Field LIKE 'abc%' ...
M Miriam Nogueria Sep 9, 2009 #3 you are right, thanks Alberto. Alberto Poblacion said: You mean a LINQ query, not a Lamda, right? It's not exactly the same as a Like, but if you write a query like this: from c in dc.Table where c.Field.StartsWith("abc") ... then it will be automatically translated into a LIKE when it is sent to the server: Select ... from Table Where Field LIKE 'abc%' ... Click to expand...
you are right, thanks Alberto. Alberto Poblacion said: You mean a LINQ query, not a Lamda, right? It's not exactly the same as a Like, but if you write a query like this: from c in dc.Table where c.Field.StartsWith("abc") ... then it will be automatically translated into a LIKE when it is sent to the server: Select ... from Table Where Field LIKE 'abc%' ... Click to expand...
