English 中文(简体)
SqlBulkCopy with SqlHelper class
原标题:

I ve installed DataAccessApplicationBlock.msi and I got the Microsoft.ApplicationBlocks.Data.dll file into my bin folder. I found every other sqlhelper methods except ExecuteBulkCopy.

How do I add ExecuteBulkCopy function to the SqlHelper class?

最佳回答

Isn t that block an abstraction over the database? What would the code do if it wasn t SQL-Server? I personally don t think it makes sense to encapsulate this in a general-purpose (and database-neutral) library.

Also; it is pretty basic functionality, so you shouldn t have any problem writing a method for the basic scenario that accepts a connection-string, table name, and IDataReader / DataTable. In non-trivial usage is has lots of configuration options (column mapping, events, etc), and probably doesn t warrant wrapping.

To be honest, while I use SqlBulkCopy, I don t use it often enough (or similarly enough) to warrant hiding it away. Perhaps just use SqlBulkCopy directly in your repository / DAL / whatever code?

问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

NSArray s, Primitive types and Boxing Oh My!

I m pretty new to the Objective-C world and I have a long history with .net/C# so naturally I m inclined to use my C# wits. Now here s the question: I feel really inclined to create some type of ...

C# Marshal / Pinvoke CBitmap?

I cannot figure out how to marshal a C++ CBitmap to a C# Bitmap or Image class. My import looks like this: [DllImport(@"test.dll", CharSet = CharSet.Unicode)] public static extern IntPtr ...

How to Use Ghostscript DLL to convert PDF to PDF/A

How to user GhostScript DLL to convert PDF to PDF/A. I know I kind of have to call the exported function of gsdll32.dll whose name is gsapi_init_with_args, but how do i pass the right arguments? BTW, ...

Linqy no matchy

Maybe it s something I m doing wrong. I m just learning Linq because I m bored. And so far so good. I made a little program and it basically just outputs all matches (foreach) into a label control. ...

热门标签