DbSet.Add() not working
本文关键字:not working Add DbSet | 更新日期: 2023-09-27 18:14:14
我有一个这样的类:
[Table("member_activation")]
public partial class MemberActivation
{
[Key]
public Int64 member_id { get; set; }
public String token { get; set; }
}
My db:
public class SMADbContext : DbContext
{
public SMADbContext() : base("SMADB")
{
Database.SetInitializer<SMADbContext>(new NullDatabaseInitializer<SMADbContext>());
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
}
public DbSet<Member> Members { get; set; }
public DbSet<MemberActivation> MemberActivations { get; set; }
public DbSet<ApiAccount> ApiAccounts { get; set; }
public DbSet<ApiHardware> ApiHardwares { get; set; }
public DbSet<MemberRelation> MemberRelations { get; set; }
}
In my controller:
[Route("tester")]
[AllowAnonymous]
public IHttpActionResult tester()
{
using (var db = new SMADbContext())
{
var memberActivation = new MemberActivation();
memberActivation.member_id = 10155;
memberActivation.token = "hello";
db.MemberActivations.Add(memberActivation);
return Json(new { dbset = db.MemberActivations.ToList(), memberAct = memberActivation });
}
}
db.MemberActivations.Add (memberActivation);不工作。当我返回json时,dbset不包括新创建的memberActivation。我没有db.SaveChanges(),因为它不会保存,直到memberActivation被推送到dbset
您不能设置member_id,它是关键字,ef使用它作为身份。它将被忽略。您可以配置ef,使member_id不是身份,但这是另一个主题。
db.MembershipActivations.Add( new MemberActivation { token = "hello"}):
db.SaveChanges();
应该可以正常工作。
如果您有一个现有的成员,并且您试图通过连接表设置与该实体的关系,则。然后,您应该检索该实体并设置成员激活。他会帮你把剩下的安排好。这里有点猜测,因为我需要看到所涉及的实体。