SQL query Syntax Select all record from table

If you want to select everything from a table then use the follwing syntax:

SELECT * FROM table_name;

Here table_name is the name of the table of which you want to select the records.

This is basically see all record / data query.

Fetching data from SSAS cube in MVC 4.5

I need data in my mvc app coming from SSAS cube. I am not able to open the data source connection. Firstly i was extracting it using SQLClient Data provider using a sqlconnection. I was thrown a error <{"Cannot open database \"DataBASENAME\" requested by the login. The login failed.\r\nLogin failed for user 'Domain\user'."}>

Then I changed my provider TO MSOLAP.5 in connection string. Then also i am getting same error. After a research I came to know that namespace Microsoft.AnalysisServices.AdomdClient is used while connecting to analysis database. But I am not able to get the dll for it to make it a reference.

Please suggest with an example how to get it done. Requirement is data from SSAS cube needs to be fetched on MVC Application. please tell the name space and connection string and data flow if ever handled such situation. Thanks in Advance.

A Reply for connection string From DevMitra:

Connection String must be 

<add name="ConnectionStringName" connectionString="Data Source=ServerOrMachineName;Initial Catalog=DatabaseName;" providerName="MSOLAP.4" />

this is the correct string while data is need to be fetched from Analysis Services.