Modifying a column with the 'Identity' pattern is not supported in WCF RIA Services

Posted by Banford on Stack Overflow See other posts from Stack Overflow or by Banford
Published on 2010-05-06T17:07:20Z Indexed on 2010/05/07 9:38 UTC
Read the original article Hit count: 599

Filed under:

sql-server-2008

|

wcf-ria-services

|

entity-framework

I've been following the walkthrough for creating your first WCF RIA Services Application from Microsoft and have encountered a problem when trying to edit and update data using the SubmitChanges() method of the Data Context.

The table being updated has an Identity Specification set in SQL Server 2008 on the 'CourseID' column. However the PRIMARY key is a composite of two other fields.

When using SubmitChanges() the application locks up in the browser an presents an unhandled exception. By handling this exception I managed to get the message: Modifying a column with the 'Identity' pattern is not supported. This is referring to the 'CourseID' column.

Turning identity specification off solves the problem, but I need the auto-incrementing ID. In what way isn't this supported. Or where am I going wrong?

© Stack Overflow or respective owner

Related posts about sql-server-2008

Cumulative Update packages for SQL Server 2008 R2 RTM & SQL Server 2008 SP1

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Here is the news on Cumulative Update release news on SQL Server 2008 R2 RTM & SQL Server 2008 Service Pack 1. First let us go through SQL Server 2008 R2 RTM cumulative update, release consist the only hotfixes that were released in Cumulative Update 5, 6, & 7 for SQL Server 2008 SP1. Cumulative… >>> More
SQL Server 2008 Vs Sql Server 2008 R2 in web-development

as seen on Stack Overflow - Search for 'Stack Overflow'
This will give many opportunities in Web-development transition from Sql Server 2008 to Sql Server 2008 R2: 1.If database in one instance of SQL Server. 2.a) if in the server PC have 1 processor b) if in the server PC have 4 processors >>> More
SQL Server 2008 to SQL Server 2008

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an MDF and LDF file of SQL Server 2005. i attached it with SQL Server 2008 and did some change in data. now when i attached it back to sql server 2005 Express Edition it gives version error. The database 'E:\DB\JOBPERS.MDF' cannot be opened because it is version 655. This server supports version… >>> More
SharePoint 2010 – SQL Server has an unsupported version 10.0.2531.0

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I am trying to perform a database attach upgrade to SharePoint Foundation 2010. At this point I am trying to attach the content database to a Web application by using Windows Powershell: Mount-SPContentDatabase -Name <DatabaseName> -DatabaseServer <ServerName> -WebApplication <URL>… >>> More
Uninstalling Reporting Server 2008 on Windows Server 2008

as seen on SQL Blog - Search for 'SQL Blog'
Ha. I had quite disputable pleasure of installing and reinstalling and reinstalling and reinstalling – I think about 5 times before it worked – Reporting Server 2008 on Windows Server with the same year number in name. During my struggle I came across an error which seems to be not quite unfamiliar… >>> More

Related posts about wcf-ria-services

How to eager load in WCF Ria Services/Linq2SQLDomainModel

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a databound grid at my view (XAML) and the Itemsource points to a ReportsCollection. The Reports entity has three primitives and some complex types. These three are shown as expected at datagrid. Additionally the Reports entity has a property of type Store. When loading Reports via GetReports… >>> More
WCF Ria Services For Real

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In my previous post I discussed creating the database and tables for the Silverlight HVP configuration data. All that was great, and worked just dandy until it was time to get the data from the database server to the application running on the client. But, I thought, How hard can it be? … >>> More
WCF Ria Services For Real

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In my previous post I discussed creating the database and tables for the Silverlight HVP configuration data. All that was great, and worked just dandy until it was time to get the data from the database server to the application running on the client. But, I thought, How hard can it be? … >>> More
Visual Studio RTM, Silverlight 4 RTM and WCF RIA Services download links

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Its been a long time since I blogged. Primarily due to Tech Ed India, the ongoing Great Indian Developer Summit (GIDS 2010) and the related travels. However, here is a quick post with a few updates. Visual Studio 2010 RTMed in India during Tech Ed. We had the privilege of having Soma our Senior… >>> More
Visual Studio 2010 RC – Silverlight 4 and WCF RIA Services Development - Updates from MIX Anno

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
MIX is happening and there is a lot of excitement around the various releases such as the Windows Phone 7 Developer Preview, IE9 Platform Preview and few other announcements that have been made. Clearly, the Windows Phone 7 Developer Preview has generated the maximum interest and opened a plethora… >>> More