Jan 07, 2015 04:21 PM|ayanmesut|LINK
I have a Query which gives the companies. But I need to list the companies with ONLY Video. If the Video field is NOT EMPTY OR NOT NULL, it must be listed.
So for I used IsNullOrEmpty, but I want to get rid of that.
Here is the my code:
var comps2 = data.Query("SELECT CompanyID, CompanyName, Visited, Video FROM Companies ORDER BY Visited DESC").ToList();
How can I do that only using Query (with WHERE clause) without IF code.
Thanx in advance!