William Mitchell billgeek

Using Reflection and Fluent API to create EF6 Models

Below is an example of how to use reflection and Fluent API to define the models for your DbContext.

Objective

To contain the definition and initialization of a model in a single file and to seperate initialization out of the main context file.

IEntityBuilder.cs

The interface "IEntityBuilder" is primarily used to identify the models that are to be built

User.cs

Creating a Generic Repository Pattern

The below example shows how to implement a Repository of objects in a generic fashion. This was adapted and simplified from this article: https://code.msdn.microsoft.com/generic-repository-pattern-ddea2262

Overview

The point of this code is to allow the generic access to any object type in the datastore without the need to define a repository for each object. It is important to note that, although the below examples should work as is, it is recommended to make use of a dependency injection framework as database connection limits are not considered.

Overview

The below sample will demonstrate how to implement an HTTP interceptor in Angular 5 as well as append authorization tokens where neccessary. (This was built in Angular 4 originally and was not modified when upgrading, so it should still work with Angular 4)

To make a call including an auth token, simply pass "true" as the last argument.

Note that the "app-loader-indicator" needs to be the last element on the app component markup to ensure it's always visible and always "on top". The loader service and loader indicator component can be enhanced to make use of Observables, though for my project it was not required.

Lastly the loader indicator is simply the font awesome "fa-spin" class as per the example on the Font Awesome homepage.

Creating a Generic Repository Pattern (VB.NET)

The below example shows how to implement a Repository of objects in a generic fashion. (This is the VB.NET version of my previous GIST) This was adapted and simplified from this article: https://code.msdn.microsoft.com/generic-repository-pattern-ddea2262

Overview

The point of this code is to allow the generic access to any object type in the datastore without the need to define a repository for each object. It is important to note that, although the below examples should work as is, it is recommended to make use of a dependency injection framework as database connection limits are not considered.

Using Reflection and Fluent API to create EF6 Models (VB.NET)

Below is an example of how to use reflection and Fluent API to define the models for your DbContext. (This is a VB.NET version of my previous GIST)

Objective

To contain the definition and initialization of a model in a single file and to seperate initialization out of the main context file.

IEntityBuilder.cs

The interface "IEntityBuilder" is primarily used to identify the models that are to be built

	var copyToClipboard = function(strToCopy) {
	var el = document.createElement('textarea');
	el.value = strToCopy;
	document.body.appendChild(el);
	el.select();
	document.execCommand('copy');
	document.body.removeChild(el);
	}

	var getCurrentPl = function() {

	<!DOCTYPE html>
	<html>
	<head>
	<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.56/pdfmake.min.js"></script>
	<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.56/vfs_fonts.js"></script>
	</head>
	<body>
	<script type="text/javascript">
	function downloadPdf() {
	var docDefinition = {