data access in plugins? RRS feed

  • Question

  • 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

  • Please check following tool, may be helpful for you.


    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
  • 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