Why am I getting an extra foreign key column with Entity Framework Code First Foreign Key Attributes? -

-

i came across strange problem entity framework code first.

my class looks this

public class status {         [key]         public int statusid { get; set; }              public string name { get; set; }         public int memberid { get; set; }          [foreignkey("memberid")]         public virtual member member { get; set; }                          public int posterid { get; set; }          [foreignkey("posterid")]         public virtual member poster { get; set; }                  public virtual icollection<statuslike> statuslikes { get; set; }                 public virtual icollection<statuscomment> statuscomments { get; set; } }

my member class looks this

 public class member     {         [key]         public int memberid { get; set; }         public string firstname { get; set; }         public string lastname { get; set; }         public string bio { get; set; }          public virtual icollection<membercoursetaken> membercoursetakens { get; set; }         public virtual icollection<status> statuses { get; set; }         public virtual icollection<club> foundedclubs { get; set; }          public string emailaddress { get; set; }         public string password { get; set; }         public string phone { get; set; }          public int accountsourceid { get; set; }         public accountsource accountsource { get; set; }          public int addressid { get; set; }         public address address { get; set; }         public string profilephoto { get; set; }          public int memberrankid { get; set; }         public memberrank memberrank { get; set; }         public datetime created { get; set; }         public datetime modified { get; set; }     }

and whatever reason database table created has following columns

statusid name memberid posterid member_memberid

with memberid, posterid, , member_memberid being foreign keys.

how can keep member_memberid being generated?

your member_memberid column created because of member.statuses property. can imagine not want. members , statuses should exist independent of each other, need junction table.

i don't know if use onmodelcreating override of dbcontext, that's place change mapping between member , status:

protected override void onmodelcreating(dbmodelbuilder mb) {     mb.entity<member>().hasmany(m => m.statuses).withmany(); }

this create table memberstatuses table 2 id columns foreign keys. way model many-to-many relationship without navigation property on "other" side of association. (i don't think want members property in status).


Comments

Post a Comment

Popular posts from this blog

django - How can I change user group without delete record -

-
on website user have 1 group. , user can change group. it's made user.groups.clear() and user.groups.add(new_group) but it's not efficient, because there 2 sql query: delete, insert. how can change group update query? user , group related each other using manytomanyfield . means intersection table exists relating both entities, , if don't specify model map (using through attribute) django creates 1 you. looking @ sources django.contrib.auth.models see that's case. fortunatly, can access intermediary model using through attribute of manager (in case, user.groups.through ). can use regular model. example: >>> alice = user.objects.create_user('alice', 'alice@example.com', 'alicepw') >>> employee = group.objects.create(name='employee') >>> manager = group.objects.create(name='manager') >>> alice.groups.add(employee) >>> alice.groups.all() [<group: employee...
Read more

java - Need to add SOAP security token -

-
i need set custom soap header attribute on jax-ws generated webservice client. case webservice calls must go through proxy server requiring specific token (recieved web request header) present in soap request header. e.g.: 1 carserviceservice service = null; 2 service = new carserviceservice(new url(url), new qname(qname); 3 carserviceendpoint port = service.getcarserviceport(); it seems in line 3 wsdl retrieved , call fails due missing security token. 1 point direction on how done? a detailed example has been mentioned here: creating , deploying jax-ws web service on tomcat 6 this article shows how create , use security token .
Read more

java - EclipseLink JPA Object is not a known entity type -

-
i have strange problem eclipselink , object want persist. have 1 object (keypointlistimpl) stores object keypointimpl in list. persisting keypointimpl objects works great if try persist keypointlistimpl object java.lang.illegalargumentexception says object keypointimpl isn't known entity type. here keypointimpl code: @entity @table(name="keypoints") public class keypointimpl implements keypoint { @id @generatedvalue(strategy = generationtype.identity) private int id; @enumerated(enumtype.string) private detectortype keypointtype; private float x; private float y; private float size; private float angle; private float response; private int octave; private int classid; ... } here keypointlistimpl code: @entity @table(name="keypointlists") public class keypointlistimpl implements keypointlist { @id @generatedvalue(strategy = generationtype.identity) private int id; @onetoone(cascade={ca...
Read more