Articles
Links to on-line content that I have submitted.
From The Introduction:
This article will focus on transferring an in memory DataTable to SQL Server database. Ado.Net provides numerous well documented methods for creating DataTables with persistence back to their source databases. But in some circumstances the source database is just that a source. The question remains: “How do you persist your in memory DataTables to a database if you are not intending to update the data to the source database but to a different database? How can this new database and its tables be created to reflect the in-memory DataTable and once that is created what method can be used to move the data to that table?
Through this article I intend to demonstrate one way to approach the issue of persisting a DataTable to an unrelated database. I strive to show within this article that through the implementation of SqlServer Management Objects and SQLBulkCopy one possible solution.