Skip to content

Instantly share code, notes, and snippets.

View mikecole's full-sized avatar

Mike Cole mikecole

27 followers · 43 following
View GitHub Profile
@mikecole
mikecole / add-email-to-author
Created October 29, 2013 19:49
Entity Framework Code-Based Migrations AddEmailToAuthor
namespace EntityFrameworkExtraMile.Web.Migrations
{
using System.Data.Entity.Migrations;
public partial class AddEmailToAuthor : DbMigration
{
public override void Up()
{
AddColumn("dbo.Author", "Email", c => c.String(maxLength: 50));
}
@mikecole
mikecole / entity-framework-etc-code-based-migration
Created October 29, 2013 20:12
Entity Framework Etc. Code-Based Migration
namespace EntityFrameworkExtraMile.Web.Migrations
{
using System.Data.Entity.Migrations;
public partial class InitializeEtc : DbMigration
{
public override void Up()
{
CreateIndex("Category", "Name", true);
CreateIndex("JobTitle", "Title", true);
@mikecole
mikecole / teamcity-migrations
Created October 29, 2013 20:43
Custom script for TeamCity to execute Entity Framework Migrations
migrate.exe ProjectNameContainingContext /startUpConfigurationFile:..\web.config
@mikecole
mikecole / modified-author-class
Created October 30, 2013 18:11
Migrations Author Class Change
public class Author : EntityBase
{
public Author()
{
Posts = new Collection<Post>();
}
public string Name { get; set; }
public string TwitterHandle { get; set; }
public string Email { get; set; } //<-- right there
@mikecole
mikecole / blog-create-human-resources.sql
Created November 14, 2013 22:44
Script to create HumanResources demo database
USE [HumanResources]
GO
/****** Object: Table [dbo].[Dependent] Script Date: 11/14/2013 4:39:17 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Dependent](
[ID] [int] IDENTITY(1,1) NOT NULL,
[EmployeeID] [int] NOT NULL,
@mikecole
mikecole / Context.tt
Created November 15, 2013 22:37
Context T4 template used by Reverse Engineer Code First - Before
<#@ template hostspecific="true" language="C#" #>
<#@ include file="EF.Utility.CS.ttinclude" #><#@
output extension=".cs" #><#
var efHost = (EfTextTemplateHost)Host;
var code = new CodeGenerationTools(this);
#>
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using <#= code.EscapeNamespace(efHost.MappingNamespace) #>;
@mikecole
mikecole / Context.tt
Created November 15, 2013 22:43
Context T4 template used by Reverse Engineer Code First - After
<#@ template hostspecific="true" language="C#" #>
<#@ include file="EF.Utility.CS.ttinclude" #><#@
output extension=".cs" #><#
var efHost = (EfTextTemplateHost)Host;
var code = new CodeGenerationTools(this);
#>
using System.Data.Entity;
using <#= code.EscapeNamespace(efHost.MappingNamespace) #>;
@mikecole
mikecole / Entity.tt
Created November 15, 2013 22:47
Reverse Engineer Code First Entity template
<#@ template hostspecific="true" language="C#" #>
<#@ include file="EF.Utility.CS.ttinclude" #><#@
output extension=".cs" #><#
var efHost = (EfTextTemplateHost)Host;
var code = new CodeGenerationTools(this);
#>
using System;
using System.Collections.Generic;
@mikecole
mikecole / Mapping.tt
Created November 15, 2013 22:50
Reverse Engineer Code First Mapping template
<#
// Simplifying assumptions based on reverse engineer rules
// - No complex types
// - One entity container
// - No inheritance
// - Always have two navigation properties
// - All associations expose FKs (except many:many)
#>
<#@ template hostspecific="true" language="C#" #>
<#@ include file="EF.Utility.CS.ttinclude" #><#@
@mikecole
mikecole / YieldReturnBefore.cs
Last active August 29, 2015 13:56
private IEnumerable<string> GetItems()
{
var result = new List<string>();
result.Add("Test1");
result.Add("Test2");
result.Add("Test3");
return result;
}