Posts

If you are using some legacy SQL in C# you’ll occasionally need to write a WHERE IN. You don’t want to end up writing something like the below, either directly or through some sort of loop.

I have two other posts on multiple GET methods, both for Web Api 2. the first shows how to use routes like http://…/api/values/geta. the second shows http://…/api/values/22 or http://…/api/values/AAC1FB7B-978B-4C39-A90D-271A031BFE5D.

If got this error when trying to scaffold a new controller (MVC and Web Api) for an ASP.NET 5 web app using Visual Studio 2015. There was an error running the selected code generator: 'No database providers are configured.

If you recognize the error from the title of this post, you can jump to the solution. The problem I have a ASP.NET 5 solution with two projects, a web application project and a class library project.

When adding a class library to an ASP.NET 5 application you might get an error like “The following projects are not supported as references: - The project ClassLibrary1 has a target framework that is incompatible or has a version higher than the current project and cannot be referenced”

Full source code here. One of the very nice features of Entity Framework is the navigational properties. But it is easy to set them up in a less that optimal way.

Introduction If you read my post on Entity Framework migrations, you might be saying, “that’s amazing, but that’s all very well for new projects, but we’ve got eighty tables in place already and that code first migration ship has sailed”.

For many reasons you might want to know where a running assembly is located on your filesystem. I had to do this once when I was compiling classes at runtime and had a dependency on EntityFramework.

Full source code is provided. Overview This post gives a quick overview of how to use Entity Framework migrations and a detailed example of how to handle the addition of a new non null foreign keyed column to an existing table with data in it.

Full source code is available here. Below is an example of how to use RabbitMQ with Mass Transit service bus. See here for instructions on how to install Rabbit MQ.