Webmatrix 3 Sql Server Ce 4 Busted?

Ok, when I create a sql server CE .sdf database in the new Webmatrix 3 I run into a problem. I've narrowed an example down to this. 1) I create a table called test. One column 't

Solution 1:

I was faced today with the same problem. Already had a CE database prior to upgrading to WebMatrix 3, and I was no more able to insert new data even on existing tables as they have a column with a primary key and identity. I've come out with a solution until Microsoft releases a patch to overcome the situation. Try the following if you need to insert new rows with data.

1. In Home open a new Query document.
2. Insert a dummy row with some data with a line similar to the following: INSERT INTO tablename (columnname) VALUE ('dummydata')
3. Execute the query

A new row is created with dummy data (or with valid data if you are willing to) and a value is automatically generated for the primary key. Now, if you need, you can go and edit the row and fill it with the values you want. Repeat query execution if you need more rows.

Hope this somehow helps.

Regards