Is there anyway to use LinqDataSource or EntityDataSource instead of SqlDataSource for dynamic sql statements

See more:

C#

ADO.NET

Hi,

I have an application where the user inserts a sql statement and provides a connection string to a sql database, I run the statement and get him the result using a SqlDataSource. The problem is the SqlDataSource loads the result set completely into memory and and it takes much time, instead if I could use the LinqDataSource or EntityDataSource the performance will increase greatly.

The question is:
Is there a way to create the EntityFramework model or Linq To Sql programatically depending on the select statement and use either LinqDataSource or EntityDataSource instead.


Thanks in advanced for your suggestions.