This is a migrated thread and some comments may be shown as answers.
Databinding with OpenAccess
1 Answer 69 Views
This is a migrated thread and some comments may be shown as answers.
SuperXRAY
Top achievements
Rank 2
SuperXRAY asked on 08 Mar 2009, 03:33 AM
Can someone post the code to Databind the WPF RadGrid with an OpenAccess DataProvider?

I cannot get anything to work!

1 Answer, 1 is accepted

Sort by
0
Jordan
Telerik team
answered on 10 Mar 2009, 01:48 PM
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.
Asked by
SuperXRAY
Top achievements
Rank 2
Answers by
Jordan
Telerik team
Share this question
or