Have a datatable, article 26 w data need to be inserted into the Oracle database table, whole circulation insert is too slow, there is no other good method? Bosses to give directions,

CodePudding user response:

Post code, this process is too slow,

CodePudding user response:

The bulk insert!

CodePudding user response:

sqlbulkcopyhttps://www.thinktecture.com/en/entity-framework/temp-tables-and-sqlbulkcopy/

CodePudding user response:

This can not slow? Clear demand directly naked SQL execution have wrestled with the object

CodePudding user response:

The

reference 3 floor exception92 response:

sqlbulkcopyhttps://www.thinktecture.com/en/entity-framework/temp-tables-and-sqlbulkcopy/

sqlbulkcpoy is good