Question Re: Entity Framework - Code First Migrations in Technology Q&A

Entity Framework - Code First Migrations

Former Member — Mon, 23 Jul 2012 10:56:00 GMT

Any plan to implement it?

Re: Entity Framework - Code First Migrations

MCMartin — Tue, 24 Jul 2012 06:14:25 GMT

have you tried it, for me it seems to be independent of the underlying DB system. Maybe the created commands don't work, but you still have the possibility to adjust the generated code manually

Re: Entity Framework - Code First Migrations

Breck_Carter — Tue, 24 Jul 2012 07:48:40 GMT

Wow, just had a look at EF 4.3 Code-Based Migrations Walkthrough... if I used that for the schema and data upgrade process for the Foxhound embedded database, I'd still be coding in the year 2025, and if it ever ran successfully for anything other than ALTER TABLE ADD column or CREATE INDEX, the first run against a multi-gigabyte customer database would take days.

...but hey, I hate frameworks, so what do I know? 🙂

Re: Entity Framework - Code First Migrations

Former Member — Tue, 24 Jul 2012 08:05:07 GMT

Of course I tried. The fact is that SA provider doesn't implement it. See error: "No MigrationSqlGenerator found for provider 'iAnywhere.Data.SQLAnywhere'. Use the SetSqlGenerator method in the target migrations configuration class to register additional SQL generators."

Re: Entity Framework - Code First Migrations

MCMartin — Tue, 24 Jul 2012 09:19:46 GMT

ok, this means if SAP Sybase is not going to implement it you can at least try it yourself.

Re: Entity Framework - Code First Migrations

MCMartin — Tue, 24 Jul 2012 09:20:30 GMT

I agree mostly the frameworks only work great for the simple examples

Re: Entity Framework - Code First Migrations

Breck_Carter — Tue, 24 Jul 2012 10:14:11 GMT

Sounds like it would be an enhancement... try posting a "Product Suggestion:" question, with reasons why you think it should be implemented. A success story about someone who actually used it with MSS to implement a non-trivial migration would help a lot. The competition for new features is intense, with a LOT of cool stuff waiting for resources.