Last post Jun 18, 2013 05:35 PM by slashd
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.
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.
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.
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.
May 24, 2013 12:47 AM|JetJaguarXP|LINK
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.
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.
Jun 18, 2013 05:35 PM|slashd|LINK
Just bumped into this bug as well when I was following the WebMatrix 2 tutorial on
The export to Visual Studio 2012 function doesn't work either. I get this message:
The following files were specified on the command line:
These files could not be found will not be loaded