locked
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

Answers

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.

    http://msdn.microsoft.com/en-us/library/microsoft.xrm.sdk.iorganizationservice.retrievemultiple.aspx

    http://msdn.microsoft.com/en-us/library/bb219490.aspx

    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.

    Thanks,

    Brandon

    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. 

    http://msdn.microsoft.com/en-us/library/bb928434.aspx

    http://msdn.microsoft.com/en-us/library/gg328332.aspx.

    Cheers

    Jeyan

    Tuesday, November 13, 2012 10:52 PM