You are designing a SharePoint 2010 application that displays information from an external database. You need
to develop the application to meet the following requirements:
Remote connections to the external database are not allowed.
.Data from multiple tables must be joined into a single list.
.The list must be synchronized with the external database.
Which approach should you recommend?
A.
Build a Web service to manage each table, and use the SPQuery object to join the data fields into a single list.
B.
Build a Web service to manage each table, use Business Connectivity Services (BCS) to import the individual tables into lists, and then create a new list that joins these external lists together.
C.
Build a Web service to join the data fields into a single list, and use BCS to synchronize the list with the external database.
D.
Build a Web service to join the data fields into a single list, and implement event receivers to synchronize the list with the external database.