How to handle limitations in SharePoint 2010 BCS when working with large data

In SharePoint 2010 when connecting with large data, it will give you error because throttling limit is set and default is 2000,
however this is also configurable using Powershell, but this is also not the solution and also not going to fit in all
scenario, when someone want to display 20 records in a web part and BCS isĀ  fetching all the record.

This can be handled using object model by invoking BDC Metadata Method Instance and by passing input parameter
and this input parameter can be used to filter the number of record to display.

By using this approach it become quiet handy to full control over the method to execute and input parameter can
be set dynamically which can passed to Stored Procedure /or Custom method where these input
parameter can be used to limit the number of records to display ….

How to create BDC Application Definition

In this section I will describe how to create BDC Application definition
with Database and Services (Web/WCF) for Search

Create two method in WCF Services .

1. Connect to Web/WCF Services

1. Create two method in WCF Services
1.1 GetDetaiByID ->Specific Finder
1.2 GetAllId ->IdEnumerator

2.Go to Application Definition Editor AddLOB System
4.Enter WCF services
5.Keep only one Entity and remove other one
6.Go to Method add 1.1 and 1.2 Method
7.Method instance Return Type Descriptor should be of Return both in IdEnumerator and
8.Add Action and select appropriate Field for viewing Profile

9. Now right click action and click Execute
Error: Could not find appropriate place on the root TypeDescriptor to read
sub-identifier value for the Instances of Entity…

10.Go to shecific Finder Method Return node and set Identifier
1. In specific finder Filters change WildCharacter to equal
2. Action is required to create profile in sharepoint to view the detail
3. Double check Identifiers in Methods–>Parameters