I'm looking for a way to insert a (largish) XML file into a SQL table. I thought this should be pretty straight forward with .net, but I've been having a heck of a time finding any help at all with this.

I've gotten a 'row' from my XML data using a LINQ query, and now I don't know what to do with it. The only way I can think of to do this is to build an INSERT string and use the SQL command. The problem is that I'm not sure how to reference the individual elements of the XElement (from the LINQ).

My brain hurts and this may not make any sense. Can anyone help me out?