Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet


Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Friday, November 03, 2006

CCADO Classes in Dynamics AX 4.0

I wanted to take a quick break from my series on the future of Dynamics AX and Web 2.0, and talk a little bit about the CCADO classes. These classes represent a new way to access external data through code within DAX, which allows for the use of ADO vs. ODBC classes.

For me this is a wonderful step in the right direction, in which to be honest I missed. I missed the ability of creating object that represent table's through the use of ADO Recordsets. Now this is wonderful! The classes that are avaliable for this are:

CCADOConnection
CCADORecordSet
CCADOFields
CCADOField

The above classes can be made use to create an ADO connection to a given database, and then create multiple ADO RecordSets to work with.

Now let look at using these classes. When creating new code to make use of ADO Connection and recordset's, you always have to start with a connection. So the first class that you want to make use of would be the CCADOConnection object. With this object you can create your recordset through the use of a connection string. Once you have your connection, then you can build a recordset by creating a new CCADORecordSet object and call the .open() method with passing it the CCADOConnection open along with the T-SQL statement to retrieve the dataset with. The other two classes metioned above can be made use of for working with the Fields and a single Field within the RecordSet. Now there are other objects like the Command object which can be made use to execute updates and deletes, etc.

I want to mention here that all code should be design and developed in an OO way. Meaning that instead of working with raw Connections and RecordSets, you want to create objects that represent the data you are wanting to work with that handles the underlying updating, viewing, etc. With this you can then move forward in the right direction. To speak by example, if you have a table that contained: SID, UserName, Password, FirstName, LastName and you wanted to work with that table through ADO, then you would start out with creating an X++ class that represent the data as an object. So you would create a class that extended from the CCADORecordSet class that would have SID, UserName, Password, FirstName, and LastName as Parms of that class. The new would create the needed connection, and then you could choose to fill the who table and work with it as such, or supply a certian where clause to the end of the given T-SQL statement used to created and fill the object.

Well Check back soon as I continue on my path talking about the future for Dynamics AX and Web 2.0. The above though I wanted to get out here as it is Very useful, and very handy, and I am glad to see it replacing the use of the Older ODBCConnection classes.

Find a job at: www.DynamicsAXJobs.com

2 Comments:

Blogger Mkz said...

Hi :)

First of all ... congratz for your blog. You're doing a really nice work here with very interesting articles.

About this article I just want to say that this classes already exists in Axapta 3.0.

I'm totally agree with you that CCADO are much better than ODBCConnection classes.

You're able to play with timeouts parameters (commandtimeout ...)

Well, there is a little article explaining an example of use. Includes a little trick to help us to create the connection string.

I'm sorry but the article it's in Spanish :P

Here is the link : http://www.trucosax.com/phpnuke/modules.php?name=Forums&file=viewtopic&t=329

Kind regards,

Mkz.
-----------------------
http://www.trucosax.com
A Dynamics AX (Axapta) tricks site in Spanish language :)

12:03 PM  
Blogger brandon said...

Mkz,

First thanks for stopping by! Secondly I can't believe how long I have been using AX and never knew about the CCADO classes.

I just checked an instance of AX 3.0 and sure enough they are there. See I used ADO.Net when developing for C#, but made use of ODBCConnection, Statement, and ResultSet classes for working with Outside datasources, mainly because of when I looked at code for doing so, this is how I saw it.

All this time I could have made use of ADO??? Oh Well. Thanks for the update. I will make sure to post about, and your link soon!

-Brandon

1:13 PM  

Post a Comment

Links to this post:

Create a Link

<< Home


Copyright 2005-2011, J. Brandon George - All rights Reserved