Google
AspAlliance.com Web
AspAlliance
Register
Edit My Profile
Author List
Write for Us
About AspAlliance
Contact Us
Privacy Policy
Link To Us
Advertise

Subscribe
Free Newsletter
Newsletter Archive
RSS Syndication

.NET Tutorials
Learn .NET
Learn WCF
Learn WPF
Learn ASP.NET
Learn AJAX
Learn Silverlight
Learn Visual Studio
Learn ADO.NET
Learn LINQ
Learn C# (CSharp)
Learn VB.NET
Learn Web Services
Learn Controls
Learn BizTalk
Learn SharePoint
Learn Mobile
Learn SQL
Learn SQL Reporting
Learn Windows Forms
Learn XML
Learn Crystal Reports
Learn telerik
Learn FarPoint
Learn DevExpress
Examples
ASP.NET 2.0 Examples

ASP Tutorials
Learn ASP
Learn VBScript
Learn JScript
Learn SQL
Learn XML

Other Tutorials
Learn Java
Learn Oracle
Opinion / Editorial
Crystal Reports Alliance

Free Tools
Cache Manager
SimpleCMS

Reviews
Book Reviews
Product Reviews
Expert Advice

Books
ASP.NET Developer's Cookbook
Sample Chapters
Book Reviews

Community
Developer Jobs
Resource Directory
ASP Email Lists
ASP.NET Email Lists
Whidbey Email Lists
AspAlliance Groups
SQL Email Lists
XML Email Lists
Regular Expressions
MS Communities
CodeWise Communities

Web Hosting
ASP Hosting
Dedicated Servers
FREE Hosting
Shared Hosting
Web Farm Hosting

Print This Article Print  Add To Favorites Add To Favorites    Email This Article To A Friend Email To Friend  Rate This Article Rate This Article   
Video: Handing Schema Mapping When Using SqlBulkCopy
page 1 of 1
Published: 07 Jul 2008
Abstract
In this video, Mohammad Azam demonstrates how to handle schema mapping when using the SqlBulkCopy class to insert bulk data. His demonstration uses non-matching source and destination tables, and he uses mappings to allow the copying. He shows how to statically define mappings as well as how to write code which determines mappings at run-time. [6:12]
by Mohammad Azam
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 1482/ 72

 

View

[Play the Video] - Requires Registration/Login

[Download Sample]

Notes

·         SqlBulkCopy is part of the .NET framework 2.0 which allows developers to perform bulk insert operations.

·         The SqlBulkCopy class uses DataTable or DataReader to perform the bulk insert.

·         SqlBulkCopy includes a mappings collection which enables developers to programmatically copy columns from source table to the destination table.

 

 

 

 

 

 

 

 

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 4 and 4 and type the answer here:

User Comments

No comments posted yet.






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2008 ASPAlliance.com  |  Page Processed at 11/22/2008 4:11:00 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search