[Solved] Nhibernate 3 with ajaxfied Grid

[Konrad]

Is it possible to use nhibenrate with ajaxfied grid? When I try to bind data i get error message

Incorrect syntax near 'Index'. If this is intended as a part of a table hint, 
A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.
 

My Grid:

@(Html.Telerik().Grid<Product>()
    .Name("Grid")
    .DataBinding(dataBinding => dataBinding.Ajax().Select("_GetProducts", "Home"))
    .Columns(c =>
    {
         c.Bound(o => o.Name).Title("name");
    })
    .Groupable()
    .Sortable()
    .Pageable()
    .Filterable()
My repository method:
public IList<Product> GetProducts()
{

   return _session.Query<Product>().Where(x => x.Status == "A").ToList<Product>();

}

[Andy]

I've managed to get NHib3.0 working with Grid using Ajax calls.   The DataBinding.Ajax().Select("_GetProducts", "Home") instructs the grid to call HomeController._GetProducts()    _GetProducts should have the [GridMethod] attribute applied to it and return the GridModel( Repository._GetProducts() as IQueryable).  

I'm using these two methods in my controller - Index is the first view, subsequent Ajax callbacks use AjaxSelect.

public ActionResult Index()
{
    var myClients = from c in _repository.Queryable
select new ClientViewModel
            {
                Id = c.Id,
                ClientName = c.ClientName,
                Comments = c.Comments,
                WebPage = c.Web
            };
    return View(myClients);
}

[GridAction]
public ActionResult AjaxSelect()
{
    return View(new GridMode<ClientViewModel>
    {
        Data = from c in  _repository.Queryable
                select new ClientViewModel
                {
                    Id = c.Id,
                    ClientName = c.ClientName,
                    Comments = c.Comments,
                    WebPage = c.Web
                }
     });
}

 

Andy