A Blog About Random Computer Subjects
Summary One of the biggest problems I used to find in unit testing is that most of the products I work on contain mostly methods that access a database. I found that most objects and methods work with data and it’s very tedious to try and mock or fake the database component. If you’ve followed … Read moreUnit Testing Methods that Call Stored Procedures
Summary One of my areas of expertise is in mass data transfers using API’s, FTP, WebDAV or SOAP connections. In this post I’m going to talk about techniques that can be used to increase the throughput of accessing data from a Web API and putting it in a database. I’m also going to discuss issues … Read moreLoading Data From an API Quickly
Summary In this blog post I’m going to demonstrate how to do a bulk data insert using ADO. I’ll be adding code to my helper set of tools so that you can use the ADO database code at my GitHub account to write clean ADO database methods. Bulk Inserts The C# SqlClient library contains a … Read moreBulk Data Inserts