How do you perform an INSERT against a model using eSQL ?

Question

Hi,

I'm attempting to perform a DML operation against an Entity Framework model, specifically, an INSERT operation. My current eSQL string is:

INSERT INTO Contact (a, b, c) VALUES (1, 2, 3)

However, this triggers a runtime exception stating:

The query syntax is not valid. Near identifier 'INTO', line 1, column 8.

I'm having trouble tracking down eSQL examples using INSERT. Can anyone shed some light on this ?

Thanks

Answer 1

AFAIK, Entity SQL can only be used to query an entity model. It doesn't provide a grammar for create, update, or delete operations.