Fast SQL Server Inserting Data from .NET

clive All, ASP.Net, Development, Microsoft, Rectangle Red, Tech Tip, Uncategorized, VB.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

clive All, ASP.Net, Development, Tech Tip, 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 …

Rectangle Red are Hiring (Stony Stratford, Milton Keynes)

clive ASP.Net, Jobs, Milton Keynes, Rectangle Red, Stony Stratford, VB.Net

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

clive All, ASP.Net, Development, Microsoft, Tech Tip, VB.Net, WCF, Web

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 …