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
