Neo4j 3.0 with a .Net driver: Neo4jClient

27 Apr 2016 .Net, C#, Databases, Graph Databases, MVC, Neo4j, NoSql No Comments

I started dabbling in Neo4j, a NoSQL graph database, around 2 years ago. I have not used it much in the .Net world, and with the recent release of Neo4j 3.0, with its built in .Net driver, I decided to have a

Continue reading →

Getting Entity Framework to recognise the return type of a Stored Procedure that returns a #temp table

27 Sep 2013 .Net, C#, SQL, Stored Procedures, Visual Studio No Comments

I recently wanted to declare a table, insert data into it and then, depending on a variable passed in to the stored procedure (@i_bitCurrent), either return the contents of the table, or filter the contents with a Where clause and return them (3 options in total). The reason I wanted

Continue reading →

Progromatically get SessionId Cookie name used in an asp.net application

09 Sep 2013 .Net, C#, MVC No Comments

The default name for the SessionId cookie in an Asp.Net application is ASP.NET_SessionId, but this can be changed in the web.config, e.g. I wanted to get the name of the SessionId cookie for the web app that was implementing my class library. I knew the dll would be implemented by many

Continue reading →

Get the executing assembly of a web app referencing a class library

05 Sep 2013 .Net, C#, MVC No Comments

I needed to check that any web app that was referencing my class library was giving me a valid controller and action name in some settings in its web.config, so that when I used them in a redirection there would be no errors because they did not exist. When I used to

Continue reading →

Using Custom Action Filters in Class Libraries

21 Aug 2013 .Net, C#, Filters, MVC 2 Comments

I have recently been creating a class library that many MVC web applications are going to reference, and I wanted those applications to be able to implement some custom Action Filters so they did not need to duplicate code. I had originally thought this was not possible, due to the

Continue reading →

Passing in variables to custom Action Filters

20 Aug 2013 .Net, C#, Filters, MVC No Comments

Sometimes it is useful to have a reusable custom action filter, for example for checking user authorisation to access part of the application. I would prefer not to have a separate filter for each type of user, e.g. MustBeAdminAttribute, MustBeManagerAttribute, etc. There are several ways to pass variables to a

Continue reading →

Storing a byte array in a Cookie (nom!) C# MVC

15 Aug 2013 .Net, C#, MVC No Comments

It seems that cookies can eat store just about any kind of data, but keeping to a limit of 20 cookies per domain and 4096 bytes per cookie is the safe way to do it (source). I needed to store a byte

Continue reading →

Retrieving parameters from the query string in the URL in .Net

23 Jul 2013 .Net, C#, Filters, MVC No Comments

Here is a nice easy way to get the individual parameter values from the URL, returning either a NameValueCollection (System.Collections.Specialized.NameValueCollection HttpRequestBase.QueryString) of all parameters in the query string, or a string value of a particular named parameter.

var parameters = HttpContext.Request.QueryString;
var parameters = HttpContext.Current.Request.QueryString;
public class MyAttribute : ActionFilterAttribute
{
    public override void OnActionExecuting(ActionExecutingContext filterContext)
    {
        var

Continue reading →

Config Transform Files for changing Web.config for release (ASP.Net 4.0)

26 Jun 2013 .Net, Visual Studio No Comments

You can change parts of the web.config between different builds (e.g. debug and release). I used it to change whether cookies must only be sent and received over ssl. It is also useful for changing connection strings from debug to live versions and also user defined keys (examples below). Clicking the arrow

Continue reading →

Fixed: Error when deploying a .Net 4.0 project (that was downgraded from .Net 4.5) to a .Net 4.0 server

25 Jun 2013 .Net, Server 2008, Visual Studio No Comments

I recently had to downgrade a .Net 4.5 project to .Net 4.0 so that it could run on MS Server 2003. I had many warnings and errors which I managed to clear up, as detailed in my previous post Downgrading an

Continue reading →