Windows Phone 7 SQL Server CE rowversion [英] Windows Phone 7 SQL Server CE rowversion

问题描述

在Windows Phone 7上的SQL Server CE中更新表时，我遇到了问题.当我调用提交更改时，该应用程序将关闭，没有任何异常或错误. Visual Studio甚至仍在运行.

I had a problem when updating a table in SQL Server CE on Windows Phone 7. When I would call submit changes the app would close without any exceptions or errors. Visual Studio even remained running.

删除rowversion列可解决此问题.我环顾四周，不确定是否遗漏了一些东西，但是使用rowversion列时有什么特别的事情要做吗?

Removing the rowversion column fixed the problem. I've looked around and not sure if I'm missing something but is there anything special one needs to do when using a rowversion column?

这是该列的属性.我试图弄清楚时创建了一个简单的表.它具有3列:

Here are the attributes for the column. I created a simple table when trying to figure this out. It has 3 columns:

• Id(向导)
• TestColumn(nvarchar100)
• MyRowVersion(行版本)

• Id (Guid)
• TestColumn (nvarchar100)
• MyRowVersion (rowversion)

代码:

[global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_MyRowVersion", AutoSync=AutoSync.Always, DbType="rowversion", CanBeNull=true, IsDbGenerated=true, IsVersion=true, UpdateCheck=UpdateCheck.Never)]

推荐答案

假设您使用SQL Server Compact Toolbox生成了数据上下文，则存在一个错误，如果您的索引与主键覆盖的列相同，则会导致崩溃.尝试使用最新的Toolbox插件(版本2.6.2或更高版本)重新生成DataContext.该问题的解决方法是删除重复"索引.

Assuming you generate the datacontext with the SQL Server Compact Toolbox, there is a bug, if you have indexes that cover same columns as primary keys, that causes the crash. Try to re-gen the DataContext with the latest Toolbox addin (version 2.6.2 or later). Workaround for the issue is to delete the "duplicate" index.

这篇关于Windows Phone 7 SQL Server CE rowversion的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！