[Q] LINQ to XML - help need from SQL
I'm porting an app which uses SQL to query a SQLCE db.
Now under WP7 I switched over to XML files.
Can anyone help me to "translate" the following SQL sentence to Linq to XML ?
Dim SQL As String = String.Empty
Dim USERENTRY As String = String.Empty
SQL = "SELECT Info.INFO_COMMENTS FROM Names INNER JOIN Info ON Names.NAME_ID = Info.INFO_NAME_ID "
SQL = SQL + "WHERE (Names.PARENTS_NAME_ID = " & "'" & USERENTRY & "') "
SQL = SQL + "GROUP BY Info.INFO_COMMENTS "
SQL = SQL + "ORDER BY Info.INFO_COMMENTS"
My skills are very low right now to deal with this...
On the other hand, if someone can point me to a some kind of tool to make the conversion or a great tutorial, that will be great too!
Thanks in advance for any help.