How to Retrieve more than 1 table with one LinqDataSource

Question

I've 4 tables in SQL database and I wanna Retrieve all tables in one asp.net web form on page load . but when I select Configure Data Source with LinqDataSource control I just can select one table at a time so is it possible to Select all the tables in one LinqDataSource control?

Manas Mohapatra · Answer

As far my knowledge the workaround is: create a procedure and call it from code-behind. Please go through below URL http://www.codedigest.com/Articles/ASPNET/293_Using_Stored_Procedure_with_LINQDatasource_Control_in_ASPNet.aspx