In visual studio we are creating one project and implement some functionality. Then we are deploying in bin folder we can get .wsp file.
So the same functionality need for our client or other system means we should deploy the .wsp on client system.so the same functionality will work on client system.
Now my doubt is that how we can implement External content type?
For example in my system I have created one database in SQL server,In SharePoint designer I have created External Content type.Then the SQL data are display in SharePoint List.
This same functionality I need to implement in client system.But I don't want to do this manually, how we can implement it via code?
How we can install .wsp in client system same functionality work on client system like that? how can we achieve this External Content type Functionality using c# or power shell or REST API and any other script language.
How we can get client system SQL database through code and how we can show database details in SharePoint list ?
What I need is how to Create BCS service application programmatically?
I searched in google but every article is in SharePoint designer only they are creating external content type. please someone give some idea for this.
In central admin I need to add BDC programmatically.
When I will create external list in select external content type I will add SQL Database from client system.