As recently as our Connect for ADO.NET 3.2 release, we introduced support for bulk load operations across all of our providers. We are already getting excellent feedback on what we hoped would be our most prominent features, namingly
The DDTek.Data.Common.DbBulkCopy* objects which act as an extension for programmers who want to extend their usage of the common programming model and provider factories. Check here for functional details on a DbBulkCopy, DbBulkCopyColumnMapping (and more) objects. If you've used bulk copy in in ADO.NET this is a nice extension of the established pattern in ADO.NET where SqlBulkCopy originally blazed the trail.
Just as popular is our ability to consume standard CSV files that be either generated/processed automatically (CsvWriter and CsvReader respectively) or by an outside tool using our published schema as a guide. Although, in hindsight, an obvious point of integration, we probably didn't do as a good a job in making it easy to understand how any outside tool would could understand the decisions we took on how we map specific database data types to our common CSV data type.
So to meet this need, I am publishing a range of tables below that show how each database type, or DbType maps to our XML Schema 'dataType' facet.
View all posts from Jonathan Bruce on the Progress blog. Connect with us about all things application development and deployment, data integration and digital business.
Let our experts teach you how to use Sitefinity's best-in-class features to deliver compelling digital experiences.
Learn MoreSubscribe to get all the news, info and tutorials you need to build better business apps and sites
Progress collects the Personal Information set out in our Privacy Policy and the Supplemental Privacy notice for residents of California and other US States and uses it for the purposes stated in that policy.
You can also ask us not to share your Personal Information to third parties here: Do Not Sell or Share My Info
We see that you have already chosen to receive marketing materials from us. If you wish to change this at any time you may do so by clicking here.
Thank you for your continued interest in Progress. Based on either your previous activity on our websites or our ongoing relationship, we will keep you updated on our products, solutions, services, company news and events. If you decide that you want to be removed from our mailing lists at any time, you can change your contact preferences by clicking here.