WP7 SQL Server CE 如何更新
我正在将 Windows Phone 应用程序更新为 Mango 并开始使用 SQL Server CE。我可以插入和选择数据，但很难理解如何更新数据。
大多数示例都是基本教程，仅显示插入和检索数据而不显示更新。我相信我需要将我检索到的类附加到数据上下文，但这就是我所能得到的。
请有人给我指点一个在线教程，展示如何做到这一点。或者一些示例代码会很棒。
谢谢。
更新
基本更新看起来相当简单 - 查询数据库、更新对象、调用 SubmitChanges。
我的情况有点复杂。
我有一个显示职位列表的页面。选择一个作业 (JobDetail)，然后使用另一个页面来编辑详细信息。编辑作业时，作业会写入缓存（另一个表 JobCache）。如果用户取消编辑，缓存将被删除。如果用户保存编辑，JobCache 对象将从缓存中提取，转换为 JobDetail 类型的对象，现在我想使用新的 JobDetail 对象更新数据库。我不认为我可以只调用 SubmitChanges，因为该对象是不是从查询生成的。我相信我需要以某种方式使用 Attach 来做到这一点。问题是如何？
I'm updating my Windows Phone App to Mango and starting to use SQL Server CE. I can insert and select data but am struggling to understand how to update data.
Most of the examples are basic tutorials and only show inserting and retrieving data not updating. I believe I need to attach a class I have retrieved to the data context but that is as far as I have got.
Please can someone point me to an online tutorial showing how to do this. Or some example code would be great.
Thanks.
UPDATE
Basic updating looks fairly simple - query the database, update the object, call SubmitChanges.
My scenario is a little more complicated.
I have a page showing a list of jobs. A job (JobDetail) is selected and another page is used to edit the details. The job is written to a cache (another table JobCache) while the job is edited. If the user cancels the edit the cache is deleted. If the user saves the edit the JobCache object is pulled from the cache, converted to an object of type JobDetail and now I want to update the database with the new JobDetail object.I don't think I can just call SubmitChanges as the object was not generated from a query. I believe I need to somehow use Attach to do this. The question is how?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
为什么不获取原始 JobDetail 对象，从缓存对象更新更改的属性并调用 SubmitChanges ？
Why not get the original JobDetail object, update the changed properties from the cahced object and call SubmitChanges ?