using "transact sql" in crm 2011 plugin intead of LINQ RRS feed

  • Question

  • Hello,

    Just wondering ho to use "Transact-SQL" instead of LINQ in a PLUG-IN to retrive and write data to CRM.

    Is it the same as when we use "Transact-SQL" in a C# application to retreive and write data to an sql server?

    I would appreciate it if you provide some example helpful links.

    Thank you in advance.


    • Edited by Nick2020 Tuesday, November 12, 2013 4:58 PM
    Tuesday, November 12, 2013 4:41 PM


  • Nawaf,

    Any direct SQL transactions to the CRM database are unsupported.

    While the way to do it is same as working with SQL from a C# application, its not suggested way of working with CRM. CRM stores data of a single record in multiple tables and you might break the way it is done while working at SQL level. Also, you might be aware that the database structure has changed in CRM 2013 and once you upgrade your system, there is a high probability that your SQL queries (specially Write) will fail.


    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    • Marked as answer by Nick2020 Tuesday, November 12, 2013 7:24 PM
    Tuesday, November 12, 2013 6:29 PM