.NET

Setting up Slackin using Azure and Let’s Encrypt

So I started the sw-dotnet-developers slack (https://sw-dotnet.uk/) a week or so ago, and quickly realised I needed some kind of self registration system to avoid me having to send off invites to everyone, which would become boring very quickly. I did some searching and found Slackin – a little server that enables public access to a slack server – awesome! It even has an Azure Deploy setup – literally click on one link and fill in some details to get it installed. NB – I had to use the ‘latest’, ......

Cornwall .NET Developer Meetup–FIRST!

Living in Cornwall is great, surf, sun (ha!) and stunning views all over the place – I’m very lucky :) But one thing it does lack – is .NET meetups, in Cornwall – there are approximately none. That’s right – none! Well – no longer! Software Cornwall has created one - https://www.meetup.com/Corn... admittedly this is short notice (it’s this Friday) but – if you’re a .NET developer, and you live in Cornwall, I encourage you to get over there! As a side note – I’ve just started ......

WCF and LINQ to SQL (Part 4 – Updates)

If you’ve read parts 1, 2 and indeed 3 you’ll know we’ve covered the CRD of CRUD, today we will cover the ‘U’ – updates! Updates are more complex than the other scenario’s we’ve covered so far, but not unmanageable. Also – in fairness this is a very simple update, more complex updates will require more thought (duh!) but this should be a good starting point. Let’s get to it! We’ll start on familiar ground – updating the interface, adding an ‘UpdateCar’ method: [OperationContract] void UpdateCar(Car ......

WCF and LINQ to SQL (Part 3 (Deletes))

If you’ve read parts 1 and 2 you’ll know we’ve covered the CR of CRUD, today we will cover the ‘D’ – deletions. We’ll need to update our interface to actually provide this functionality: [ServiceContract] public interface ICarsService { [OperationContract] Car GetCar(int id); [OperationContract] void SubmitCar(Car car); [OperationContract] void DeleteCar(int id); } I’ve decided to delete the car via the identifier we created initially, though there is nothing to stop us using a ‘Car’ instance. Anyhews, ......

WCF and LINQ to SQL (Part 2 (Creates))

Right, in my last post I wrote about creating a DBML file and hooking it all up through WCF, however, we only got to ‘retrieving’ from the database via the service. So, let’s presume you want to upload… We already had our contract: [ServiceContract] public interface ICarsService { [OperationContract] Car GetCar(int id); [OperationContract] void SubmitCar(Car car); } Of which we’ve tested the ‘GetCar’ method, let’s get to implementing the ‘SubmitCar’ method. We actually did implement some code in ......

Neo4jClient–Bolt Edition

Neo4j 3.x added a new transport protocol called ‘Bolt’ in essence a binary transmission protocol to speed up connectivity to the database, and with a series of official drivers – get everyone on an even keel. Trouble is, changing from Neo4jClient to Neo4j-Driver is a big pain, for two main reasons: 1. You lose all the fluent setup you get with Neo4jClient (Cypher.Match(“”).Where(“”) etc) 2. You lose all the object mapping (.Return(u => u.As<User>())) Some people would be happy to just be ......

DotNetters–it’s time to graph up

I recently wrote an article with Michael Hunger (of Neo4j) about getting your .NET on with Neo4j - http://thenewstack.io/graph-database-neo4j-net-client/ – it’s time guys, it really is time!

Calling Stored Procs in Neo4j using Neo4jClient –the hacky way

Neo4j 3.0 introduced the concept of Stored Procedures, now, whilst they’re not the same as SQL based SPs, they work – and well – it’s what we’ve got! Neo4jClient doesn’t currently have any native way to call a Stored Proc, so to get you there in the interim, we’ll use the ‘apoc.create.uuids’ proc – which returns a GUID (or multiples) and uses both the CALL and YIELD keywords. (Sorry for lack of code highlighting….) var gc = new GraphClient(new Uri("http://localhost:7474/... gc.Connect(); ......

BrowserStack Visual Studio 2015 Extension

Do you find that you want browserstack but once again, the extension lets you down by not installing into VS2015. Worry not! As with VS2013 (that I wrote about here) it’s a case of editing the vsixmanifest file and targetting a different visual studio version. Download the extension from the VS gallery (here) open it up with 7zip/winzip/windows and edit the extension.vsixmanifest file, change the following lines from: <Installation InstalledByMsi="false" AllUsers="true"> <InstallationTarget ......

The three stages of *my* database choice

Prologue I write and run a website called Tournr, a site to help people run competitions, it helps them organise and register for competitions, keeping the scores online and taking some of the pain of competition management out for them. I began it due to a badly run competition I attended (and ahem ran) a few years ago – and I wanted to make it better for first-timers (like myself) and old-hands alike. This post is about the database decisions and pains I’ve been through to get where I currently ......

Full .NET Archive