Entity Framework And MSBI Application

I am in the process of Designing BI Solution. I am going to use MSBI and ADO.net Entity Framework (Latest version).

Questions:

1. Which way to go Code 1st or Model/Data Base 1st?
2. How Can Entity Framewo开发者_Python百科rk additionally help me to build BI application with the Standard MSBI Tools?

this help will really help me to go ahead !

Regards!

Vineet

---

Entity framework is basic ORM for mapping OLTP database to .NET objects with ability to query that mapped database with linq-to-entities / ESQL converted to common SQL. If you need anything like that it will help you.

If you need SSAS, MDX queries, SSIS, SSRS it will not help you. It will only reduce performance of everything.

---

To query cube in your .Net code, you would need to go for ADOMD.Net which requires Microsoft.AnalysisServices.Adomdclient.dll reference.

---

First, you certainly need a data model for your Reporting/Data warehouse database. Only then you should design and develop your ETL.

In this case you won't be needing any Entity Framework.