Using a SQL statement like this: Code Snippet SELECT blabla..... INTO MegaCache FROM BluBla...... ALTER TABLE MegaCache ADD rowid INT IDENTITY NOT NULL ALTER TABLE MegaCache ADD PRIMARY KEY (rowid) I've created a table in which i want to read data... but before the data is valid i need to update all rows like this: Code Snippet Console .Out.WriteLine( "Altering Data: " ); var rows = from row in db.MegaCaches select new { row.rowid, row.SearchString }; int cnt = 0 ; foreach ( var item in rows) { db.ExecuteCommand(
Read More...