我正在使用Umbraco 文檔中的這個示例，當我嘗試將值保存到數據庫表時，我收到此錯誤：無法將 NULL 值插入列“Id”、表“petapoco.dbo.BlogComments” ；列不允許為空。插入失敗。該語句已終止。另外，在創建表并在數據庫中檢查它后，我可以看到 id 字段未設置主鍵和自動增量選項。這就是我插入值的方式：public class Class1 : IUserComposer{ public void Compose(Composition composition) { composition.Components().Append<SubscribeToContentServiceSavingComponent>(); } public class SubscribeToContentServiceSavingComponent : IComponent { public void Initialize() { MemberService.Saved += MemberService_Saving; } public void Terminate() { } private void MemberService_Saving(IMemberService sender, SaveEventArgs<IMember> e) { foreach (IMember member in e.SavedEntities) { var blogPostToAdd = new BlogCommentSchema(); blogPostToAdd.BlogPostUmbracoId = member.Id; blogPostToAdd.Name = member.Name; blogPostToAdd.Email = member.Name; blogPostToAdd.Website = member.Name; blogPostToAdd.Message = member.Name; using (var scope = Current.ScopeProvider.CreateScope(autoComplete:true)) { var database = scope.Database; // use database scope.Database.Insert<BlogCommentSchema>(blogPostToAdd); scope.Complete(); } } } }}
1 回答
大話西游666
TA貢獻1817條經驗 獲得超14個贊
Umbraco 論壇上的好人解決了我的問題。這是我的課堂上缺失的部分：
[PrimaryKeyColumn(AutoIncrement = true, IdentitySeed = 1)]
所以我的課程最終應該是這樣的：
[TableName("BlogComments")]
[PrimaryKey("Id", AutoIncrement = true)]
[ExplicitColumns]
public class BlogCommentSchema
{
[PrimaryKeyColumn(AutoIncrement = true, IdentitySeed = 1)]
[Column("Id")]
public int Id { get; set; }
[Column("BlogPostUmbracoId")]
public int BlogPostUmbracoId { get; set; }
[Column("Name")]
public string Name { get; set; }
[Column("Email")]
public string Email { get; set; }
[Column("Website")]
public string Website { get; set; }
[Column("Message")]
[SpecialDbType(SpecialDbTypes.NTEXT)]
public string Message { get; set; }
}
}
- 1 回答
- 0 關注
- 136 瀏覽
添加回答
舉報
0/150
提交
取消