locked
DML operation using EntityClient with Entity-Sql RRS feed

  • Question

  • User-1519258731 posted

    I haven't get proper documentation on EntityClient with EntitySql. Why?

    https://msdn.microsoft.com/en-us/library/bb738573.aspx#Anchor_13  after reading from this link, what is the use of entity-sql?

    Is it only for reading data, no DML ?

    PLease provide documentation or example for performing DML using EntityClient with Entity-Sql

    Thanks!

    Friday, April 7, 2017 2:38 PM

Answers

  • User-707554951 posted

    Hi narendra_globalsysinfo,

    narendra_globalsysinfo

    what is the use of entity-sql?

    Is it only for reading data, no DML ?

    The ADO.NET Entity Framework contains a powerful client-side query engine that allows you to execute queries against the conceptual model of data, irrespective of the underlying data store in use. This query engine works with a rich functional language called Entity SQL (or E-SQL for short), a derivative of T-SQL, that enables you to query entities or collection of entities.

    E-SQL is a text-based, provider independent, query language used by Entity Framework to express queries in terms of EDM abstractions and to query data from the conceptual layer of the EDM.

    As far as I know, Entity-Sql does not support DML operation.  is used to query data.

    For more information. Please read the articleds below:

    https://www.packtpub.com/books/content/working-entity-client-and-entity-sql

    Best  regards

    Cathy

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 10, 2017 2:46 AM