I know ig grid needs a IQueryable object.

I know you apend the paging function in GridDataSourceAction aginst Linq. 

My question is that I only have some sql now. How can I convert these SQL to an IQueryable object, and I don't want to lost the delay query feature.

For example. I have "Select * from Issues''. Issues table has a lot of rows, So I need the paging feature.

following is the code I want:

[GridDataSourceAction]
[ActionName("PagingGetData")]
public ActionResult PagingGetData()
{
 var ds= ConverSqlToQuerable(" I have "Select * from Issues'"); 

   //Here, I don't want query data from DB.
   //I have a lot of Rows in DB. So I need deley DB query 
   // until GridDataSourceAction appends the
   // paging filter at the tail of my sql.

    return View("RowSelection", ds);
}

My question looks like an Linq question more. But I'm hoping get some suggestion from your guys.

Thank you!.

hi Borislav

Thank you! I have tried Devart LINQ to SQL. It's exact what I want.

I have following codes.

IQueryable<Currency> currencies = context.Query<Currency>("select * from Currencies");
currencies = currencies.Where<Currency>(c => c.CurrencyISOCode.Equals("1"));
var list = currencies.ToList<Currency>();

Here is the generated SQL:

(@p0 nvarchar(1))SELECT [t1].CurrencyNumber AS [CurrencyNumber], [t1].CurrencyISOCode AS [CurrencyISOCode]  FROM (      select * from Currencies      ) [t1]  WHERE [t1].CurrencyISOCode = @p0

No prob - glad you liked the solution :)
And thanks for sharing the code needed in order to get it going.

Let me just beautify it for anyone reading this thread:

IQueryable<Currency> currencies = context.Query<Currency>("select * from Currencies");

currencies = currencies.Where<Currency>(c => c.CurrencyISOCode.Equals("1"));

var list = currencies.ToList<Currency>();

which translates to:  
(@p0 nvarchar(1))
 SELECT [t1].CurrencyNumber AS [CurrencyNumber], 

 [t1].CurrencyISOCode AS [CurrencyISOCode]  
 FROM (      select * from Currencies      ) [t1]  
 WHERE [t1].CurrencyISOCode = @p0