postgresql - Error "Requested value 'UpdateDatabaseOperation' was not found" when attempting to generate an idempotent Code First Migration script -


i'm using dotconnect 7.3.115.0 entityframework 6.0.2.

when try generate script migration, error "requested value 'updatedatabaseoperation' not found."

here details , stack trace:

pm> update-database -script -sourcemigration: $initialdatabase -targetmigration: test -verbose

using startup project 'domain.dataaccess'.
using nuget project 'domain.dataaccess'.
target database is: 'testdatabase' (datasource: localhost, provider: devart.data.postgresql, origin: configuration).
applying explicit migrations: [201403241857577_initialcreate, 201403241941149_test].
applying explicit migration: 201403241857577_initialcreate.
applying explicit migration: 201403241941149_test.

system.argumentexception: requested value 'updatedatabaseoperation' not found.    @ system.enum.enumresult.setfailure(parsefailurekind failure, string failuremessageid, object failuremessageformatargument)    @ system.enum.tryparseenum(type enumtype, string value, boolean ignorecase, enumresult& parseresult)    @ system.enum.parse(type enumtype, string value, boolean ignorecase)    @ devart.common.entity.migrations.a.b(migrationoperation a_0)    @ devart.common.entity.migrations.f.a(migrationoperation a_0)    @ devart.common.entity.migrations.f.a(ienumerable`1 a_0)    @ devart.common.entity.migrations.c.a(ienumerable`1 a_0, string a_1)    @ devart.data.postgresql.entity.migrations.pgsqlentitymigrationsqlgenerator.generate(ienumerable`1 migrationoperations, string providermanifesttoken)    @ system.data.entity.migrations.dbmigrator.generatestatements(ilist`1 operations, string migrationid)    @ system.data.entity.migrations.infrastructure.migratorbase.generatestatements(ilist`1 operations, string migrationid)    @ system.data.entity.migrations.infrastructure.migratorscriptingdecorator.scriptupdate(string sourcemigration, string targetmigration)    @ system.data.entity.migrations.design.toolingfacade.scriptupdaterunner.run()    @ system.appdomain.docallback(crossappdomaindelegate callbackdelegate)    @ system.appdomain.docallback(crossappdomaindelegate callbackdelegate)    @ system.data.entity.migrations.design.toolingfacade.run(baserunner runner)    @ system.data.entity.migrations.design.toolingfacade.scriptupdate(string sourcemigration, string targetmigration, boolean force)    @ system.data.entity.migrations.updatedatabasecommand.<>c__displayclass2.<.ctor>b__0()    @ system.data.entity.migrations.migrationsdomaincommand.execute(action command) requested value 'updatedatabaseoperation' not found.

update

it seems issue related generating idempotent scripts using -sourcemigration: $initialdatabase

per microsoft:

generating idempotent scripts (ef6 onwards)

starting ef6, if specify –sourcemigration $initialdatabase generated script ‘idempotent’. idempotent scripts can upgrade database @ version latest version (or specified version if use –targetmigration). generated script includes logic check __migrationshistory table , apply changes haven't been applied.

i encounter error when using dotconnect pointed @ postgresql database. works expected when using sqlserver instance.

thank report on this. have reproduced issue.

update

we have investigated issue in more details , not related dotconnect postgresql. issue related ef tool , command being used in it:

update-database -script -sourcemigration $initialdatabase -targetmigration: s -verbose

it necessary use '-script' parameter or '-verbose' parameter, not both @ same time. please try using, example:

update-database -script

to detailed information each command please use:

get-help update-database -detailed

Comments

Post a Comment

Popular posts from this blog

user interface - How to replace the Python logo in a Tkinter-based Python GUI app? -

is there way change default logo, python logo , appears in window's task bar? notice have replaced default tk logo used appear in application window. i using windows 7 , python 2.6 , developing gui of tkinter. you can using winico tk extension package. winico package can used add system tray icons tk programs. the following sample shows 1 way change runtime application icon. note need provide .ico file suitable sizes of icons in on command line , need use pythonw. not change taskbar icon console when running python script. test extracted winico0.6 package python\tcl\winico0.6 folder package require winico work , ran code below using pythonw winico_test.py path\to\some\ico\file.ico . import sys tkinter import * def main(argv): root = tk() root.update() root.tk.call('package','require','winico') id = root.tk.call('winico','createfrom',argv[1]) root.tk.call('winico','setwindow',root,id...
Read more

objective c - Greedy NSProgressIndicator Allocation -

i'm using bunch of nsprogressindicators @ once (32 exact) , looks when they're animating start allocating memory no one's business greedy_run http://i62.tinypic.com/15rgmso.png i've got reports app slowdown , crash after days of uptime, , looks culprit, it's hard pinpoint bugs take days appear. i comment out call start animating, memory behaves expected. result of multiple nsprogressindicators alloc'ed on same thread? or maybe sandboxing? of constant allocations coming core animation threads, don't know else going on. custom nsview progress indicator lives in @interface myview () @property (nonatomic, strong) nsimageview *imageview; @property (nonatomic, strong) nstextview *numbertxt; @property (nonatomic, strong) nsprogressindicator *progress; @end @implementation myview - (id)initwithframe:(nsrect)framerect { self = [super initwithframe:framerect]; if (self) { // image nsimage *image = [nsimage imagenamed:@"bg.png"]; c...
Read more

how to set an OCR language in Google Drive -

i need upload image google drive including ocr feature. the problem setocrlanguage method. need specify hebrew language , based on iso 639-1 codes should "heb". i'm getting response "code" : 400, "errors" : [ { "domain" : "global", "location" : "ocrlanguage", "locationtype" : "parameter", "message" : "invalid value", "reason" : "invalid" } ], any idea should code or can list of avaliable codes?
Read more