In this tutorial you will learn how to create lookup tables using enums in entity framework (EF) with Code-first approach.

With EF support for enums, you can include lookup tables in the code in form of enums and also have them in the database for integrity.

Contents

This tutorial provides the information you need about:

• What Is Enum In C# ?
• Creating Enum
• Creating Lookup Table Class Using Code-First Approch
• Define Foreign Key Constraint Using Code-First Conventions
• Disable Identity for Lookup Table IDs
• Seeding Enum into Lookup Table
• References

What Is Enum In C# ?

Enum or Enumerations is used to declare a list of named integer constants. The enum is used to give a name to each constant so that the constant integer can be referred using its name.

Enumerations appear in your source code. These are things that affect program logic because you’re going to have conditional statements based on the state of some entity comparing it with some enum value. This enums represents numerical values which can get used in place of IDs in database tables.

Contents

• Why Use Database Migrations?
• Crafting Migrations in EF
  • Enable migration
  • Update Entities and Add Migration
  • Spot Checking
  • Update-Database
• Merge Workflow With Migrations
• Handling Special Cases With Migrations
• Best Practices
• References

Why Use Database Migrations?

Teams usually use version control systems to manage and collaborate on changes made to versions of source code. Different developers can develop on divergent, relatively older or newer branches of the same source code to make changes and additions during development.

Contents

• What is Adapter Design Pattern?
• Adapter Pattern Structure
• Adpater Pattern Real World Example
• Where To Apply Adapter Pattern?
• Further Reading

What is Adapter Design Pattern?

The Adapter Pattern is a software design pattern that attempts to reconcile the differences between two otherwise-incompatible interfaces. This pattern is especially useful when attempting to adapt to an interface that cannot be refactored.

Contents

• What Is Tuple In Python?
• Far From Python Style Tuple
• Python Style Tuple In C# 7.0
• References

What Is Tuple In Python?

A Tuple is a collection of Python objects separated by commas. In someways a tuple is similar to a list in terms of indexing, nested objects and repetition but a tuple is immutable unlike lists which are mutable.