I have three database tables
1. Category(Id, Name)
2. Definitions( ID, Modified, CatergoryID)
3. Versions (ID, Name, Template, DefinitionID)
I have generted Entity Data Model (EDM). It has generated 3 entities
1. Category
Scalar Properties
ID
Name
Navigation Properties
Definitions
2. Definition
Scalar Properties
ID
Modified
Navigation Properties
Category
3. Version
Scalar Properties
ID
Name
Template
Navigation Properties
Definitions
I want to get All versions and show on a gridview grouping by Category.
How I can complete this task using EntityDatasource and also give me clue to bind gridview using Ajax Accordion Please.