Monday, December 06, 2010 10:10 AM
I am trying to create External content type. I have 2 tables in SQL database. Table1 contains the columns like - StudentId, Student Name.
Table2 contains columns like - CountryId(primary key) , StudentId, CountryName.
Is it possible to create external content type based on these 2 tables? How to achieve this?
Monday, December 06, 2010 5:11 PM
It is possible to achieve this. You have to create an External Content Type in Visual Sutdio 2010.
There you can specify the SQL commands for the CRUD operations you perform on the external list created from the ECT.