ADO.NET Data Services

Table of Contents

Description

This extension contains functions for retrieving data via ADO.NET Data Services.

See also How to add an extension, Using the Extension Dialog, Learn about DekiScript, Extensions Directory.

Notes:

Additional information can be found at the ADO.NET Data Services web site. At the present moment it appears that this extension only works with data hosted via the experimental ADO.NET Data Service (also known as Astoria) based on the Project "Astoria" prototype, hosted by Microsoft. You can create your own free data service with a maximum capacity of 100MB. You will need a passport account. Since it is an experimental service under active development, there may be periods where your service is unavailable. There are some additional sample data-sets that you can use to experiment with the service, incuding a subset of the Encarta Encyclopedia article base.

Configuration:

AdoNet extension has optional configuration settings that you can define globally. Alternatively, this information can be included in every use of the extension.

Functions:

1. adonet.table
2. adonet.list
3. adonet.value

adonet.table(resource: str, expand: str, filter: str, orderby: str, skip: num, top: num, columns: map, dataservice: uri) : xml

Embed a table of data from an ADO.NET Data Service. The standard URI parameters used when connecting to an ADO.NET Data Service via a browser generally apply here.

Parameters:

Name	Type	Description
resource	string	resource name with optional query logic. Example: Products[ProductName eq 'Chai']
expand	string	nested resources to expand (default: none)
filter	string	filter records by (default: return all records)
orderby	string	order records by (default: none)
skip	int	number of records to skip (default: 0)
top	int	number of records to return (default: 100)
columns	map	record columns to table columns mapping ({ Customer: { LastName: 'Last', FirstName: 'First' }, Order: { OrderID: 'ID'} }; default: all columns)
dataservice	uri	URI to ADO.NET data service. Optional if provided in the service configuration.

Samples:

	Output
A table displaying specific Employee columns from the Northwind data service. {{adonet.table{resource: "Employees", columns: {Employee: {LastName:"Last", FirstName:"First", BirthDate:"BirthDate", HireDate:"HireDate", Address:"Address", City:"City", PostalCode:"Zip", HomePhone:"Phone", PhotoPath: "Photo" } }, dataservice: "http://astoria.sandbox.live.com/northwind/northwind.rse" } }}

 

---