I’m pleased to announce PHPLinq currently supports basic querying of Windows Azure Table Storage. PHPLinq is a class library for PHP, based on the idea of Microsoft’s LINQ technology. LINQ is short for language integrated query, a component in the .NET framework which enables you to perform queries on a variety of data sources like arrays, XML, SQL server, ... These queries are defined using a syntax which is very similar to SQL.
Next to PHPLinq querying arrays, XML and objects, which was already supported, PHPLinq now enables you to query Windows Azure Table Storage in the same manner as you would query a list of employees, simply by passing PHPLinq a Table Storage client and table name as storage hint in the in() method:
[code:c#]
$result = from('$employee')->in( array($storageClient, 'employees', 'AzureEmployee') )
->where('$employee => $employee->Name == "Maarten"')
->select('$employee');
[/code]
The Windows Azure Table Storage layer is provided by Microsoft’s PHP SDK for Windows Azure and leveraged by PHPLinq to enable querying “the cloud”.
- More on Windows Azure?
- More on PHP SDK for Windows Azure? (also see my previous blog post)
- More on PHPLinq? (also see my previous blog post)
.aspx)