Postby 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
Posts: 31
Joined: Thu 30 Apr 2009 07:59

Postby Shalex » Tue 30 Aug 2011 12:54

Please refer to http://msdn.microsoft.com/en-us/library/system.data.missingschemaaction.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.
Devart Team
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for Oracle