I'm using SharePoint 2013 and I'm developing a webpart that has to query an external data and show the results. I cannot create external list due to the fact that my external table has more than 200,000 records.
What I'm looking for is to query this data source without creating an external list using BCS.
Am I on the right way at all ?
How can I achieve this ?