Flash Remoting Article

ADO.NET Connectivity with Macromedia Flash Remoting MX

Overview of ADO.NET

As I briefly mentioned, Flash Remoting relies on server-side development technologies to connect and manipulate data in a database. From this server-side object, Macromedia Flash can create a disconnected or connected recordset of database results. In the case of Flash Remoting with .NET, a robust library of objects called ADO.NET handles database management and connectivity.

The main advantage of ADO.NET is its ability to create a disconnected recordset. This means a .NET application retains database information in memory while closing its database session. Most other platforms maintain a session with the database throughout a page’s execution—even after data has been retrieved. Using a disconnected recordset can drastically reduce database connections and increase the overall speed and scalability of a .NET application.

ADO.NET also serializes disconnected data as an XML file to easily send even the most complex data over the web or save it to disk. Flash Remoting can easily recode this disconnected data into its own language and deliver the data directly to a Flash application.

In addition, ADO.NET has built-in support for multiple types of data sources. Developers can easily query CSV (comma-delimited) files, XML files, Access databases, and other data sources using SQL statements. ADO.NET then serializes the data and transfers it to Flash.

Page 2 of 4

Previous Page

Next Page