Dependency injection everywhere

Just a few years ago there was just few people who known what dependency injection is. Today it is almost everywhere. Recently I’ve discovered that it can be also used in Razor views – thanks to ASP.NET 5. I will try to show you how we can use that feature on few examples bellow. Probably each of you have been populating drop downs in Razor views with data send from controller.…

By Dawid on (tags: ASP.NET, dependency, injection, IoC, next, razor, categories: code)

Converting Razor views into Pdf

This post talks about how you can convert Razor views into PDF. There is couple of NuGet packages which we can use to achieve that. I will try to describe couple of them. iTextSharp This library allows us to create documents in Portable Document Format (PDF). Some of the features: - generate documents and reports based on either provided HTML or by manually adding PDF elements …

By Dawid on (tags: convert, generate, pdf, razor, categories: tools, code)

Change Data Capture quick start

Change Data Capture is a feature of Sql Server (available since version 2008) which allows to capture all insert, update and delete operations on database tables. Here I am going to show you the simple way of enabling CDC on database, table and specific columns.

By Mirek on (tags: audit log, Change Data Capture, categories: code)

How to access navigation property of deleted entity

In this post I am going to show you a small Entity Framework code first trick. When you remove an entity from the context its state is set to Deleted and all its navigation properties are nulled. This is done by DbContext internally. However you might want to know what was the related entities (navigation properties) before the entity was deleted. For instance you want to create some audit logs of deleted entity. I will show you how to do it with minimal effort.

By Mirek on (tags: Code First, Entity Framework, navigation property, categories: code)

Sql Server application roles with Entity Framework Code First Migrations

A time ago I have been writing about the Sql Server application roles, what are the benefits of using them and what are the limitations when we want to incorporate the Entity Framework to use application role. Today I will show you how to workaround those limitations with new Entity Framework facility introduced in version 6 of the framework.

By Mirek on (tags: Application Role, Entity Framework, SQL Server, categories: architecture, code)

WiX based Installer– Boilerplate

WiX Toolset is a technology to create Windows installers for your software. It is open source and free for use, but as many of free things is not super user friendly. The creation of the installer is XML based. In this post I will try to present a kind of boilerplate template which you can use to quickly create most of the need installer.

By Mirek on (tags: Installer, WiX, categories: tools)