SharePoint 2010: Aggregating Data Using BCS and .NET Assemblies
Create and use a .NET Framework assembly with Business Connectivity Services in SharePoint Server 2010 to aggregate data from two external systems: a SQL Server database and a SharePoint document library. Use external content types to display the data in SharePoint and learn ways