Does ADO.Net pass Relationships through the data adaptors into datasets?

[Denaes]

I have relationships in my .mdb file.

 

I also see that schema seem to be about defining relationships.

 

Will the Jet Ole data connector take care of the existing relationships, or do you need to create a schema with the relationships to use them?

[Derek Stone]

Investigate the OleDbDataAdapter.FillSchema method.

[Nerseus]

I don't know about Access, but in SQL Server we had to define out relationships manually. This was because we use stored procedures to return multiple tables at once. It wasn't as simple as "SELECT * FROM Table1" so I don't think there could be any built-in relationship mapping for us. For Access, if you're doing single table selects it might work - not sure, but try Derek's idea :)

 

-nerseus

[Denaes]

I just got a better database book also ("Database Prorgramming with VB.Net" by A!). I had ADO.Net by Microsoft, which was the worst computer book I have on my shelf now.

 

I'll look into the fillschema method.

 

I'm thinking its just less complex to just make the tables in access and do the relationships in .Net.