zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

7 results in tag: asp.net-mvc

Unblockable SqlBulkCopy many tables in ASP.NET MVC

I have to make a multiple copy of tables from one database to other with SqlBulkcopy from an ASP.NET MVC application....The process takes more than 2 minutes, and I do not trust users....Wich is the best way to do the entire process, even if the user clos...
asp.net-mvc multithreading sqlbulkcopy
asked by cdiazal

Using SQL Bulk Copy to fill a database table

I'm working on an web app using ASP.NET MVC4. I have an Excel file with several columns (some of them are useless) and I'd like to export the data to a related table by uploading the file....One of my superiors told me to use SQL Bulk Copy to do that. I s...
asp.net asp.net-mvc c# excel sqlbulkcopy
asked by Traffy

Cannot SQLBulkCopy Error 40197 with %d code of 4815 (Connection Forcibly Closed)

Developing with VS 2013 ASP.NET MVC 5 Web Project and Separate Azure hosted SQL Server database. ...At the bottom is all my error information from Visual Studio 2013. I've narrowed down the problem and found a link to the Microsoft Description of the prob...
asp.net-mvc azure azure-sql-database sqlbulkcopy sql-server
asked by John

Sql bulkcopy error - The given ColumnMapping does not match up with any column in the source or destination

I am trying to sqlbulkcopy to my sql table. My source that is the datatable has three columns and destination table has four columns the first column being idendity column. The destination table generates the values when record is inserted to the database...
asp.net asp.net-mvc c# npoi sqlbulkcopy
asked by user3751248

SQLBulkcopy - Header of datatable getting inserted in the database table

The header of the datatable is getting inserted as a record in the table. I am incrementing the row number but still the header gets inserted. Could someone tell me what the issue is ? If you see the code below the I am doing rows.MoveNext.... XSSF...
asp.net asp.net-mvc c# npoi sqlbulkcopy
asked by user3751248

"The ConnectionString property has not been initialized." Error in SQL bulkcopy upload

I just created mvc 4 application,in that application I have function to upload Excel File to the database....this is working fine in localhost ....But when I deploy in ...IIS... and try to upload excel file.I'm getting following error ...The ConnectionStr...
asp.net-mvc c# connection-string iis sqlbulkcopy
asked by kez

How do I optimize data import into SQL Server with 100000 records with 100s of concurrent users

I am using Visual Studio web application using ASP.NET MVC & C#. I have an Excel file of more than 100000 records for import into SQL Server 2008 R2....I have used ...SqlBulkCopy... with ado.net ...DataTable... to copy data to a table (...Table1...)....Th...
asp.net-mvc sqlbulkcopy sql-server
asked by Debashis

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!