Datatable select query not giving correct result

[ClaytonM]

@siszack

I still wonder why the select method is not reliable in this case. So is it safe to say we always use linq rather than going for Select. May @ClaytonM can help shed some ideas.

I think the syntax for a Select query is more difficult to understand and use, whereas LINQ syntax allows you to use .net to create complex conditions, something that is typically needed for robust development.

However, on the other hand, Select queries are in the form of a string. Therefore, you can use variables and create your query string more dynamically. So there is a benefit. - for example, you can store your query string condition in an external configuration file if you wanted to.

I think both “can be” reliable, but just LINQ is easier to learn and use.