This is a migrated thread and some comments may be shown as answers.

FETCHING PLANS

11 Answers 108 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

11 Answers, 1 is accepted

answered on 17 Apr 2009, 11:00 AM

Hi vignesh,

Here is a sample code where we execute multiple queries into one transaction:

    
                    IObjectScope scope = Database.Get("DatabaseConnection1").GetObjectScope(); 
        
                    { 
        
                        scope.Transaction.Begin(); 
        
                        { 
        
                            IQuery query1 = scope.GetOqlQuery("SELECT ord FROM OrderExtent AS ord"); 
        
                            IQueryResult queryResult1 = query1.Execute(); 
        
                            IQuery query2 = scope.GetOqlQuery("SELECT cust FROM CustomerExtent AS cust"); 
        
                            IQueryResult queryResult2 = query2.Execute(); 
        
                            for (int i = 0; i < 10; i++) 
        
                            { 
        
                                Order o = (Order)queryResult1[i]; 
        
                                Customer c = (Customer)queryResult2[i]; 
        
                                o.Customer = c; 
        
                            } 
        
                            Customer newCustomer = new Customer(); 
        
                            scope.Add(newCustomer); 
        
                            scope.Transaction.Commit(); 
        
                        }

In the code above we first execute two different SELECT queries in OQL which generate two different SQL queries for extracting the Orders and Customers from the database. After that we then edit some of the returned results in the "for" loop, add an additional record and call Transaction.Commit(). This further generates multiple UPDATE queries for all the edited "Order" objects(which we edited in the loop) and also an INSERT query for the newly created "Customer" instance.

Best wishes,
Zoran
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.

answered on 20 Apr 2009, 09:25 AM

Hi Vignesh,

Thank you for contacting us again.

Please always review the appropriate information available online in our documentation, demos, knowledge base and code library for general information and ask more specific questions here.

Even you might not find something to any related topic in any of these resource areas, it is worth checking, because these resources are being expanded continuously.

A good entry point for Stored Procedure is "Using Stored Procedures" or more directly "Update Data Using a Stored Procedure".

Please don't hesitate to contact us again for further questions.

Kind regards,
Peter Brunner
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.