How to Use Entity Frame work With XML field's in Relational Database

Question

Hi ,

I want to make a n-tier application with ado.net Data services . but i have a big problem .

I have a Database that Contains a Table with xml Data . this Table have Six columns .

 

Persons

--> intPersonID (int)

--> xmlContent (xml)

--> dtmLastModified (datetime)

--> dtmCreationDate (datetime)

--> intCreatorID (int) 

--> intLastModfierID (int) 

 

 

In the xmlContent Field I Have Three Node Like This :

 

Code Snippet

<Person>

<PersonInfo>

   <FullName>jfk lop</FullName>

   <Name>jfk</Name>

   <Family>lop</Family>

<PersonInfo>

<Internet>

<Email type="private">

[e-mail]

<Email>

<Email type="public">

[e-mail]

<Email>

</Internet>

 

<Addresses>

<Address type="Home"> every where may I raom . <Address>

<Address type="Work"> every where may I raom 2 . <Address>

</Address>

 

</Person>

 

 

 

 

so.....

 

I want To Generate an Entity Model for This xml field and Crud Operation Like The Relational Databases .

 

so , How can I generate and Modify on this xml filed ?

Any Idea ?

 

Thanks .