BCS, Business Connectivity Service, using BCS we can connect to external databases and can display data in SharePoint list. Databases are may be SQL,MySQL, Oracle or some other. We can connect to the any external database and fetch the data. Not only displaying we can also add new records, update records and delete records.
Here i want try to show BCS operations using MySQL database.
I have one table i.e employee and it has 3 columns.
2. Now open visual studio 2010, Create new project.
3. In the left panel Select SharePoint --> 2010, select Business Data Connectivity Model from the right side panel.
11. Now open EmployeeService.cs file and delete all methods and make sure that it looks like this.
And also set identifier to Empid.
Click on Business Data Connectivity Services from the list of Services.
Assign User and give permission to that user. here am taking administrator and assign all permission to single user.
That's it. Now we can connect and fetch data from any database in SharePoint using BDC Model.
Thanks to all.