LINQDataSource - multiple query tables?

Question

I have a database, and I created a Linq-to-SQL DBML file to represent this database. I created a new aspx page and dropped linqdatasource and the formview control on it. When I configure linqdatasource, it gives me a choice only to select * from one table ... but I want to extract from several tables. for example I have tables like simple_person, simple_address, simple_phone, and I want to extract everything from them. How can i do this?

Answer 1

Use custom query

http://weblogs.asp.net/scottgu/archive/2007/09/07/linq-to-sql-part-9-using-a-custom-linq-expression-with-the-lt-asp-linqdatasource-gt-control.aspx

See: Using the <asp:LinqDataSource> Selecting Event