What's the best approach for reading data from external SQL database?
- build web services and call it in web part
- using ado.net and read data directly in web part
- using external list and read data from external list in web part.
I have a table with 1000000 records in SQL database