Re: [Firebird-net-provider] EF Migrations

2014-11-08 Thread Геннадий Забула
> It kind of breaks the notion of altering the table/column with one command. It's a bit of magic with system tables and people might get confused or break it by chaning the script. The update script should not be changed by users generated by migration. Or maybe I don't know something? > MSSQL has

Re: [Firebird-net-provider] EF Migrations

2014-11-08 Thread Jiří Činčura
> 1. What problem in Execute block? It kind of breaks the notion of altering the table/column with one command. It's a bit of magic with system tables and people might get confused or break it by chaning the script. > 2. My opinion for "Identity" is to copy MSSQL behavior. Create generator for

Re: [Firebird-net-provider] EF Migrations

2014-11-08 Thread Геннадий Забула
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 : > Great. H

Re: [Firebird-net-provider] EF Migrations

2014-11-08 Thread Jiří Činčura
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