APL Wiki
Microsoft's Project Jasper
Currently an incubation project of the Data Access and Storage section at Microsoft, Jasper is a set of .NET classes "geared towards interative and agile development". For the download links check: http://msdn2.microsoft.com/en-us/data/bb419139.aspx
The idea behind the project is to have the runtime generate all the data access classes without the need for the developer to write them manually. In fact it's easier to show a sample, in our beloved Dyalog 11 than to read the documentation. I translated the sample from the example in Python (which is a lovely language, easy to read and understand).
In order to iterate through the collections returned by the various methods, let's first define a sample operator foreach.
r←(fn foreach)coll;x
r←⍬
:For x :In coll
r,←⊂fn x
:EndForconn is the connection string:
Provider='System.Data.SqlClient';Provider Connection String='Data Source=.\SQLExpress;Initial Catalog=Northwind;Integrated Security=True;';Generate Default EDM=True;
Now, the test function.
test;⎕USING;ctx;cust;custQuery;orderQuery
⎕USING←'' 'Microsoft.Jasper,C:\Programmi\Microsoft Codename Jasper CTP\Binaries\Microsoft.Jasper.CTP.dll'
ctx←DynamicContext.CreateDynamicContext⊂conn
⍝ direct access
⎕←{⍵.CategoryName}foreach ctx.Categories
⍝ simple query
⎕←↑{⍵.(ProductName UnitPrice)}foreach ctx.Products.Where'it.ProductName = ''Chai'''⍬
⍝ find by key
cust←ctx.Customers.FindByKey⊂,⊂'AROUT'
⎕←cust.(CustomerID CompanyName)
⍝ composite query
custQuery←ctx.Customers
custQuery←custQuery.Where'it.Country = ''USA'''⍬
custQuery←custQuery.OrderBy'it.CompanyName'⍬
custQuery←custQuery.Select'it.CustomerID, it.CompanyName, it.City'⍬
⎕←↑{⍵.(CustomerID CompanyName City)}foreach custQuery
⍝ relationship navigation in query
orderQuery←ctx.Orders.Where'it.Customer.CompanyName = ''Around the Horn'''⍬
⎕←↑{⍵.(OrderID OrderDate)}foreach orderQuery
Easier than writing SQL queries and no need to write any other code except what I listed here. I am amazed.