Re: [Firebird-net-provider] Migrations

[Геннадий З. <zab...@gm...>]

1. I've used hashes from names to avoid dictionaries for mapping name-guid.
2. I think it was about Model field. More precise error I'll tell tomorrow when PC will be available. I don't want to constraint page size, because changing page size for existing databases is done only via backup-restore AFAIK. In case of several GB dbs it's not an option.
3. Yes. Default behavior maybe several pre defined and possibility to provide custom.
4. One more issue I remembered. Dbs created with Initial migration and via CreateDatabaseIfNotExists have different underlying scheme in part of names. I think this should be also fixed.

-----Original Message-----
From: "Jiří Činčura" <ji...@ci...>
Sent: ‎8/‎29/‎2015 10:08 PM
To: "For users and developers of the Firebird .NET providers" <fir...@li...>
Subject: Re: [Firebird-net-provider] Migrations

> 1. Long names of tables causes foreign key script creation fail with error "Name exceeded implementation limitation". This caused by 31 characters limitation to almost anything not only FK. We crutched this with hashing names   with base64 convert. Ugly but works.

Maybe we can, in case it's longer than 31 characters, simply use GUID. Not nice either, though.

> 2. Second it is drop from support databases with pages less than 16384 because of another impl. limitation for max string field length. This breaks creating MigrationHistory table. We didn't fixed this, because started using separate database. But in near future our previous database would also need to have migrations. I think this can be crutched to use blob field only for Model field of this table.

You mean the PK on MigrationHistory? We can specify 16k page size as a requirement. There's not much to invent on the PK.

> 3. Issue with sequence generators. Maybe you remember discussion about this on github. Looks like I've found good place to configurate particular field. It is in OnModelCreating Properties().Configure(x=>x.AddAnotation()) for property. There user can specify what sequence behavior does he need or provide custom.

True. And with custom convention it's not even needed to specify it explicitly for every column.

> Today I tried to add tests for all this to repo but found out that we need to add separate test infrastructure for EF tests.

There's few tests I wrote. Using CF as that's easy to set up. But maybe the migrations would need deeper setup.

-- 
Mgr. Jiří Činčura
Independent IT Specialist


------------------------------------------------------------------------------
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider