Re: [Firebird-net-provider] EF Migrations

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

Fall in next query:
EXECUTE BLOCK
AS
BEGIN
EXECUTE STATEMENT
'CREATE TABLE "__MigrationHistory" (
"MigrationId" VARCHAR(150) NOT NULL,
"ContextKey" VARCHAR(300) NOT NULL,
"Model" BLOB SUB_TYPE BINARY NOT NULL,
"ProductVersion" VARCHAR(32) NOT NULL
)'
WITH AUTONOMOUS TRANSACTION;
END
Parameters:
With next exception:
unsuccessful metadata update
STORE RDB$RELATIONS failed
lock conflict on no wait transaction

2014-12-30 9:03 GMT+02:00 Геннадий Забула <zab...@gm...>:

> Here are my issues/suggestions:
> 1. Generator ID. One for all is bad options for me. I'll reimplement it to
> have one for table.
> 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.
>
> Will write about further progress.
>
> 2014-12-20 8:32 GMT+02:00 Mercea Paul <pau...@al...>:
>
>> On 2014.11.06 3:06 PM, Jiří Činčura wrote:
>> > Hi *,
>> >
>> > Anybody here willing to give EF Migrations a try? I'm getting close to
>> first implementation.
>> >
>> I'm trying to add support for Firebird db for existing app on SQL
>> Express, and, first run of the application was with no errors and
>> created the database.
>> I'll going to try migrations steps and give feedback.
>>
>> Thanks Jiri
>>
>> Paul MERCEA
>> ___________________________________________
>> E-mail: pau...@al...
>> ___________________________________________
>>
>>
>>
>> ------------------------------------------------------------------------------
>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards
>> with Interactivity, Sharing, Native Excel Exports, App Integration & more
>> Get technology previously reserved for billion-dollar corporations, FREE
>>
>> http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
>> _______________________________________________
>> Firebird-net-provider mailing list
>> Fir...@li...
>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>
>
>