Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Visual Studio.NET / Extensibility / January 2006

Tip: Looking for answers? Try searching our database.

DDEX: Table Adapter Configuration Wizard does not create update st

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Peter Pohmann (dataWeb) - 20 Jan 2006 00:56 GMT
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

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.