sqlbulkcopy
How to use SqlBulkCopyColumnMappingCollection?
I want to make one SqlBulkCopy method that I can use for al开发者_开发知识库l my bulk inserts by passing in specific data through the parameters.[详细]
2023-01-02 03:29 分类:问答How to find offending column? Can't Convert from string to int32
I am using SqlBulkCopy. So I made a datatable and specifed it\'s columns then added rows to the datatable and then try to insert it.[详细]
2023-01-02 03:21 分类:问答Possible to get PrimaryKey IDs back after a SQL BulkCopy?
I am using C# and using SqlBulkCopy. I have a problem though. I need to do a mass insert into one table then another mass insert into another table.[详细]
2023-01-01 22:45 分类:问答Questions About SQl BulkCopy
I am wondering how can do a mass insert and bulk copy at t开发者_如何学Che same time? I have 2 tables that should be affect by the bulk copy as they both depend on each other.[详细]
2023-01-01 01:10 分类:问答MySqlDataAdapter or MySqlDataReader for bulk transfer?
I\'m using the MySql connector for .NET to copy data from MySql servers to 开发者_开发问答SQL Server 2008.[详细]
2022-12-29 07:56 分类:问答SqlBulkCopy slow as molasses
I\'m looking for the fastest way to load bulk data via c#.I have this script that does the job but slow.I read testimonies that SqlBulkCopy is the fastest.[详细]
2022-12-28 00:46 分类:问答How to prevent duplicate records being inserted with SqlBulkCopy when there is no primary key
I receive a daily XML file that contains thousands of records, each being a business transaction that I need to store in an internal database for use in reporting and billing.[详细]
2022-12-25 18:40 分类:问答SqlBulkCopy and Entity Framework
My current project consists of 3 standard layers: data, business, and presentation.I would like to use data entities for all my data access needs.Part of the functionality of the app will that it will[详细]
2022-12-25 10:45 分类:问答How to get identities of inserted data records using SQL bulk copy
I have an ADO.NET DataTable with about 100,000 records. In this table there is a column 开发者_StackOverflow社区 xyID which has no values in it, because the column is an auto-generated IDENTITY in my[详细]
2022-12-24 17:30 分类:问答How to insert a DataTable with existing Key to a SQL Server Table
I am working with VB.NET.. i have a DataTable called \"QUESTION\", containing 3 fields: QuestionNumber (unique integer key)[详细]
2022-12-24 10:18 分类:问答