Posts Tagged .NET
Streaming Data Between Databases using SqlBulkCopy and SqlDataReader
Posted by Michael Bowersox (Admin) in .NET, C#, SQL Server on December 1, 2011
One little known fact about SqlBulkCopy is that not only can the WriteToServer method use a DataTable, but it can also use any object that implements IDataReader. Since the SqlDataReader object implements the IDataReader interface, it is a perfect candidate for use with a SqlBulkCopy object. One instance where I found this extremely useful, is [...]
Semaphores in C#
Posted by Michael Bowersox in .NET, C# on January 16, 2011
A short while ago I had a need to limit simultaneous requests to a web service from a multi-threaded application to prevent timeouts. I learned about semaphores in school and knew this was the right approach, but I have never used one in a real-world application before. Luckily, the .NET framework makes it rather easy [...]
RSS
