Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 31
Joined: Thu 30 Apr 2009 07:59


Post by Trixz » Mon 29 Aug 2011 07:43

I'm having a performance issue with the MissingSchemaAction. the metadata takes some time to get and if we set it to add instead of addwithkey (default) it speeds up alot.

I try to find out what impact it will be if I change the property value from AddWithKey to Add. Where should I not use this!?

I'm only using datatables on a winform program. Devart Version 5.35.79

Related post:
http://www.devart.com/forums/viewtopic. ... hemaaction

Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Tue 30 Aug 2011 12:54

Please refer to http://msdn.microsoft.com/en-us/library ... ction.aspx.
MissingSchemaAction.Add adds the necessary columns to complete the schema.
MissingSchemaAction.AddWithKey adds the necessary columns and primary key information to complete the schema. This ensures that incoming records that match existing records are updated instead of appended.
If you are sure that primary key information is set correctly in your data table, you can use MissingSchemaAction.Add.

Post Reply