How to use LINQ with stored proc in SQL to output xml

Question

I am new to LINQ. I would like to execute a stored proc using LINQ and output to an XML file. How would I go about this?

DataContext db = new DataContext();
var mysp = db.sp;

now what, I want to keep the xml structure in the sp, currently I am running the sp without for XML auto, but my ideal results are with for XML auto in the proc.

Thanks in advance

Answer 1

Hope this helps http://www.vsj.co.uk/xml/display.asp?id=636