Showing posts with label EF6 SQLite CodeFirst. Show all posts
Showing posts with label EF6 SQLite CodeFirst. Show all posts

Wednesday, May 28, 2014

Entity Framework 6.0 MigrationHistory table on SQLite

The following SQL is used to create __MigrationHistory table in SQLite database for Entity Framework 6.0 in Code-First mode.

CREATE TABLE [__MigrationHistory] ([MigrationId] CHAR NOT NULL, [Model] BLOB NOT NULL, [ContextKey] CHAR NOT NULL, [ProductVersion] CHAR NOT NULL, CONSTRAINT [sqlite_autoindex___MigrationHistory_1] PRIMARY KEY ([MigrationId]));