How to create model from two different table entity usin entity framework 4.0

Question

0.00/5 (No votes)

See more:

I have four tables Employee_Details,Employee_Contact_Details,Department_Wise_Employee and Skill_Wise_Employee.

I have to make one model from four different table entities.
So i have to write only one CRUD operation due to which all fours table get updated.

Posted 29-Aug-12 0:09am

RomilGandhi

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jitendra Sabat · Answer 1 · 2013-08-01T23:42:00

You can create a 'View' of all the 4 tables which will have selected fields from your 4 tables Employee_Details,Employee_Contact_Details,Department_Wise_Employee and Skill_Wise_Employee.Now create an entity model of your 'View' according to your attributes present in 'View'.For 'View' refer to following sites.

http://odetocode.com/articles/299.aspx[^]

http://www.w3resource.com/sql/creating-views/create-view-with-join.php[^]

You can write LINQ queries taking into account your entity model class corresponding to created View.Make sure that the View name in database should be same with your model entity class name.Then you can carry out CRUD operations as like as in normal entity models.

Manish (Mack) · Answer 2 · 2013-08-01T22:15:00

Solution 1

Quote:
You have to maintain relationship between all the four table's.
Then you have to add a ADO.NET Entity Framework in your project.
select all the required table's from your database.

And the last one is to use LINQ to SQL query for writing CURD query's

Posted 1-Aug-13 22:15pm

Manish (Mack)