Re: [Firebird-net-provider] EF Migrations

[Jiří Č. <ji...@ci...>]

> 1. Generator ID. One for all is bad options for me. I'll reimplement it to have one for table.

That's why it's open.

> 2. Couple of errors in creating Constraints or Indexes:
"unsuccessful metadata update
Name longer than database column size"
Constraint names are longer than it can be in system tables: "ALTER TABLE "ClientGroupAlerts" ADD CONSTRAINT "FK_ClientGroupAlerts_ClientGroups_ClientGroup_Id"". I've figured that maximum name is 31 (!!!) characters. I've implemented SHA1 (maybe I will replace it with something faster) hashing of string names.

Yeah. Firebird's 31 characters it's goign to be hard to beat. I can shorten the string, but that will increase collisions. Maybe we can create - similar to generators - open ended method that anybody can override if needed.

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