c# - Entity Framework Core still picks up old column -


i delete column conversationid tables. when start debug service , try save getting error:

invalid column name 'conversationid'.

code:

public class astootcontext : dbcontext {     public astootcontext(dbcontextoptions<astootcontext> options)         : base(options)     { }      protected override void onmodelcreating(modelbuilder modelbuilder)     {     }      public dbset<servicerequest> servicerequests { get; set; } }

and entity looks this:

public class servicerequest {     public int id { get; set; }     public int senderuserid { get; set; }     public int pricetypeid { get; set; }     public decimal price { get; set; }     public bool isaccepted { get; set; }     public datetime created { get; set; }     public int messageid { get; set; } }

all references conversationid removed code, i've rebuilt, yet i'm still getting error , don't understand why.

this sql server table can see there no conversationid:

enter image description here

is there secret cache need delete or have run update this?

ef core code based orm, important here being m - mapper. doesn't matter actual database structure is, important ef *thinks** based on code model (entity classes , properties, combined data annotations, fluent configuration , set of conventions).

so problem should originate code. since you've removed explicit property, should caused shadow property. , explained in documentation link, shadow properties introduced convention relationships:

shadow properties can created convention when relationship discovered no foreign key property found in dependent entity class. in case, shadow foreign key property introduced.

the documentation explains naming rules applied in different scenarios.

a shadow property called conversationid can introduced in several ways, according provided information, cause have entity class called conversation defining one-to-many relationship servicerequest having collection type navigation property:

public class conversation {     public int id { get; set; }     // ...     public icollection<servicerequest> servicerequests { get; set; } }

which according comment indeed case.

for completeness, here other possible scenarios generating such property:

(1) no collection navigation property in conversation, reference navigation property in servicerequest:

public class conversation {     public int id { get; set; }     // ... }  public class servicerequest {     // ...     public conversation conversation { get; set; } }

(2) no navigation properties in conversation , servicerequest, fluent configuration:

modelbuilder.entity<conversation>()     .hasmany<servicerequest>();

or

modelbuilder.entity<servicerequest>()     .hasone<conversation>();

or variations of above.

(3) no relationship involved, shadow property created through fluent configuration:

modelbuilder.entity<servicerequest>()     .property<int>("conversationid");

Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more