Databinding with OpenAccess

[SuperXRAY]

Can someone post the code to Databind the WPF RadGrid with an OpenAccess DataProvider?

I cannot get anything to work!

[Jordan]

Hi SuperXRAY,

I attached a sample project.

First, I generated a wizard Product class from NorthwindOA database with open access.
Then, I added a reference to the RadGridView assemblies and created a DatabaseRepository class to handle with Open Access.

public class DatabaseReporsitory : IDisposable
{
    private IObjectScope scope;

    public DatabaseReporsitory()
    {
        this.scope = ObjectScopeProvider1.GetNewObjectScope();
        this.scope.TransactionProperties.AutomaticBegin = true;
    }

    public List<Product> GetProducts()
    {
        var result = from p in this.scope.Extent<Product>()
                     select p;

        return result.ToList();
    }

    public void DeleteProduct(Product product)
    {
        this.scope.Remove(product);
    }

    public void SaveChanges()
    {
        this.scope.Transaction.Commit();
    }

    public void Dispose()
    {
        if (this.scope != null)
        {
            this.scope.Dispose();
            this.scope = null;
        }
    }
}

Below is shown how it works with RadGridView

public class DatabaseReporsitory : IDisposable
{
  private IObjectScope scope;

  public DatabaseReporsitory()
  {
    this.scope = ObjectScopeProvider1.GetNewObjectScope();
    this.scope.TransactionProperties.AutomaticBegin = true;
  }

  public List<Product> GetProducts()
  {
    var result = from p in this.scope.Extent<Product>()
                 select p;

    return result.ToList();
  }

  public void DeleteProduct(Product product)
  {
    this.scope.Remove(product);
  }

  public void SaveChanges()
  {
    this.scope.Transaction.Commit();
  }

  public void Dispose()
  {
    if (this.scope != null)
    {
        this.scope.Dispose();
        this.scope = null;
    }
  }
}

Some other links that can help you:
OpenAccess, WCF, and a RadGrid
Insert, Update, Delete with OpenAccess and RadGridView for Silverlight

Kind regards,
Jordan
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.