How do you perform an INSERT against a model using eSQL?
I'm att开发者_开发知识库empting 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
AFAIK, Entity SQL can only be used to query an entity model. It doesn't provide a grammar for create, update, or delete operations.
精彩评论