Sorry if this question does not sounds well but the thing is that we have a huge database and we need to speed up the process of a particular query. The query displays the 'Project Numbers' for specific users. This operation takes 51 secs everytime but if we remove the 'Like's it displays a big list in just 3 secs. so what I am thinking to do is to use the second query and make the filter 'in memory' to display the projects filtered to the user.
The question is... how can I query the memory? Can you point an example? somebody told me Linq cna be the best choice for C# but I dont know Linq.
Can you help me with an example?