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


    Friday, April 7, 2017 2:38 PM


  • User-707554951 posted

    Hi 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:


    Best  regards


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