DNVM, DNX, and DNU – Understanding the ASP.NET 5 Runtime Options
Image by César Astudillo | Some Rights Reserved ASP.NET 5 introduces a new runtime model for the .NET framework which allows us to employ a “pay-as-you-go” approach, building composable applications using only those...
Use Postgres JSON Type and Aggregate Functions to Map Relational Data to JSON
Postgres is just too cool. Because Postgres can work with both JSON and arrays as first-class data types, it is possible to perform some very handy mappings on the server end which would become potential performance bottlenecks...
Installing and Configuring PostgreSQL 9.4 on Linux Mint/Ubuntu
Installing and configuring PostgreSQL on a Linux box is either simple, because you are a Linux and/or Postgres expert, or not so simple, because you are new(er) to Linux, Postgres, or both. Over the past year, I have resided...
A More Useful Port of the Chinook Database to Postgresql
Image by Ingrid Talar | Some Rights Reserved I use Chinook Database as the sample database for a lot of things, primarily because the same data set is available for most of the major database platforms, so it’s easy to...
ASP.NET Web API: Understanding OWIN/Katana Authentication/Authorization Part III: Adding Identity
Image by alles-schlumpf | Some Rights Reserved This is the third post in a series in which we have built up a minimal, self-hosted, OWIN-based Web Api application essentially from scratch. Our objective has been to develop a...
ASP.NET Web Api: Understanding OWIN/Katana Authentication/Authorization Part I: Concepts
Recently we looked at the fundamentals of the OWIN/Katana Middleware pipeline, and we then applied what we learned, and built out a minimal, OWIN-Based, self-hosted Web Api. In doing so, we managed to avoid the heavy weight of...
ASP.NET Web Api 2.2: Create a Self-Hosted OWIN-Based Web Api from Scratch
Image by Ivan Emelianov | Some Rights Reserved Building up a lean, minimal Web Api application from scratch is a terrific way to become more familiar with how things work under the hood in a Web Api (or any other ASP.NET)...
ASP.NET: Understanding OWIN, Katana, and the Middleware Pipeline
Image by Sunova Surfboards | Some Rights Reserved The tools and architectural patterns we use to build and evolve web applications have undergone dramatic change over the past few years. Modern web application development is a...
C#: Avoiding Performance Issues with Inserts in SQLite
Image by Lance McCord | Some Rights Reserved If you are new to SQLite, you may well run across one of the most confounding of its implementation details the moment you attempt to do some sort of bulk or batch processing of...
Installing and Using SQLite on Windows
Image by shinichi | Some Rights Reserved When one is developing in .NET with Visual Studio and other Microsoft tools, it is easy to lose sight of alternative solutions to common problems. MS does a competent job of creating a...