View Complete Post
I used the Secure Store to create connection in SharePoint 2010 Designer External Content Types Data Source Explorer. Later I changed some column names in the table.
I deleted the connection from Data Source Explorer and recreated it. I right clicked on the table and selected Create All Operations. When I clicked the Finish button, I got "The system definition with the same name as this data source already exists in the
Business Data Connectivity Metadata Store and it refers to a different data source. Cannot complete operation generation. Add a connection to this data source with a different name and try again."
I re-created the Secure Store using a different name in SharePoint 2010 Central Administration. I didn't find the option to choose the connection name in SharePoint 2010
Designer. After I clicked Add Connection, I entered the Database Server and the Database Name, selected Connect with Impersonated Window Identity, entered Secure Store name, and clicked OK. The connection created with the database name as before.
Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.