With SQLBulkCopy, junction tables are not updated.

c# sqlbulkcopy

Question

I have three tables like the ones shown, and a single business might have many locations.

Company - Id, Name ...

Locations - Id, City, State, Country ..

CompanyLocation, Id, CompanyId, LocationId

The associated/junction table is not updated with the following code, but the company and location tables are.

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

Can you please help?

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

According to your code, each Obj SqlBulkCopy is connected to a certain SQL table that the DestinationTableName Property in SqlBulkCopy has defined. Therefore, creating three instances of type objects using SqlBulkCopy, one for each table, would be a way to updating your three tables.

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

Related Questions

External table is not in the required format, SqlBulkCopy

To utilize SqlBulkCopy, I'm attempting to follow the example in ...Using SqlBulkCopy, import data from an Excel spreadsheet into a SQL Server database table........I've successfully coded and built the table and Excel file, however I keep receiving...External table is not in the expected format....at the...connection.open()... line....How can I so...
c# sqlbulkcopy visual-studio-2010
asked by DarkW1nter

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

I think I'd take the following action:...alter yourself on that stage table (add additional columns as needed etc.)...Use the ...2008 SQL Server...MERGE... command..., which is well designed for only this task: update some current rows, insert some new rows, to do the INSERT/UPDATE into the real data table (and possibly delete some old "orphaned" ...
join sqlbulkcopy sql-server-2008
asked by marc_s

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

For every other datatype, everything functions flawlessly, however I am unable to make a "bit" column work....This is the SQL I used to do the bulk write:...using (var bulk = new SqlBulkCopy(connectionString, SqlBulkCopyOptions.KeepIdentity & SqlBulkCopyOptions.KeepNulls)) { bulk.BatchSize = 2000; bulk.DestinationTableName = targetTable; ...
c# datatable sqlbulkcopy sql-server
asked by NibblyPig

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

Before entering Excel data into a data table, I believe you should have checked the table name. You may follow the code below....class excelTwosheetsBulk1 { private static readonly log4net.ILog log = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); static void Main(string[] args) { lo...
c# sqlbulkcopy sql-server tsql
asked by Naresh.boddu

Getting SqlBulkCopy to show up as sql in MiniProfiler

You need should be able to use...CustomTimings... to characterize them These are a part of the formerly ...updated version 3...., which is now ...accessible through nuget.......You may see a few examples of...CustomTiming... This is used to log http and redis events in ...the model undertaking.......An illustration of how you may use it with...SqlB...
c# mvc-mini-profiler sqlbulkcopy
asked by Yaakov Ellis

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

I don't get this, but maybe someone with better eyes can see the issue....I utilize FileSystemWatcher in a Windows service. It performs file processing and data uploading to an MSSQL database. On my computer, it runs well as a service that is separate from Visual Studio and not in debug mode. I always get the following problem if I transfer this ge...
c# sqlbulkcopy sql-server
asked by ironfist

SQLBulkcopy - Header of datatable getting inserted in the database table

The first row returned from is the header row....rows... just omit that row from the 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....I was sending the data type as Varchar rather than as long (int in SQL)....As soon as I ask a question here after searching for a few hours, the thought occurs to me to verify the data type....I hope someone will benefit.
oledbconnection sqlbulkcopy sqlconnection ssis
asked by Manish Joisar

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

The only way to keep track of every change is via OUTPUT; you cannot keep track of every change with a variable....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), ...
database sqlbulkcopy sql-server stored-procedures
asked by ildanny

SQLBulkCopy is not inserting on table

I found another process that was removing the inputted data after seeing the Jacob remark. So my code is working well (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