I've recently had to do some data parsing, pulling data from a CSV file, performing some validation and then dumping a series of SQL commands for our data population scripts. I know there are a myriad ways to do this but I wanted to do this as quickly and easy as possible. The process is quite simple: Open the file using a StreamReader Use the awesome CsvReader Map csv data to object ids from database Output SQL statements and error log To make things fast, I load all the necessary data collections from the database at the beginning of the …[read more]
Showing all posts tagged: '.NET'
A 10-post collection
There are many ways to generate GUIDs. You can use one of the many free websites or you can write your own (quick) script to do it. If you want to create your own script, there are 3 easy approaches: PowerShell ScriptCs Uuidgen.exe The first two are very powerful and versatile and can do a lot more than just generating GUIDs. The 3rd one is a dedicated utility for generating GUIDs only. PowerShell PowerShell is first as it's the easiest of the 2. Easiest to get started, that is. PowerShell is already installed on your Windows machine. Just bring …[read more]
RabbitMQ is a great queuing tool that can run on a variety of platforms. If you are planning on doing any distributed, asynchronous processing and you need a system to queue and process items in the background, then you should seriously consider RabbitMQ. The online documentation is great and there are plenty of tutorials that can take you through the basics of creating and consuming queues in your application. However, before you start typing any code, you first you need to get RabbitMQ up and running somewhere (local system, server etc). In this post, we will go through the installation …[read more]
Azure is my cloud of choice. Not only because you get free stuff, yes you do, but also because of the flexibility and ease of interacting with it. If you don’t have an Azure account, you can register for free here. One of the features offered by Azure is Storage. There are 3 types of Storage: Blobs: used to store files, images, binary data, or video Drives: which can be mount on VMs etc like an external drive but virtual Tables: scalable structured storage which acts like a database table but with slightly different behaviour and structured. You can …[read more]
Are you following this? Are you watching the videos? I think Channel9, the official Microsoft media outlet, died from overwhelming demand. The cynics may say that this is because of technical issues, however, I say that this is due to a highly demanding audience :). If you have been unable to watch the live stream, rest assured that all recordings will be available online soon (usually withing 48hrs). It's only been a month since the //Build event where Microsoft announced a host of new features, open sourced their new Roslyn compiler, and brought the mobile, desktop and gaming platforms together under …[read more]