Hi,
I am currently building a DDEX provider for our database product TurboDB.
Until now I did not do any programming, just providing the registry entries
and the xml files for the data objects and the data views.
Based on the simple sample from the VS SDK I can already display create a
connection in server explorer, display the tables and columns and have the
data source designer create a table adapter with a select statement. Great!
However there are no update statements created and the reason is obviously
that there are no keys known to the table adapter configuration wizard.
Therefore I added a new data object type called Index and mapped it to the
Index concept adding properties like Name, IsPrimary, IsUnique. The data is
delivered by the DbConnection.GetSchema method for the Indexes collection.
I can display the indexes in the server explorer, but the table adapater
configuration wizard will still not create the update statements. It does not
even seem to fetch the index data objects. Now I am wondering:
- Do the concepts Index, IsPrimary, IsUnique exist? I cannot find them in
the help file but the second DDEX sample seems to indicate they exist.
- How does the table adapter config wizard determine whether it can build
update statements? Why doesn't it simply use the command builder object,
which is already able to do this?
- Is there some more documentation on DDEX then the one in the VS 2005 SDK,
which is still missing important topics (e.g. reference of concepts and their
properties)
Any hint welcome!
Thanks
Peter
Peter Pohman (dataWeb) - 20 Jan 2006 19:31 GMT
I have partly resolved the issue:
The concept is called TableUniqueKey, not Index. And I have to implement the
TableUniqueKeyColumn concept as well. With these changes the wizard creates
some update statements.
But it is still crashing some times, so the question remains: Is there a way
to get my hands on more detailed information? Documents on the exact
concepts, what they do, what they require etc? This would be an invaluable
help.
Thanks
Peter