In Embedded SQL we could write a Join SQL query and get the desired results from two or more table in one go.
But in ADO.Net , we create a dataset for two table and define a relation between them. And get the desired rows by using Parent and Children Relation in the Cursors. So i am writing two querys in case where i could fetch records using One single query.
Do we have any other way where i can implement Join query in simpler way in Visual COBOL ADO.Net.