Will Entity Framework Asp.net helps me in this scenario

See more:

ASP.NET

Hi All,

I have a scenario in which I want to know how the Entity Framework will help ?


The scenario is as follows:

1. I have 2 UI one will be a Windows application and the other will be Sharepoint Webpart. Both are the same just as per user's needd it has been made.

2. Now need to connect to DB and get data from few tables in one go, (through WCF )
So WCF will be having the Data Access Layer.

3. Here I am planning to use Entity framework Where this will connect the WCF's DAL and retrieve all the data into a single .edmx file.

4. Now I can do edit/delete details in the tables and then send back the .edmx details through WCF and update the same in SQL Server DB.

In this case how the Entity framework will help and is there code sample to connect entity framework through WCF please let me know.


Thanks & Regards,
Mathi.