Great. Here's http://ge.tt/2Cx9f142?c early implementation. There are two issues which I'm not sure how to do (see below). Rest should work. But there might be some missing space etc. in generated SQL or I might wrote it in different engine's dialect. That's what I'm mostly looking for for this testing.
For easiest testing is enough to install EntityFramework.Firebird package and then replace EntityFramework.Firebird.dll reference with the one from above link. The class is FbMigrationSqlGenerator, if you'd like to try it manually. Issues: 1. Not easy to drop NOT NULL constraint in alter table. I can do it with "execute block" and generate it there, but seems pretty ugly. I wish Firebird 3 was here. 2. Generating "identity" columns. It's not directly supported in Firebird. I can at least generate "#PK_GEN#" comment. But I'd like to offer some warning at least that you need to create your own trigger and use/create generator. Maybe some developer-provided factory to create/alter the trigger and create/use generator would work. I'm open for ideas. -- Mgr. Jiří Činčura Independent IT Specialist ------------------------------------------------------------------------------ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
