With SQLBulkCopy, junction tables are not updated.

c# sqlbulkcopy

Question

I have three tables like below and one company can have multiple locations

Company - Id, Name ...

Locations - Id, City, State, Country ..

CompanyLocation, Id, CompanyId, LocationId

With below code company and location tables are getting updated, but the associated / junction table is not getting updated

// Create the SqlBulkCopy object.                
using (var bulkCopy = new SqlBulkCopy(connection))
{
    bulkCopy.DestinationTableName = TargetTable;
    // Write from the source to the destination.
    bulkCopy.WriteToServer(sourceTable);
}

Any help please?

1
0
6/21/2012 1:01:35 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Each SqlBulkCopy object is linked to one SQL table specified by the SqlBulkCopy.DestinationTableName Property, as showed in your code. Hence, a solution to update your three tables would be to instantiate three SqlBulkCopy objects, one for each table.

0
6/21/2012 1:24:42 AM

Related Questions

External table is not in the required format, SqlBulkCopy

I'm trying to use SqlBulkCopy as per the example in ...Import Excel Spreadsheet Data into SQL Server Database Table Using SqlBulkCopy.......I've created the table and Excel sheet OK and done the coding, but I keep getting...External table is not in the expected format....at the ...connection.open()... line....How do I get rid of this problem?... ...
c# sqlbulkcopy visual-studio-2010
asked by DarkW1nter

To Insert/Update in Main Table from Staging Table in SQL Server 2008

I would probably do something like this:...make your transformations on that staging table (add additional columns as needed etc.)...do the INSERT/UPDATE into the actual data table using the ...SQL Server 2008 ...MERGE... command... which is ideally suited for just this - update some existing rows, insert some new rows (and possibly delete some old...
join sqlbulkcopy sql-server-2008
asked by marc_s

Getting an exception writing a boolean to sql using a datatable and SqlBulkCopy

It works fine for all other datatypes, but I am unable to get it to work with a 'bit' column....This is my SQL for doing the bulk write:...using (var bulk = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.KeepIdentity & SqlBulkCopyOptions.KeepNulls)) { bulk.BatchSize = 2000; bulk.DestinationTableName = targetTable; bulk.WriteToServ...
c# datatable sqlbulkcopy sql-server
asked by NibblyPig

Excel Data to new SQL Server table using C# - new table not being created?

Hi think you are not checking your table name before inserting excel data into data table. you can go through the below code....class excelTwosheetsBulk1 { private static readonly log4net.ILog log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); static void Main(string[] args) { log...
c# sqlbulkcopy sql-server tsql
asked by Naresh.boddu

Getting SqlBulkCopy to show up as sql in MiniProfiler

You should be able to use ...CustomTimings... to profile these. These are included in the ...new v3 version... that is now ...available on nuget.......You can see some example usages of ...CustomTiming... in ...the sample project... where this is used to record http and redis events....An example of how you could use it with ...SqlBulkCopy...:...st...
c# mvc-mini-profiler sqlbulkcopy
asked by Yaakov Ellis

SqlBulkCopy.WriteToServer() keep getting "connection is closed"

This makes no sense to me but maybe someone with keener eyes can spot the problem....I have a Windows service that uses FileSystemWatcher. It processes some files and uploads data to an MSSQL database. It works totally fine on my machine -- detached from Visual Studio (ie not debugging) and running as a service. If copy this compiled code to our...
c# sqlbulkcopy sql-server
asked by ironfist

SQLBulkcopy - Header of datatable getting inserted in the database table

The header is the first row returned from ...rows..., just skip that row when you import....//(snip) dtExcelData.Columns.AddRange(new DataColumn[3] { new DataColumn("AccountNumber", typeof(string)), new DataColumn("Amount", typeof(decimal)), new DataColumn("Sedol",typeof(string)) }); //Makes the header row the current row. ...
asp.net asp.net-mvc c# npoi sqlbulkcopy
asked by Scott Chamberlain

SSIS - OleDB connection not updating data, inserted thru SQLBulkCopy with SQL Connection

My bad....Instead of passing data type as long (int in SQL), i was passing it as Varchar....I was looking from last few hours and as soon as i post question here, it strikes me to check the data type....Hope it will help somebody.
oledbconnection sqlbulkcopy sqlconnection ssis
asked by Manish Joisar

Create procedure that will insert or update data from one temporary table to other 4 tables

You cannot use a variable to track all the changes, but you track all the changes with OUTPUT....if object_id('dbo.[MSPCompanies]') is not null drop table dbo.[MSPCompanies]; if object_id('dbo.[MSPTempTable]') is not null drop table dbo.[MSPTempTable]; create table dbo.[MSPTempTable] ( MSP_Companies_ID int identity(1,1), INN ...
database sqlbulkcopy sql-server stored-procedures
asked by ildanny

SQLBulkCopy is not inserting on table

After see the Jacob comment, I discover another process that was erasing the data that was inserted. So, its all ok with my code (happily)....Tks.
sqlbulkcopy vb.net
asked by Rodrigo Perisatto

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow