Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Nawaf


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

Answers

  • Question
    Sign in to vote
    2
    Sign in to vote

    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.

    HTH

    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