#linqpad

Linqpad-The Developers’ Playground

There’s a little tool that’s been around for years but still largely unknown outside the software engineering space-the legendary Linqpad by Perth based engineer/author Joseph Albahari.

It’s been described as a software utility targeted at .Net development but it does so much more including helping thousands of developers and engineers across the globe each day with prototyping, learning and…

Install Graphviz for Windows and clone the git repository for the wrapper

Then, build the wrapper project.

In a new LinqPad query add the output of the build. And set the import namespaces to:

GraphVizWrapper GraphVizWrapper.Commands GraphVizWrapper.Queries

After all that is setup, you can now run this sample code from LinqPad:

This post was contributed by Jonathan Hamm, one of the developer gurus I have the privilege of working with at my day job.

I did not realize this behavior with rethrowing exceptions existed where information can be added to the exception by the “catch” then in subsequent “catch” blocks the data will remain. It does make sense now with this test.

The inner most method throws an error, the next…

Some stuff I’ve been working on lately (apart from work projects or games):

I created a new plugin for Media Browser Server, meant to force the creation or updating of local metadata files for items in the media library. This plugin is pretty raw and currently only available as source code on GitHub, but it provides the functionality I needed to keep an update of Media Browser from early in the…

Hey all ! This is my first blog post, so bear with me.

Going to show you a really neat way to get at the binary data stored in a BLOB column of your database table.

I'm going to keep the table simple. Lets assume we have a table that looks something like this (I'm using a SQL Server database):

CREATE TABLE [dbo].[MyBlobs](  [Id] [int] NOT NULL,  [Filename] [nvarchar](255) NOT NULL,  [BinaryData] [image] NOT NULL )

For this example we can also assume we have 3 rows:

Id=1, Filename="music.mp3", BinaryData=[bytes - lots of them] Id=2, Filename="foo.pdf", BinaryData=[bytes - lots of them] Id=3, Filename="cheese.jpg", BinaryData=[bytes - lots of them]

Lets open LINQPAD and enter the following code into the query window as a "C# Program":

void Main() {  var tableRow =   MyBlobs   .Where (r => r.Id == 2)   .SingleOrDefault();

 if (tableRow != null)   System.IO.File.WriteAllBytes(    Path.Combine(@"D:\", tableRow.Filename),     tableRow.BinaryData.ToArray());

 Console.WriteLine (tableRow); }

The first line is fairly standard LINQ that retrieves the row in the table with Id of 2.

The second line writes the file out to the D: drive.

The trick here is calling ToArray() on the BinaryData column of the row. LINQPAD has done all the work for us to represent each column from the database table as a property on the object returned by the query in the first line.

If we look on our D:\ drive, we will find the file "foo.pdf".

And that's all folks.

PS. There's some great discussion on the oreilly forum about displaying images from your database columns right inside LINQPAD.