I am trying to add a table from a SQL database as an external content type. When I do so I am getting the following error:
The database table has 188 columns (I did not design this legacy system. I am shocked myself how big that is).
Is there a way I can get BCS to connect to it? I am connecting via SPD would using VS make any difference?
If not I will need to look at creating my own data layer and access the content in a custom web part.