问题描述
大家好,
我想从csv文件中导入数千条记录,同时我还需要管理在子表中插入数据的父子关系。
我使用SQLBulkCopy来导入数据,而且在性能方面它很快。
但是我无法管理父子关系用于在两个不同的表中插入数据。
可以任何人指导我怎么可能?
或者还有其他方法可以这样做除了SQLBulkCopy?
MY要求IS:我想使用Parent Child关系导入数千条记录(性能是关键点)。
请提供建议。
谢谢,
Rajan Bajania
Hi All,
I want to import thousands of record from a csv file and same time I also need to manage parent child relationship for Inserting Data in tables.
I have used SQLBulkCopy to Import data, and in terms of performance its fast.
But I am not able to manage parent child Relationship for Inserting Data in two different tables.
Can Any one guide me that how can its possible ?
or is there any other way to do this except SQLBulkCopy ?
MY Requirement IS : I want to Import thousands of records using Parent Child relationship (performance is key point).
Please provide suggestions.
Thanks,
Rajan Bajania
推荐答案
这篇关于从csv文件导入数千条记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!