Webmatrix 3 Sql Server CE 4 Busted? -

ok, when create sql server ce .sdf database in new webmatrix 3 run problem. i've narrowed example down this.

1) create table called test. 1 column "test_id" bigint, primarykey, , identity. 2) create column called "test_desc" nvarchar(50) defaults.

problem.

i cannot insert data using gui. column name cannot modified. annoying , disappointing new release have such huge bug off go. else run or have work around? write sql statement inserts, might work. why have gui?

also, created new database webmatrix 3 , problem still existed (original site created webmatrix 2 , data entry gui worked fine webmatrix 2 on tables not accept inserts webmatrix 3).

also did uninstall , reinstall laughs, no love.

i faced today same problem. had ce database prior upgrading webmatrix 3, , no more able insert new data on existing tables have column primary key , identity. i've come out solution until microsoft releases patch overcome situation. try following if need insert new rows data.

1. in home open new query document.
2. insert dummy row data line similar following: insert tablename (columnname) value ('dummydata')
3. execute query

a new row created dummy data (or valid data if willing to) , value automatically generated primary key. now, if need, can go , edit row , fill values want. repeat query execution if need more rows.

hope somehow helps.

regards