db.Execute(@"
INSERT INTO DeletedOrders
VALUES (@0, @1, @2, @3, @4, @5, @6, @7
, @8, @9, @10, @11, @12, @13, @14, @15, @16, @17)"
, AuditNum, qFullOrder.Price, qFullOrder.Status, qFullOrder.PricingTime
, qFullOrder.WordsNum, qFullOrder.DeliveryTime, qFullOrder.FileName
, qFullOrder.Lang, qFullOrder.Description, qFullOrder.Time, qFullOrder.Field
, qFullOrder.Subject, qFullOrder.Gender, qFullOrder.FirstName, qFullOrder.LastName
, qFullOrder.Cell, qFullOrder.Phone, qFullOrder.Email);
I have a table with 19 columns. The first one is of identity type. I want to perform the above query (with 18 columns) without putting all those 19 column names in the statment
(before values part). Although the first column is identity I get this error:
The number of columns in the query and the table must match.