Saturday, February 5, 2011

LIKE operation with LINQ and SQL

LIKE operator is a very useful and the most frequently used operator in SQL, with the advent of linq, we started to use linq more than SQL, i.e. small filtering is now done in code rather than going back to DB,  but the lack of proper LIKE operator is a bad aspect, per my research, in order to have a proper LIKE operator, we need to call the SQL Client and then use its functionality through linq and many suggest not to do it.

Hope Microsoft deals with small things too. Sad smile

However, I don’t know if it is Good for MIcrosoft to give the same functionality with “Contains” method Smile with tongue out,  Yes, that is correct, the like can be fully implemented with the help of Contains method.

MS Rocks some times.

No comments:

Post a Comment