Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
data access in plugins? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello - I was wondering what approach you use for data access in plugins?   I've mainly been using basic QueryExpressions on a single table.  I haven't needed to use a QueryExpression that joins multiple tables, up to this point, but I'm going to need to start writing more complex queries soon.

    I recently used the OData Query Designer, because I needed to make some ajax validation calls: (http://crm2011odatatool.codeplex.com/).  I really like this tool because it provides an intuitive UI that greatly simplifies the process of building odata queries.  afaik, odata is a client-side tool only.

    What are my options for server-side data access in plugins?  The only 2 I know of are QueryExpressions and FetchXML.  FetchXML queries can be downloaded from the Advanced Find dialog.  Is there a simplified way to build QueryExpressions, or do these need to be manually hand-coded?  Are there any other data access options for plugins, that I'm not aware of?

    Which data access approach do you find yourself using most often for single-table and multi-table queries? What are the pros and cons of each approach?

    Sunday, November 10, 2013 7:35 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Please check following tool, may be helpful for you.

    http://archive.msdn.microsoft.com/crmlinqpad

    Hope this helps. If you get answer of your question, please mark the response as an answer and vote as helpful !
    Vikram !

    Sunday, November 10, 2013 8:56 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I use late bind and Linq. its the recommended. slightly  slower but much better syntax. Much better then query expression and supports the same because converts to queryexpression. if you like query expression I recommend a query expression generator tool like stunware

    I Hope I could help. If I have answered please mark as 'Answer'. If was just helpful, please vote. Thanks and happy coding! Bruno Lucas, http://dynamicday.wordpress.com/

    Monday, November 11, 2013 9:47 AM