Friday, July 31, 2009

Telerik ORM Guids

How to create DB Connection

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().Take(1).Single();
firstCustomer.CompanyName =
"Company " + DateTime.Now.ToString("hmsfff");
scope.Add(firstCustomer);



1 comment: