> Your configuration for context needs to derive from FbDbConfiguration. So
far there's no better solution. The migrations are run in serializable
transaction and you need to insert into __MigrationHistory right after
creation. Disaster.
I'm using the same Context for both MSSQL and Firebird, how deriving from
FbDbConfiguration can affect MSSQL code path? Can we override this somehow
just in Firebird provider?
> 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.
I like this.
2014-12-30 10:06 GMT+02:00 Jiří Činčura <j...@cincura.net>:
> Your configuration for context needs to derive from FbDbConfiguration. So
> far there's no better solution. The migrations are run in serializable
> transaction and you need to insert into __MigrationHistory right after
> creation. Disaster.
>
> --
> Mgr. Jiří Činčura
> Independent IT Specialist
>
> From: Геннадий Забула [mailto:zabulu...@gmail.com]
> Sent: Tuesday, December 30, 2014 8:19 AM
> To: For users and developers of the Firebird .NET providers
> Subject: Re: [Firebird-net-provider] EF Migrations
>
> 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 Геннадий Забула <zabulu...@gmail.com>:
> 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 <paul.mer...@almexa.ro>:
> 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: paul.mer...@almexa.ro
> ___________________________________________
>
>
>
> ------------------------------------------------------------------------------
> 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
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming! The Go Parallel Website,
> sponsored by Intel and developed in partnership with Slashdot Media, is
> your
> hub for all things parallel software development, from weekly thought
> leadership blogs to news, videos, case studies, tutorials and more. Take a
> look and join the conversation now. http://goparallel.sourceforge.net
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
