Associate 2 tables and create external content type

Question

Hi,

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?

Thank you

Answer 1

Hi

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.

http://www.google.co.in/url?sa=t&source=web&cd=2&ved=0CBwQFjAB&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F0%2F7%2FC%2F07C0BDB4-8DEC-404B-89E9-27A439805572%2FHOL6_Manual_cs.pdf&rct=j&q=create%20External%20Content%20Type%20in%20Visual%20Studio%202010&ei=XRj9TMT8Ao_jrAes8-jwBw&usg=AFQjCNHth8MO5J56crQCIIn8e5IRnkbjBA&cad=rja