I recently posted a query here that asked about the best way of connecting to an external SQL store.
I got some great responses back but need a little more info, specifically around External Content Types. We are basically looking to replace several custom Web parts that query SQL stored procedures and views and display results in an SPGridView.
Reading through this article, I understand that I can create entities using Visual Studio. However, I am not sure how reusable these are.
In all cases we need to filter results based on unique IDs (e.g. a ClientID).
Parameters for the query should be set upon SPWeb creation.
We need to be able to specify the relevant External List in our various Web templates.
Currently we achieve the above using custom Web part properties and Web services, meaning that there is a lot of work involved during upgrades.
Is BCS the answer to this problem?
Many thanks in advance.