CRM 2011 - How to query back-end of CRM? RRS feed

  • Question

  • Hey guys,

    Im hoping you can help me out a bit here. Im going to be interviewing interns to help out with a CRM 2011 setup. I have several questions that I was supplied with that I am to ask the interns to test their knowledge, but I want to understand the questions myself. One of them is "How do you query the back-end of CRM?"

    Now I know how to run queries in the CRM using advanced find etc, but I dont think this is what is meant. What is meant by the "back-end" and how do you query it?

    Thanks for any help.

    Tuesday, November 13, 2012 7:21 PM


All replies

  • I assume "querying the back-end" means using the Microsoft CRM SDK?  Here is the method that you will need to use, but I assume you may want a broader understanding of the SDK in general.  These two links should help.



    If you meant "back-end" by directly querying the database then that should be discouraged since querying the db is not supported.  Modifying the db directly is also not supported and highly discouraged.



    Tuesday, November 13, 2012 7:45 PM
  • Querying the SQL database is supported.... Modifying is not....

    Rune Daub Senior Consultant - Dynateam CRM http://www.xrmmanagement.com

    Tuesday, November 13, 2012 8:56 PM
  • You can use Query Expression as Brandon said, instead you can use FetchXML to query the records from CRM back-end.

    But the are few drawbacks in FetchXML in terms of retrieving the number of records. 





    Tuesday, November 13, 2012 10:52 PM