ASP.NET Executing Stored Procedure Using LINQ

[Vijay Jadhav India]

Hi Experts, I have Query as : SELECT StudentID, AcademicDetails, FirstName as "PersonalDetails/FirstName", MiddleName as "PersonalDetails/MiddleName", LastName as "PersonalDetails/LastName" FROM tb_M_StudentInfo WHERE FirstName = 'sarang' FOR XML PATH('Student'), ROOT('Sis'), ELEMENTS XSINIL Which returns Xml output as :

<Sis xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Student>
<StudentID>1</StudentID>
<AcademicDetails>MCA</AcademicDetails>
<PersonalDetails>
<FirstName>Sarang</FirstName>
<MiddleName>Bal</MiddleName>
<LastName>Patil</LastName>
</PersonalDetails>
</Student>
</Sis>

How do I return above Xml from Stored Procedure Using LINQ. Sample code would be greatly appreciated! Thanks.

Vijay Jadhav.