Pages

Friday, July 15, 2016

Bulk Insert in MS-SQL using c#

using (SqlConnection con = new SqlConnection(consString))
                    {
                        using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
                        {
                            //Set the database table name
                            sqlBulkCopy.DestinationTableName = "PLQualifications";

                            //[OPTIONAL]: Map the DataTable columns with that of the database table
                            sqlBulkCopy.ColumnMappings.Add("QualificationId", "QualificationId");
                            sqlBulkCopy.ColumnMappings.Add("PLQuestionCode", "PLQuestionCode");
                            sqlBulkCopy.ColumnMappings.Add("LanguageId", "LanguageId");
                            con.Open();
                            sqlBulkCopy.WriteToServer(distinctQualifications);
                            con.Close();
                        }
                    }

No comments:

Post a Comment