In going through Scott Hanselman's "5 Minute Intro to ASP.NET Web Pages" here on this site using WebMatrix 3, I have created the SQL CE database as directed numerous times and when I attempt to add the data I continue to get an Invalid Data error "Your change
could not be committed to the database.... The column cannot be modified. [Column name = ID]"
The first column is labeled "ID", is type "bigint" and set up as "Primary Key" and "Identity". The rest of the columns are added as defined in the video as well. When I attempt to add data, the table never appears to be in true edit mode. There is no
asterisk on the LH side of the row being added although I can type information into the table cells. When I try to commit the row and star on the next, the error above comes up every time.
I have deleted and started over about 10 times and the same thing happens every time. I have searched for hours looking for a solution, buy no joy to this point.
Well....... WebMatrix 3 has broken db functionality. There is a thread here "Webmatrix 3 upgrade experience" or something along those lines where you will find all the details.
Forget about using it for now.
DatabasesqlerrorWebMatrix3
Will "mark as answered" if your answers help me. Will you do the same?
Thank you. I ran into this as well and did not understand what was going on. Now I know that it is a Webmatrix issue. I got around it by writing SQL to INSERT the records rather than entering directly.
Thanks for the answer, wavemaster! I thought that might be the case but then thought they never would have released it with that type of flaw. In any event, thanks again.
Any new information regarding this bug? Growing tired of having to write the SQL-querys by hand now that I've grown used to the simple interface WebMatrix offers, when it's working.
Member
3 Points
14 Posts
WebMatrix 3 SQL Server CE Database Read-Only, ID Column Cannot be Modified
May 05, 2013 07:35 AM|dmiannay|LINK
In going through Scott Hanselman's "5 Minute Intro to ASP.NET Web Pages" here on this site using WebMatrix 3, I have created the SQL CE database as directed numerous times and when I attempt to add the data I continue to get an Invalid Data error "Your change could not be committed to the database.... The column cannot be modified. [Column name = ID]"
The first column is labeled "ID", is type "bigint" and set up as "Primary Key" and "Identity". The rest of the columns are added as defined in the video as well. When I attempt to add data, the table never appears to be in true edit mode. There is no asterisk on the LH side of the row being added although I can type information into the table cells. When I try to commit the row and star on the next, the error above comes up every time.
I have deleted and started over about 10 times and the same thing happens every time. I have searched for hours looking for a solution, buy no joy to this point.
Any ideas?
Doug
Database sqlerror WebMatrix3
Doug
Contributor
2344 Points
2307 Posts
Re: WebMatrix 3 SQL Server CE Database Read-Only, ID Column Cannot be Modified
May 05, 2013 09:04 AM|wavemaster|LINK
Well....... WebMatrix 3 has broken db functionality. There is a thread here "Webmatrix 3 upgrade experience" or something along those lines where you will find all the details.
Forget about using it for now.
Database sqlerror WebMatrix3
Member
6 Points
28 Posts
Re: WebMatrix 3 SQL Server CE Database Read-Only, ID Column Cannot be Modified
May 05, 2013 11:33 AM|johnrichardosborne|LINK
Thank you. I ran into this as well and did not understand what was going on. Now I know that it is a Webmatrix issue. I got around it by writing SQL to INSERT the records rather than entering directly.
Database sqlerror WebMatrix3
Member
3 Points
14 Posts
Re: WebMatrix 3 SQL Server CE Database Read-Only, ID Column Cannot be Modified
May 05, 2013 01:56 PM|dmiannay|LINK
Thanks for the answer, wavemaster! I thought that might be the case but then thought they never would have released it with that type of flaw. In any event, thanks again.
Doug
Database sqlerror WebMatrix3
Doug
None
0 Points
1 Post
Re: WebMatrix 3 SQL Server CE Database Read-Only, ID Column Cannot be Modified
May 24, 2013 12:47 AM|JetJaguarXP|LINK
EPIC FAIL!
Database sqlerror WebMatrix3
Contributor
2344 Points
2307 Posts
Re: WebMatrix 3 SQL Server CE Database Read-Only, ID Column Cannot be Modified
May 24, 2013 07:46 AM|wavemaster|LINK
Unfortunately, Microsoft is moving at a snail's pace.
They have known about it for weeks now. But they leave the upgrade message and the Webmatrix 3 download out there.
Database sqlerror WebMatrix3
Member
1 Points
7 Posts
Re: WebMatrix 3 SQL Server CE Database Read-Only, ID Column Cannot be Modified
Jun 16, 2013 11:49 AM|RobertRoos|LINK
Any new information regarding this bug? Growing tired of having to write the SQL-querys by hand now that I've grown used to the simple interface WebMatrix offers, when it's working.
Database sqlerror WebMatrix3 WebMatrix3DatabaseBug
None
0 Points
1 Post
Re: WebMatrix 3 SQL Server CE Database Read-Only, ID Column Cannot be Modified
Jun 18, 2013 05:35 PM|slashd|LINK
Just bumped into this bug as well when I was following the WebMatrix 2 tutorial on
http://msdn.microsoft.com/en-us/library/hh145669(VS.99).aspx
The export to Visual Studio 2012 function doesn't work either. I get this message:
Database sqlerror WebMatrix3 WebMatrix3DatabaseBug