Pull Skype chat history out into XML and then query it using LinqPad

linqpad.cs

var xml = XElement.Load(@"C:\users\matthew\desktop\query.xml");

var names = new string[] { "" }; //Full names of participants to look for

var messages = xml.Elements("Table")
  .Where(a => names.Any(a.Element("participants").Value.Split(' ').Contains))
	.Where(a => a.Element("body_xml") != null)
	.Where(a => a.Element("author") != null)
	.Select(a => new 
	{ 
		From = a.Element("author").Value, 
		Msg = a.Element("body_xml").Value, 
		Timestamp = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(long.Parse(a.Element("timestamp").Value))
	})
	.OrderBy(a => a.Timestamp)
	.Dump();

loaddata.cs

using (var conn = new SQLiteConnection("Data Source=C:\\users\\matthew\\desktop\\main.db; Version=3"))
            {
                conn.Open();
                using (var comm = conn.CreateCommand())
                {
                    comm.CommandText = "select * from Messages inner join Chats on messages.chatname = chats.name";
                    comm.CommandType = System.Data.CommandType.Text;
                    using (var adaptor = new SQLiteDataAdapter(comm))
                    {
                        using (var ds = new DataSet("Query"))
                        {
                            adaptor.Fill(ds);
                            ds.WriteXml("C:\\users\\matthew\\desktop\\Query.xml");
                        }
                    }
                }
            }