I am trying to create a custom web part in SharePoint 2013 that connects to a SQL 2012 database.
I have gone as far as I can with the SharePoint BDC to connect to the external data. I am not able to use as a solution to create, update the remaining tables.
The tables I need to present and update have many to many relationships. Has anyone successfully done something like this in SharePoint. If so can you please share.
Or can someone point me to some good documentation/sample of setting up the database connection in Visual Studio custom web part project.