Fast SQL Server Inserting Data from .NET

Today we needed to insert a large amount (250,000 rows) of automatically generated data into a SQL Server database. Generating the data was very fast, but inserting each line with a SQL Insert statement, painfully slow, even if logging is in Simple Mode in the SQL database. So… we investigated the SQLBulkCopy function in .NET, but this is usually used …

Deep Copying an Object in VB.NET

A curious omission in .NET is the ability to make a deep copy of an object which is independent of the original object – i.e. you can change the copy without changing the original. If you simply copy an object in .NET with assignment, all you are doing is pointing a second variable at the same object in memory, and …

Converting HTML to PDF in VB.Net with PDFSharp

An interesting little problem we’ve had to implement for a client recently; how to take an HTML (passed through as an email attachment), and convert it to a PDF in a VB.net command line program. There are lots of 3rd party libraries around that do that, but typically, they’re expensive and not terribly reliable, formatting the HTML that we wanted …

Rectangle Red are Hiring (Stony Stratford, Milton Keynes)

We’re expanding and looking to hire a junior and a senior application developer! You’ll need experience and skill with Microsoft technologies (.NET in particular), relational database systems (e.g. SQL Server or MySQL), and to be a dab hand with the latest web technologies (HTML5, CSS3, JQuery, etc). We offer all you would expect – a competitve salary, opportunty to learn …

Tech Tip: Setting up WCF Services in VB.Net

Windows Communication Foundation (WCF) is Microsoft’s latest generation webservice publishing technology. It’s also really badly documented; I’ve yet to find an example which says exactly what you need to do to create a WCF enabled service; plenty of examples that tell most of the story, but always missing a vital part of the jigsaw. Here’s what you need to know (Visual Studio …