sql server - EF5 Code First Automatic Migrations: Renaming Primary Key gives error: column names in each table must be unique -


i have entity relations primary key relid. change key relationid

first, changed columname in ssms: sql table

then used (in visual studio) rename change word relid relationid, in references.

i thought change in database , in code, convince code work new named primary key, alas following error arises when run project:

column names in each table must unique. column name 'relationid' in table 'dbo.relations' specified more once.

of course, isn't case. in table column relationid exists once. it's ef5 trying add column same name.

can explain me why error occurs , how fix it?

global.asax

protected void application_start()     {          //database.setinitializer<oefenfirmacontext>(new oefenfirmadropcreateandseed());         database.setinitializer<oefenfirmacontext>(new oefenfirmadropcreateandseed());          viewengines.engines.clear();         viewengines.engines.add(new razorviewengine());          arearegistration.registerallareas();         routeconfig.registerroutes(routetable.routes);          modelbinders.binders.add(typeof(shoppingcart), new cartmodelbinder());     }

and class oefenfirmadropcreateandseed (not seeding anymore):

public class oefenfirmadropcreateandseed :      migratedatabasetolatestversion<oefenfirmacontext, migrations.configuration> { }

you using add-migrations right? then, need not update on database side manually using manual scripts. should in add-migration scripts alone. if manually run scripts rename column in database side existing system generated migrationscripts , database in out of sync. so, end error while running/rollback new/old migration scripts. per understanding, please try out following steps

step 1: rename primary key of model class (relid relationid) in visual studio code.

step 2: run add-migration renamemycolumn in package manager console. system generate migrationscripts based on model changes below.

note: please verifies system generated addcolumn , dropcolumn instead of renamecolumn scripts below in system generated migration scripts. if yes, please remove addcolumn , dropcolumn scripts manually , add renamecolumn() scripts in up() , down() methods renamed primary key property.

namespace myproject.model.migrations {    using system;    using system.data.entity.migrations;     public partial class renamemycolumn : dbmigration    {      public override void up()      {         // remove following auto-generated lines(note:these scripts generated example purpose not primary key)         addcolumn("dbo.mytable", "newcolumn", c => c.string(nullable: false, maxlength: 50));         dropcolumn("dbo.mytable", "oldcolumn");          // add line         renamecolumn("dbo.mytable", "oldcolumn", "newcolumn");     }      public override void down()     {         // remove following auto-generated lines(note:these scripts generated example purpose not primary key)         addcolumn("dbo.mytable", "oldcolumn", c => c.string(nullable: false, maxlength: 50));         dropcolumn("dbo.mytable", "newcolumn");          // add line         renamecolumn("dbo.mytable", "newcolumn", "oldcolumn");     }   } }

hope might move forward!


Comments

Post a Comment

Popular posts from this blog

python - Operations inside variables -

this question has answer here: evaluating mathematical expression in string 12 answers i want make python script finds maximum possible output using 2 operations. problem says there syntax error @ 2nd last line, in b in there. how can fix it? x = 0 = int(input("1st number:")) c = int(input("2nd number:" )) e = int(input("3rd number:" )) in range(4): if == 0: b = "+" elif == 1: b = "-" elif == 2: b = "/" else: b = "*" j in range(4): if j == 0: d = "+" elif j == 1: d = "-" elif j == 2: d = "/" else: d = "*" k = b c d e print(k) if you're after variables e on single line, couldn...
Read more

Generic Map Parameter java -

i having lot of methods of type: public static list<eduusers> getdetails(class c, map<string, integer> params) { list<eduusers> details = null; session session = hibernateutil.getsessionfactory().opensession(); transaction tx = null; try { tx = session.begintransaction(); criteria cr = session.createcriteria(c); (map.entry<string, integer> entry : params.entryset()) { cr.add(restrictions.eq(entry.getkey(), entry.getvalue())); } details = cr.list(); tx.commit(); } catch (exception asd) { log.debug(asd.getmessage()); if (tx != null) { tx.commit(); } } { session.close(); } return details; } i trying have generic method them , have written far: public static <t> list<t> getdetails(class<t> c, class<t> b) { l...
Read more

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -

what arrayindexoutofboundsexception mean , how rid of it? here code sample triggers exception: string[] name = {"tom", "dick", "harry"}; for(int = 0; i<=name.length; i++) { system.out.print(name[i] +'\n'); } your first port of call should documentation explains reasonably clearly: thrown indicate array has been accessed illegal index. index either negative or greater or equal size of array. so example: int[] array = new int[5]; int boom = array[10]; // throws exception as how avoid it... um, don't that. careful array indexes. one problem people run thinking arrays 1-indexed, e.g. int[] array = new int[5]; // ... populate array here ... (int index = 1; index <= array.length; index++) { system.out.println(array[index]); } that miss out first element (index 0) , throw exception when index 5. valid indexes here 0-4 inclusive. correct, idiomatic for statement here be: for (int index = 0; index <...
Read more