ef-enum-to-lookup

KO | EN

gitlite — search

#typescript #ai-agents #ai #dsh-plugin #deepseek-harness #open-source #claude-code #codex #cli #developer-tools #react #windows

ef-enum-to-lookup

★ 70 Open GitHub ↗

Generates lookup tables from enum references in Microsoft Entity Framework 6.1

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

Entity Framework 6.1 Enum Lookup Table Generator
================================================

* License: MIT - http://opensource.org/licenses/MIT
* Source code: https://github.com/timabell/ef-enum-to-lookup
* Bug tracker: https://github.com/timabell/ef-enum-to-lookup/issues
* Nuget package https://www.nuget.org/packages/ef-enum-to-lookup

About
-----

Creates lookup tables and foreign key constraints based on the enums
used in your model.

This makes up for a feature that's missing in Entity Framework 6.1.

Usage
-----

Run `EnumToLookup.Apply()` from your Seed method in either your database initializer
or your EF Migrations.

Use the properties exposed to control behaviour.

It is safe to run repeatedly (Idempotent), and will ensure enum values are kept in line
with your current code if run regularly (e.g. in the migration seed method).

For example usage see [ExampleUsage/EnumExample.cs](ExampleUsage/EnumExample.cs), which
can be run in the test project project "[ExampleUsage](ExampleUsage)" if you want to see it in action.

var enumToLookup = new EnumToLookup();
	enumToLookup.NameFieldLength = 42; // optional, example of how to override default values
	enumToLookup.Apply(context);

### Creating sql scripts

If you can't point this library at your production database and let it make changes then you may need to generate sql in advance. As of v1.7.0 you can do this by running

var migrationSql = enumToLookup.GenerateMigrationSql(context);

instead of `Apply()` (or as well if you like).

Contributing
------------

Feedback, bug reports, pull requests all welcome, head over to github.

Fund development, PR handling etc: https://www.patreon.com/timabell

Repository
----------

Files stored as LF, converted on checkout to windows, configure locally with

git config core.autocrlf true

I've looked into the .gitattributes approach to this and it doesn't seem to have
the desired effect on a windows checkout.

Further reading
===============
* http://blogs.msdn.com/b/alexj/archive/2009/04/03/tip-10-understanding-entity-framework-jargon.aspx
* http://romiller.com/2014/04/08/ef6-1-mapping-between-types-tables/
* http://blogs.msdn.com/b/appfabriccat/archive/2010/10/22/metadataworkspace-reference-in-wcf-services.aspx
* http://msdn.microsoft.com/en-us/library/system.data.metadata.edm.dataspace.aspx

ef-enum-to-lookup

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README