Can you provide it on github, so I can patch my copy of FB library to use in our project?
1. What problem in Execute block? 2. My opinion for "Identity" is to copy MSSQL behavior. Create generator for each primary key + trigger before insert. 2014-11-08 14:38 GMT+02:00 Jiří Činčura <j...@cincura.net>: > 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 >
------------------------------------------------------------------------------
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
