This is a linqpad driver for connecting to SSAS tabular instances.
To install:
-
Download the driver (TabularLinqPadDriver.lpx) from the latest release
-
In Linqpad, click "Add connection".
-
In the "Choose Data Context" dialog, press the "View more drivers..." button.
-
In the "Choose a Driver" dialog, press the "Browse" button and select the file downloaded in step 1.
-
Back in the "Choose Data Context" dialog, select "SSAS Tabular" and click the next button.
-
In the SSAS Tabular connection dialog, supply your connection information.
-
You're done. You can write some code against your SSAS database now. For example:
var titles = from customer in Customer
where customer.TotalCarsOwned > 0 && customer.Gender == "F"
select new
{
Orders = customer.Internet_Distinct_Count_Sales_Order(),
Name = customer.FirstName + " " + customer.LastName,
Cars = customer.TotalCarsOwned,
Sales = customer.Internet_Total_Sales()
};
titles.Dump();