DataSet From linq

[NewsBot]

So I have some Linq code that returns some IQueryable.

 

Now I want to take the query and return a DS (for some legacy systems that I dont have time to rewrite at the moment, but would still like to leverage the a common Linq framework).

 

If the Linq is very basic, it is trivial to get a DataSet back, just use an extension method like:

 

publicstaticDataSet LinqDS(thisIQueryable mySource)

{

***DataSet ds = newDataSet();

***using (SqlConnection connection = newSqlConnection(_connectionString))

***{

******using(SqlCommand command = newSqlCommand(mySource.ToString()))

******{

*********command.CommandType = CommandType.Text;

*********command.Connection = connection;

*********connection.Open();

*********SqlDataAdapter da = newSqlDataAdapter(command);

*********da.Fill(ds);

*********connection.Close();

******}

******return<font size=2> ds;

***}

}

 

Call it by something like:var o = from*d in DB.MyTable

******select d;

DataSet ds = o.LinqDS();

 

But if the Linq contains a where, this extension method won't work because of the way that Linq generates the sql query.

 

var o = from*d in DB.MyTable

***where d.Column1 > 0

******select<font size=2> d;

 

Would generate SQL like:

 

SELECT [t0].[Column1], [t0].[Column2]

FROM [MyDB].[dbo].[MyTable] AS [t0]

WHERE [t0].[Column1] <font color="#808080" size=2 face="Courier New"><font color="#808080" size=2 face="Courier New"><font color="#808080" size=2 face="Courier New">