IObjectScope scope;
scope = ObjectScopeProvider1.GetNewObjectScope();
Add new Object to database
scope.Transaction.Begin();
ClassLibrary1.Customer cus = new ClassLibrary1.Customer();
cus.Address = "sadsds";
cus.City = "wsd";
cus.FullName = "sds";
cus.Country = "dssad";
scope.Add(cus);
scope.Transaction.Commit();
Add relational obeject to database
IObjectScope scope = ObjectScopeProvider1.ObjectScope();
scope.Transaction.Begin();
Customer customer = new Customer();
customer.CustomerName = "Bob";
customer.CustomerNumber = 123;
Order order = new Order();
order.OrderNumber = 1;
customer.Orders.Add(order);
scope.Add(customer);
scope.Transaction.Commit();
Retrieve data to GridView
var Cone = ObjectScopeProvider1.ObjectScope();
var Customer = from p in Cone.Extent
select new
{
Name= p.FullName,
add= p.City
}
;
RadGrid1.DataSource = Customer;
RadGrid1.DataBind();
Edit Existing object
Customer firstCustomer =
scope.Extent
firstCustomer.CompanyName =
"Company " + DateTime.Now.ToString("hmsfff");
scope.Add(firstCustomer);
Using PivotGrid in C#.NET
ReplyDelete