3

I have a database and I've created a DBML Linq-to-SQL file to represent this database. I've created a new aspx page and dropped a linqdatasource and a formview control onto it. When I configure the linqdatasource it gives me the choice only to select * from one table...but I want to pull from multiple tables. e.g. I have tables like simple_person, simple_address, simple_phone, and I want to pull from all of them. How can I accomplish this?

Dave Mackey
  • 4,306
  • 21
  • 78
  • 136

1 Answers1

6

Use a 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
Raj Kaimal
  • 8,304
  • 27
  • 18